Hi,

I am using Visual Foxpro 9 with SQL Server 2000. My table contains approx. 40 fields.
I am using a temporary cursor for my form and then using SqlExec() command to update records to SQL Server from memory.
The problem is that the sql string becomes too long , approx. 1000 words, which gives error and i am not able to update my table in sql server.

Is there any other way to update SQL server database except making a remote view as for that we have to create a DSN or connection and which reqires SQL Server name to be hardcoded and limits your software to be deployed easily.

SQLExec(g_connection,"update tabcurrent (sno,field1,field2,...) values ('"+m.sno+","'+m.field1+"'...

Please help