Subject RE: [firebird-support] Two users adding a record with the same code
Author Alan McDonald
> 2. Almost at the same time (before John post his new enterprise),
> the user Peter begins to add a new enterprise. The application
> propose automatically the CODE 101 (the same as the one that is
> using John) and Peter begins to add (in a grid) the employees.
> The field ENTERPRCODE of the employees he is adding will have the
> value 101.

I'm afraid this is your design flaw. The application should not propose 101
to Peter, since it's taken by John already. Use generators and this will
never happen.