>Hi,
>
>I'm getting an error when I try to save (doing a TABLEUPDATE on the cursor) foxpro data using ODBC. The error is 1812 - SQL Statement too long.
>
>I'm trying to save with a cursor adapter. It has these 2 important settings:
> .DataSourceType = "Native"
> .Datasource = (oApp.nConnectionHandle) && where I get this handle thru ODBC to connect to the foxpro database.
>
>If I'm correct I think I've heard that the ODBC has a bug that doesn't allow more than 2000 characters and it seems that this is my problem since when I change only a few fields it works fine but when I change a lot I get the error. But when adding new records it works fine, don't know why, I guess the limit should apply when I'm adding records too.
>
>What methods do you guys use to work around this problem?
>
>Maybe it could be another problem?
>
>Thanks!
Roy,
Check sys(3055). Also if it's not a must for you to check with modified fields change wheretype to KeyFieldsOnly (would be a simple fix).
Cetin