Very Computer

Hi all,

I have a problem that seems like there should be a simple solution to.
I have a table that's only unique key is an identity field.  I need to
know how to retrieve the value of this column for the record that has
just been inserted.  Keep in mind that many inserts must be occuring at
the same time and the SQL that does the insert needs the value of the
column in the record that it inserted and no other SQL that is currently
doing inserts can recieve that value.

I hope that I have been clear.

Thanks for any help
Matthew Field

Matthew,

to the current session.

Michael Weaver (MCP SQL / NT)

Hi.  Try:

---------------------------------
begin transaction

< do your insert here >

commit transaction
----------------------------------

That should allow you to get the last value you inserted before anybody else
gets a chance to insert another.

Be careful retriving the rows from the select querry when using dblib.  I've
found that while it does return the correct value, it does so a large number
of times -- once for every row in the table.  I've put an "sqlcanquery"
after retreiving the first row to get around the problem.  Anybody else have
that problem?