At 03:41 PM 05-03-02 +0000, you wrote:

>Is this the way I should be trying to maintain a unique number ? Or
>are there better methods. This came from when in Paradox you could
>simply
>check if a table was in exclusive edit state and wait a bit until it
>was freed.

No, this old Paradox warhorse is definitely to be avoided in a concurrent
user environment such as FB/IB. Use generators for unique numbers. If you
need to create unique numbering systems without using generators, then you
have a fairly complex job ahead of you to (a) guarantee uniqueness and (b)
avoid bottle-necking your data-entry through a table that all users need to
read from and write to.


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com