Results 1 to 2 of 2

Thread: ADO

  1. #1
    Duc Guest

    Default ADO

    Hi,<BR>I am working with two table one call User and the other one call information<BR>User Table<BR> ID (Auto number and it&#039s primary key)<BR> User_name <BR> ETC...<BR><BR>Information Table<BR> ID (number field and it suppose to one to one relationship with the ID field in User Table)<BR><BR>My question is<BR>Right after I insert a record set into the user table how do I know what ID number did the system assign for the record set so that I can insert the same value for Information table.<BR>Thank<BR>Duc<BR><BR><BR><BR>

  2. #2
    a Guest

    Default RE: ADO

    since it is an auto number , you can use the @@IDENTITY and it will come back with the value that was just inserted.

Posting Permissions

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