UID on add

Results 1 to 2 of 2

Thread: UID on add

  1. #1
    Chris Bickell Guest

    Default UID on add

    Does anyone know how, when adding a row to a table in a database, the UID can be returned in the code. I have multiple tables that need updating but the UID needs to be the same. As the database asigns the UID in one table I can&#039t add the same UID to another, because I don&#039t know what it is.

  2. #2
    Join Date
    Dec 1969

    Default RE: UID on add

    use a stored proc:<BR><BR>BEGIN TRANSACTION<BR> INSERT (your insert operation here)<BR> SELECT MAX(uid) blah, blah<BR>COMMIT TRANSACTION<BR><BR>get it??

Posting Permissions

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