>Hi all, I need a method to compute an automatic account number (one-up-count) for each new record (append blank). Old method (DOS) was to go to bottom of table, then get last account number, compute next account number, commit immediately (save) and move on. With multiple users this worked fine because commit (skip-1) was immediate. In windows, the commit seems to be held in a buffer so multiple user all seem to compute the same next record number because commit (save) is still pending. Any ideas?
I'm surprised that it worked in DOS because the only way to get next # relabaly is to FLOCK() the table until new record is saved. However locking the table will create unnecessary contention in multi-user environment. Take a look at the article
Primary Keys by Craig Berntson at
http://www.craigberntson.com/Articles/kb006.htm
--sb--