>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?
>
>Dallas
Have a table with the sequence numbers. Have a function that looks up the last number used, increments it, and returns the incremented value. For security, lock the record while it is incremented.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)