-
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!
-
Your SQL statement is wrong
Change this:
(Delete * from custmain where customerco = 'LINH')
To this:
(Delete from custmain where customerco = 'LINH')
-
Reply to WnetGetUser
hi,
Thnx for the API.
But how do I use it ??
Tried it. Gives me a null string.
Mail me at [email protected]
