Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Brackets ([ and ]) in SQL memos
Message
From
14/10/2002 18:19:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Brackets ([ and ]) in SQL memos
Miscellaneous
Thread ID:
00711154
Message ID:
00711154
Views:
44
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".
Next
Reply
Map
View

Click here to load this message in the networking platform