Make sure that you have the latest Visual FoxPro ODBC Driver (6.1.8629.1)
http://msdn.microsoft.com/vfoxpro/downloads/odbc.asp. Also post you insert statement here.
>I am attempting to insert into a VFP table from Visual Basic. The insert statement is over 2200 bytes long and it results in a syntax error. When I paste the same statement into VFP command window, I get "Unrecognized command".
>
>The insert works from VB if I keep the statement down to <512 bytes (by not including all the fields).
>
>One of the fields is a memo memo field. When I try to do an update-sql to just that field, if the string is longer than 512 bytes, it fails with "unrecognized command ... " error. I shrink the data down to 511 bytes or so, and the update takes place just fine.
>
>What's going on?
--sb--