Data drive loop is the only way to send a sql to DB. but delete From table results exception

Selecte * from tablename where col1= 55 and col2="abc" works great, but tring to delete from table, results in exception. It deletes the rows  then disp[lats the exception  with explanation that the query did not create any table.

delete from tablename where col1=55 and col2="abc"

I end up using a vb script without any problem. I like to make the kaywords to work. The only way I can send a sql qurey is using Data-drive loop.

Is there any other way to use keywords to make sql DELETE to work?

Thanks, Mehdi