R
Randy
Hi,
I'm using OleDbDataAdapter objects to perform inserts,
updates, and deletes. Unfortunately, the class (or
perhaps the JET provider) won't let me include multiple
SQL delete statements in the adapter delete command.
I need a statement like "DELETE FROM table1 WHERE id = ?;
DELETE FROM table2 WHERE id = ?" etc.
Am I going to have to do this with some goofy loop using
individual command objects and ExecuteNonQuery methods?
This is going to be a major pain, especially since I need
to wrap it all into a transaction.
Randy
I'm using OleDbDataAdapter objects to perform inserts,
updates, and deletes. Unfortunately, the class (or
perhaps the JET provider) won't let me include multiple
SQL delete statements in the adapter delete command.
I need a statement like "DELETE FROM table1 WHERE id = ?;
DELETE FROM table2 WHERE id = ?" etc.
Am I going to have to do this with some goofy loop using
individual command objects and ExecuteNonQuery methods?
This is going to be a major pain, especially since I need
to wrap it all into a transaction.
Randy