>>>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)
insert into myTable (myPK) values (m.lnID)
Or let backend do it:
insert into myTable (aFieldOtherThanPk) values ('something')
lnID = myTable.PK
Wish it was done with GUIDs from the start.
Cetin
Cetin