>>Is it possible to get an Identity/PK of a table without adding a record? Here is what I would like to do:
>>
>>1. Get Identity (next PK number) for a table.
>>2. Add a record to a view/cursor.
>>3. Once user commands to Save the record, add a row to the table using the PK that was obtained in step 1.
>>
>>Is it possible?
>>
>>Thank you.
>
>
>GUID!!!!!
The problem with GUID (I think in my case) is I want the identity in this particular table to be in sequential order and no numbers missing. And with GUID, as I understand, another "procedure" or "process" can grab the number.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham