Interbase problem. Record/Key deleted.
Posted on 1998-11-19
I have Delphi4 installed with Interbase 5.0. Here is the probelm:
I have a database and a table in it. This table is created this way
CREATE TABLE STOREMAN
ID_STOCKGROUP INT NOT NULL,
MarkUpValue float DEFAULT 0,
MarkUpIsPercent FT DEFAULT "T",
MinAmount float DEFAULT 0,
MaxAmount float DEFAULT 0,
MinMaxWanted FT DEFAULT "T",
CassGroup int DEFAULT 1,
The first field has to be Autoincrement field. But Interbase does not have native support for autoincrement fields. So i made a generator and a triger. The triger fires before post in the database. When i try to post a NEW record i get the BDE error "Record/Key Deleted". After this when i press the refresh button, i see that the record has been posted. But i don't want to get this error. What might be the problem, what does this error meen, and what is the solution?