Multiple Updates

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kadar2itse
    New Member
    • Feb 2008
    • 3

    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.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

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

    Comment

    Working...