Never mind. I figured it out.


""Don Gollahon"" <gollahon@...> wrote in message
news:<INEIJJJDAFIPCPLIALBICEHCCHAA.gollahon@...>...

> 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]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>