Deleting Records from Recordset - Complex

[chrisfricke]

I know this sounds simple, but I have a FoxPro 2.6 Database (Not my choice) in which there is a table called custmain. This table has a field called customerco and I am trying to delete all of the records where customerco is "LINH". I have selected the records using SQL, placed them in a DAO recordset and tried using .Delete method, but this doesn't work on these (it has on others).

I have also tried executing an SQL statement (Delete * from custmain where customerco='LINH') and the records are still not deleting. Please can someone help!

[Clunietp]

Your SQL statement is wrong

Change this:
(Delete * from custmain where customerco = 'LINH')

To this:
(Delete from custmain where customerco = 'LINH')

[alok_sathaye]

hi,
Thnx for the API.
But how do I use it ??
Tried it. Gives me a null string.
Mail me at alok_sathaye@yahoo.com