Hi!

Probably you require to use parameters. I don;t know, however, if it will work woth VFP ODBC driver, but try to use INSERT INTO ... (..., MemoFiedl, ...) ... Values(..., ?Param1, ...)
Than in the ADO object define parameter(s) and populate parameter value(s) by the memo content or whatever long values you have (char(240) field is long too for inserts ;). In such case memo text could have any length.

HTH.

>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?