>>>I'm thinking there is no way to achieve your goal. You need to insert a record in order to get the ID. You can not get the ID without inserting.
>>
>>Why? I can do that with native tables and using a GUID as a key. There should be a way with int too, just not found yet:)
>>Cetin
>
>You can not get an ID with AutoInc fields in native either without an attempt to insert (or hacking DBF), I'm thinking this is the case here in SQL Server as well.
>
>In other words, it's an internal thing hard to get.

OK Naomi,
But I nowehere said Autoinc or Identity:) Simple updatable int field. Use mine if supplied or assign automatically if not. ie:

lnID = NextID('MyTable', 1) && allocate 1 key for me
* ...
insert into myTable (myPK) values (m.lnID)
* I may choose to not insert anything and waste the key

Or let backend do it:

insert into myTable (aFieldOtherThanPk) values ('something')
lnID = myTable.PK && it called the NextID via default, ask what has been assigned

Wish it was done with GUIDs from the start.

Cetin




Cetin