Hi all
Can no non text garbage in a VarChar field cause database corruption?
I have this 1 office that keeps getting corruption in this 1 table. At first
we thought it was a bad network connection but this last time they were using
the server or local computer.
We look up text from a Varchar column in a table, then run a series or SRPL to
merge date into the text, then update the table and save the text into a
VarChar field. We only use plain text in this field, no bold or anything like
that, it seems to mess up the SRPL.
This works great in several offices without any problems but this one office
has been a PIB, Their tech and I have checked everything we can think of and
at this point all I can think of is there is some junk data in the Varchar
fields that is corrupting the DB but I do not know if that is possible or how
to look for the problem.
Any suggestions would be greatly appreciated
Marc
SET VAR vadjdesc3 =((SRPL ((SRPL((SRPL((SRPL((SRPL((SRPL((SRPL +
((SRPL (.vadjdesc2, '[sx1]', (IFNULL(.vsympt1, +
NULL,.vsympt1)),0)),'[Pain1]', (IFNULL(.vpain1, +
NULL,.vpain1)),0)), '[sbw1]',(IFNULL(.vsbw1, +
NULL,.vsbw1)),0)),'[PART1]',(IFNULL(.vpart1, +
NULL,.vpart1)),0)), '[Therapy1]',(IFNULL(.vtherapy1, +
NULL,.vtherapy1)),0)),'[Adj1]',(IFNULL(.vadj1, +
NULL,.vadj1)),0)), '[TxNotes1]',(IFNULL(.vtxnotes1, +
NULL,.vtxnotes1)),0)),'[VisitNotes]',(IFNULL(.vvisitnotes, +
NULL,.vvisitnotes)),0)) )
-- we have several of these... then
SET VAR vsubjall2 = (SRPL(.vsubjall,'^',(CHAR(10)),0 ))
UPDATE travcard SET subjx = .vsubjall2 +
WHERE custnum = .cust# AND txdate =.vtxdate
PROPERTY table travcard 'refresh'
