When i add a new record to SQLServer using ADO i have a problem like this :
I m adding a new record to table and after updating i want to get the autonumber field of record that assigned by SQLServer. In my SQLServer thats working but in a different SQLServer not working. the code is like ..
open recordset with adopenkeyset and adlockoptimistic
variable = autonumber field
After updating i know that autonumber field will appear. But it doesnt apper. If i code movelast command after update thats also working but i dont want to use movelast.
If any one knows why such kind of thing happens please tell me.