DMAX after begintrans (access 2003)

  • Thread starter Thread starter Oreste
  • Start date Start date
O

Oreste

In one transaction dmax of autonumber return old value:

Workspace.BeginTran

? dmax("[id]", "myTable") --> 100

execute query that add one row on myTable

? dmax("[id]", "myTable") --> 100 (and NOT 101!)

Workspace.CommitTrans

? dmax("[id]", "myTable") --> 101 (Right! but too late!)


How can i obtain the new value of ID (primary key of myTable) within a
transaction?
 
I haven't tested this, but I believe that executing a query to retrieve the
value (SELECT Max([id]) FROM myTable) instead of using DMax() should do it,
provided you execute the query within the transaction.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top