Results 1 to 2 of 2

Thread: Update recordset

  1. Nov 27th, 2000, 02:06 PM #1
    liore
    liore is offline

    Thread Starter
    Member
    Join Date
    Nov 2000
    Posts
    37

    Red face

    Hi,

    Is the Update method of a recordset has the same efect like 'Commit' in SQL?

    Thanks, Lior
    Reply With Quote Reply With Quote
  2. Nov 27th, 2000, 05:23 PM #2
    vbuser1976
    vbuser1976 is offline
    Hyperactive Member vbuser1976's Avatar
    Join Date
    Sep 2000
    Location
    Yonkers, NY
    Posts
    404

    Cool Maybe...

    After I did a little research, the commit in SQL is somewhat similar to update in recordsets. But, you should remember that every COMMIT command must correspond with an earlier executed SET TRANSACTION or BEGIN TRANSACTION command.

    I believe the only difference between them is that you cannot nest recordsets the way you can nest transactions. I could be wrong, but that is what I uncovered during the research.

    I hope this helps. Good Luck!
    -vbuser1976
    VB6 Enterprise SP6
    SQL 7.0 SP2
    VBScript, HTML, Javascript, C++, a little UNIX
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width