Skip to Content
0
Former Member
Oct 30, 2013 at 03:46 PM

07009 by field content

42 Views

I have a memo field in a sql table that contains a tilde as a separator. If I insert this field into a report, it generates a database connector error 07009. How can I get around this? The intent is to use the ~ in a replace with a ChrW(10) so that the field will output a separate line for each group of text separated by the ~.

I had done this with test data, and it seemed to work, but now I have a ready for production version, and it consistently fails.

Thanks!

Rich Walker