Sorry Jan, I thought you were performing an update command using the execute method.

>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