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