the statements are:

rs = CreateObject("adodb.recordset")
rs.open(lSql,lconnection,1,2)
* No problem

rs.update()
* Problem


>Hi Jan,
>
>I think the problem is the length of your statement, not the number of fields you are using. You could try doing the following:
>1. Trim all unnecessary blanks in between your UPDATE command;
>2. Update only the strictly neccesary fields;
>3. Reduce the name of your table fields.
>
>Hope this helps,
>
>>I am using ADO to maintain my databases
>>
>>With a table i have the following error
>>
>>OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long...
>>[Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long.
>>Microsoft OLE DB Provider for ODBC Drivers
>>
>>This appears when I update the recordset
>>
>>If I delete some fields from the database the problem is gone.
>>
>>I seems that the probleem i caused by the number of fields in the database
>>
>>Has someone a solution to solve this.
>>
>>Kind regards
>>
>>Jan Dorresteijn