I have a table that has 2 fields for the primary key. When I try to insert
a new record to this table I get the error that the 2nd field must have a
value. I have the following trigger but apparently it is not working:

ALTER TRIGGER MSGMOUREC_IDTRIG
BEFORE INSERT
POSITION 0
as
begin
if (new.REC_ID is null) then
new.REC_ID = gen_id(MsgMouRec_Id, 1);
if (new.REVENUE_LINK is null) then
new.REVENUE_LINK = 0;
end

The revenue_link only needs to be 0 on initial insert. It may be changed
later during another process.

Using Delphi 5 pro, Windows 2000, Firebird 1.5 RC1 Classic install on
Dual-Processor Dev server, Firebird 1.02 on Production server.

Thanks.


Don Gollahon
gollahon@...
"The Original GenSoft Prodigal"




[Non-text portions of this message have been removed]