https://bugs.documentfoundation.org/show_bug.cgi?id=145900
--- Comment #9 from Robert Großkopf <[email protected]> --- (In reply to mc from comment #8) > (In reply to Robert Großkopf from comment #7) > > ... > > 20 Bill > > Refresh the table > > There will be shown > > 4 Robert > > > > This will appear only with Firebrid, not with HSQLDB. HSQLDB would insert > > the new row with > > 21 Robert > > ID Key in Firebird not work same as HSQLDB > > If you manually change value of ID Key in a table, need to update the > internal ID "counter" before to continue to insert other record, ex. with: > ALTER TABLE "table" ALTER COLUMN "ID" RESTART WITH 21; > > @mhonline first has showed a Form in attachment 176524 [details] I know all this - have written the German original for Base Guide. But I isn't an argument while row wouldn't be refreshed and the inserted value will be shown in the right way for Firebird. There should be shown 4 Robert and not 20 Bill or, better, there should be found a way for Firebird to correct the autovalue to max ID, as ist works with HSQLDB, because the current behavior will run into an error if Firebird has counted ID should be '20' and primary key '20' is used for 20 Bill. -- You are receiving this mail because: You are the assignee for the bug.
