Subject Re: [firebird-support] Firebird 2.5.0 Generator gone wild
Author Tomasz Tyrakowski
On 2012-03-03 05:42, Wolfgang Kluge wrote:
> [...]
> manually created 6 records with IBEasy ver 1.5.3
> [...]

That's the key in my opinion. Try to insert some records with regular
INSERT statements from Firebird's isql tool or any other tool which lets
you execute SQL statements (e.g. FlameRobin).
Check the values of VI_DETAIL_RECORD which get generated this way. If
they behave correctly, the tool you use has to make some multiple
inserts (possibly rolling back transactions after some of them). You
never know what's goin on under the hood if you add records via grids or
other application-level mechanisms.
I've had a doubtful pleasure of maintaining an application, which tried
to insert a record (rolling back the transaction afterwards) immediately
after the user filled a cell in a grid, just to make sure the value in
the cell is valid (if the database reported an error, the application
would conclude the last value was invalid). Sloppy design, I know, but
if the primary key had been generated by a trigger incrementing a
generator (it wasn't), the symptomes would have been about the same as
you describe.


__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== ==--__