Actomic transaction

Results 1 to 2 of 2

Thread: Actomic transaction

  1. #1
    Join Date
    Dec 1969

    Default Actomic transaction

    I have a master table and a detail table. I use autogen. number as the primary key of the tables. I need to Insert a record to master table first and then select the autogen. num (PK) as the PK of detail table.<BR>As my system is a multi-user system, inconsistent errors of the two table will occur if the above action is not actomic.<BR>How can I solve this problem? Thank you in advance.

  2. #2
    schnookums Guest

    Default RE: Actomic transaction

    Hi Ruby,<BR><BR>If you are using stored procs, you can do a select on the @@identity value immediately afterward, and it will return the correct value. If you are not, let me know and I will show you a way to do it using standard queries.

Posting Permissions

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