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