>Has anybody else hit this?
>
>We have upsized an app from VFP DBC to SQL. The SQL tables have memo fields and all is fine. We now use a DBC with remote views instead.
>
>However... if there is a bracket ([ or ]) in the memo field of a SQL table, we can no longer save (TABLEUPDATE(.T.) returns a .F.)! And once the data is in the SQL table, we can SELECT it, but then even if we edit the memo to remove the bracket(s), it's no good because the SQL tables just won't accept the save.
>
>This seems to be the ONLY characters this happens with! Has anyone else seen this behavior?
This may help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_9rar.asp
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up