Does anybody know if there is a bug/limitation with the Visual FoxPro ODBC Driver version 5.00.00.00412 with regards to the data size in memo fields when using the Update SQL command?
Using MsQuery32 I execute the following command - UPDATE html SET sectname = 'Default', section = '
...', filename = '' WHERE (html.page_id = 1)
I reduced the data in section field of the update command for this message however the field section is a memo field which contains more than 255 characters.
After issuing the statement I get the error "[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword."
If I reduce the section field data so it only contains 255 or less characters the Update statement executes successfully.
Any suggestions?
David Wilkerson
TSM Corporation
dwilkerson@worldnet.att.net