I'm sorry to bother you guys again, but hopefully you can help. I have
a table, where one of the columns is an auto number column, called Identity,
in SQL Server. Every time there is a new row, SQL Server automatically
assigns a number to the cell. My question is how do I programatically
determine what the identity number is of the newly inserted row? For
whatever it is worth, I can already successfully add, update, and retrieve
data from the SQL Server database.
The problem seems to be to transfer all the columns of the newly inserted
rows into the data results set buffer. Once I do that, all I have to do is
get the appropriate column of the first row in the resulting data set and
I'm in business. Does SQL / ODBC automatically fill the results data set
with the entire contents of the row? I would seriously doubt that.
Thanks in advance you guys,