I have looked through MSDN and on the web with no luck. I also tried the VB code in the MSDN Cd with the same results.

When I try to delete a record in my ADO recordset I get the error "SQL: Statement Too Long" and my program stops on that oRS.DELETE line.

Any ideas what my cause this. I am connected to a VFP DBC and my recordset is from an sql and only contains 3 records. The idea is to delete everyone in the recordset buy I can't seem to get 1 to delete properly.

I have tried changing the lock type with no luck.