Subject | RE: [firebird-support] Two users adding a record with the same code |
---|---|
Author | Alan McDonald |
Post date | 2007-07-28T00:40:51Z |
> 2. Almost at the same time (before John post his new enterprise),I'm afraid this is your design flaw. The application should not propose 101
> 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.
to Peter, since it's taken by John already. Use generators and this will
never happen.
Alan