In one of my vertical applications I have a form that is used to create FAX
cover sheets. The text body of the FAX cover is stored in a VARCHAR and is
entered via an RTF memo field on a form. Normally, this process works
flawlessly but on occasion the VARCHAR becomes corrupted after the data is
saved. When you look at the data, you can see the RTF formatting; and the
text is truncated at 246 characters (see example below). It acts like it
saved the data as TEXT rather than a VARCHAR. There are no errors when you
run Autochk or when you reload the database.
Sample of data in VARCHAR:
{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fswiss\fprq2\fcharset0
Calibri;}{\f1\fnil\fcharset0 Times New Roman;}}
\viewkind4\uc1\pard\sa200\sl276\slmult1\lang1033\f0\fsn, was in to be fitted
for diabetic shoes. Please revise forms, sign and date b
Other related info
The data is inputted through a form that is based on a temporary table. The
temp table is projected from the production table; column for column. The
data types are exactly the same for both tables. When the form is closed,
the master table is updated with the data from the temp table.
It looks to me like the data is being save as straight text rather than
VARCHAR. I have no idea how that could happen. I don't think that there is
anything that I could do (code wise) to cause this to happen.
My application is running on V8 compiled (latest revision).
The failure occurs at multiple clients and multiple hardware configurations.
Very intermittent.
Your thoughts and suggestions will be appreciated.
John Engwer
Engwer & Associates
2449 Scenic Ridge Drive
North Huntingdon, PA 15642
Phone: (412) 751-2433
Email: [email protected]
