delete statement in Visual Basic

what is the delete statement using VB. i still new in VB

what is the delete statement using VB. i still new in VB

DELETE FROM Tablename WHERE Field = Variable

thank duanne it work perfect. but how am i going to check whether they is any data to delete or not before the execution of delete statement.

The DELETE statement will simply do nothing if there is nothing to delete, so you don't need to do any checking.

well if you want to politically correct about it, you could open the recordset and if you return no records, close it and delete nothing, if you find records, do some deleting, etc. And if you want to remove the blank table you could use the DROP TABLE sql command if you want to stick with the SQL routines

well if you want to politically correct about it, you could open the recordset and if you return no records, close it and delete nothing, if you find records, do some deleting, etc. And if you want to remove the blank table you could use the DROP TABLE sql command if you want to stick with the SQL routines
Yes, you are right! :rolleyes:

But just don't see much benefit for checking before deleting in this case, am I correct?

Mike

Quote: "thank duanne it work perfect. but how am i going to check whether they is any data to delete or not before the execution of delete statement."

He asked how to check for data before deleting..I told him ;) (ask and you shall receive!)