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!