vvaat...@news.abo.fi (Veikko V{{t{j{ TKKK) writes:

  I noticed that it does this on just one table. Other tables
with triggers work fine. What could be wrong with this table???
What does the error message mean?

  Veikko Vaataja
  veikko.vaat...@abo.fi

  Hi!

  How do I prevent a record from flying away when inserting a new
record in an interbase table that makes the primary key field
in a before insert trigger? When I insert a new record, enter
field values and post that, I get an error (EDBEngineError) saying
'Record/Key deleted'. I assume this is because the key field
is changed by the trigger and the temporary record with empty key
doesn't exist any more.

  Should I do this some other way? I should because this
doesn't work... :(

  Veikko Vaataja
  veikko.vaat...@abo.fi

In article <433qma$...@aton.abo.fi>, vvaat...@news.abo.fi (Veikko V{{t{j{

To make this work, you need to have no DEFAULT definitions for your
table.  It seems that a combination of the before insert trigger and
default values in your database makes Delphi {*word*88}.

Tom

Actually, Interbase accept this record, but delphi can't  found this record because of the key field change, so delphi  
give you a message "Record /Key  deleted".

Solution 1 : Don't change the key field in trigger procedure. Make all change in your OnBeforeInsert event.

Solution 2 : If you still want to change the key field in trigger, ah...... let me check, tell you later.

  :-)

  Some triggers that change key field work fine! I can't understand what is
wrong with this one. One table worked after I removed default statement in
create table. I don't know what this have to do with the problem but just
worked!

  Not good! I would like to use triggers because they are much-much-much
better... Well, in theory atleast... ;)

  Let me hear from you.

  Veikko Vaataja
  veikko.vaat...@abo.fi