I'm using the newest driver for VFP, and am having a problem [and I suspect this would have occured using prior versions]...

I have a VFP table with about 30 columns. In my C# app, I build a fairly long UPDATE string...when I try to do the update [as follows]...

oConn = new OleDbConnection("Provider=VFPOLEDB.1;" + "Data Source=mydata.dbc");

oConn.Open();
OleDbCommand MyCommand = new OleDbCommand();
MyCommand.Connection = oConn;
MyCommand.CommandText = cUpdateCmd; // long update command
MyCommand.ExecuteNonQuery();

...I get an 'unhandled exception' message...if I take the string for 'cUpdateCmd' and paste it into the VFP command window, I get 'unrecognized command'. It seems there's a limit on a string.

If I shorten the update string to maybe a 3rd of the columns, it works...but it just seems that a long update string back to a VFP data source isn't supported.

Any suggestions/feedback? Thanks.
Kevin