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.
"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