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. regards Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__
