To import long DP text fields (e.g, A80A10) into SQL, preferably using an
INSERT query, what is best practice to get around the combination of single
quotes in text fields and the 78 character subfield issue?
I can print longer text fields of course using A0A0 format, but I would
like to turn fix the single quotes ( ' into '' ) where they occur in the
middle of a text field, and subfield function truncates to 78 characters
(drat).
At the moment, I use | as my delimiter in the report from DP instead of
single quote and then do a search and replace with a text editor (' become
'' and then | becomes '). I guess I could write an app to do that but have
not done that yet...
Anyone have a favorite/best practice?
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
