Multiple Updates

Hi,
I am having multiple update queries inorder to update a records in single table. I am using VB6 and ADODB objects for connecting to DB2 database. I need to run all those queries in a single Execute statement. I tried the option of separating the queries with semicolon. But it works only for first two update query and not for remaining.

Inshort, i am having 10 update query and i need to know how to run those 10 query in a single Execute statement in VB6. Any help will be appreciated.

re: Multiple Updates

You have to use Commit after each of the Update statments to release the locks enforced by Update command.