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?
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".