Subject Re: Cannot create simple trigger???
Author dleec45
I'm using this to insert a value in the key as a replacement for the
autoinsert which exist in the MySQL files I'm converting. Is this
simple method not adequate?


--- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> you forgot the = sign
> new.id= etc
> but you would normally protect this by asking if ID is NULL or not
first.
> Just in case you've already asked for a new ID and you intend to
insert this
> value - don;t overwrite it with another generated value.
> Alan
> -----Original Message-----
> From: dleec45 [mailto:dleec45@n...]
> Sent: Sunday, May 23, 2004 4:25 PM
> To: firebird-php@yahoogroups.com
> Subject: [firebird-php] Cannot create simple trigger???
>
>
> I'm trying to crate some simple triggers and am getting an error that
> appears that GEN_ID is not recognized. Here's the trigger:
>
> SET TERM !! ;
> CREATE TRIGGER Trg_Address_ID
> FOR Address
> BEFORE INSERT AS
> NEW.ID GEN_ID(addr_gen_id, 1);
> END !!
> SET TERM ; !!
>
> and it blows up on GEN_ID!! Isn't this the correct format?
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
----------------------------------------------------------------------------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]