Subject Re: [IBO] Help on stored procedures/trigger
Author Geoff Worboys
> Here is a part of the code I used for the paradox application
> that may explain more what the need is.
> Select MAX(RequestNumber) As sMax From dsRequest
> Where RequestNumber Like '" +

This is not multi-user safe. If two users create a new entry and the
same time they will receive the same number. Presuming you have a
unique index on this field (to force the rejection of duplicate
entries) then perhaps this is acceptable - if you only have a few
users and the likelyhood of two creations at the same time is minimal.

You can reduce the risk of conflict by delaying the sequence creation
until the entry is committed - although there is no way of duplicating
this at the server trigger level which appeared to be where this
question started.

Geoff Worboys
Telesis Computing