>ARRRRGG!!
>
>I'm using VFP 6 SP4 with ADO and SQL 7. When I try to update one of the SQL tables with the ado recordset it returns the following error.
>
>OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'values'...
>
>I have tried EVERYWAY I can to try to track down this bug but I have about given up hope. Does ANYONE have ANY IDEAS of what this may be or even what I could do to narrow down the problem??
>
>TIA!!!!
Kevin,
Most likely this is due to a SQL Server keyword being used as a field or table name. What is the structure you are trying to update?
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao