>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

There is no such a command like

UPDATE Table (fieldlist) VALUES (some valies)

This is syntax for INSERT command


try:

TEXT TO lcUpdate NOSHOW PRETEXT 15 TEXTMERGE
     update tabcurrent SET sno    = '<<m.sno>>',
                           field1 = '<<m.field1>>',
                           field2 = '<<m.field2>>'
ENDTEXT
SQLEXEC(g_connection, lcUpdate )