Results 1 to 2 of 2

Thread: Commit

  1. #1
    Elliot Guest

    Default Commit

    If I execute an update statement in asp and then want to do a select statement to view the changes made do I have to commit after the update to see the changes. And if I have to commit what is the command, ie:<BR>strSQLstatement = "COMMIT"

  2. #2
    alf Guest

    Default RE: Commit

    I think it depends on the DB....I use SQL 7 and the commit seems to happen implicitly meaning when something is changed, the commit happens automatically. Oracle may be different and I know that non web based transactions like delete must be committed to the database before the change will be reflected to web users. Again it may be different if the delete occurs through a browser but I doubt it. Update would work the same. The best way would be to run a test.......i.e. do the update, do the select...did you get the expected results? If yes then no commit needed, If no try committing and then the select.<BR><BR>later,<BR><BR>alf

Posting Permissions

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