how to get AutoIncrement value after JetUpdate() in Extensible Storage Engine (JetBlue)

Question

after calling JetSetColumns() and then JetUpdate() how do I retrieve the values for any freshly assigned autoincrement values?

Answer 1

when you call JetUpdate() the third arg is a 'bookmark'. Once JetUpdate() completes you can seek to the bookmark using

JetGotoBookmark() - http://msdn.microsoft.com/en-us/library/ms683554(EXCHG.10).aspx

Answer 2

Note that it is also possible to retrieve the autoincrement value before calling JetUpdate, because the value is assigned when JetUpdate is called. You need to use the JET_bitRetrieveCopy option with JetRetrieveColumn.

For an example in managed code see the "How Do I Retrieve an Auto-Increment Column Value?" section on this page.