Re: Delete SQL qry Syntax
Only Select statements can be used to open a recordset. Action queries do not require a recordset. You can use connection objects execute method to execute the delete statement.
Also your query will not work. Instead of using = in the where condition use In.
Re: Delete SQL qry Syntax
Thankyou. That's a fundamental aspect I never knew.
Re: Delete SQL qry Syntax
Also you don't need to specify tblA01.* in the first line and some DBs will refuse the statement if you do. The reason is that a DELETE works across entire rows so you can't specify a field list. Instead just use DELETE FROM.
Re: Delete SQL qry Syntax
You also need spaces around your = sign (or IN, if you changed that). Some dbs may accept it, some may not.