I have no clue what's going on here and will appreciate any comment.
My firebird installation behaves illogical:
Firebird 2.5.0
CPU E7400, 2.8 MHz
RAM 8 GB
Free disk space ca. 200 GB
OS Windows 7 professional 32 Bit
Table name VI_DETAIL
with primary key VI_DETAIL_RECORD
record created with FIB Plus 6.99:
'CREATE TABLE VI_DETAIL ( VI_DETAIL_RECORD INTEGER DEFAULT 0 NOT NULL
PRIMARY KEY, ' +
trigger created with FIBPlus 6.99:
CREATE TRIGGER "VI_DETAIL_CREATE_TRG" FOR "VI_DETAIL"
ACTIVE BEFORE INSERT POSITION 0
As
begin
NEW.VI_DETAIL_RECORD = GEN_ID( VI_DETAIL_GEN, 1 );
end
^
manually created 6 records with IBEasy ver 1.5.3
this resulted in created column VI_DETAIL_RECORD with values of
1 for first record
4 for second record
14 for third record
16 for fourth record
18 for sixth record
27 for seventh record
an identical effect was observed on primary key values of other tables.
Where did I possible mess up things ?
Regards
Wolfgang Kluge
