Forget it.. it is working..

Thanks everyone!

<march>

>
> Ok.. I have the "Auto-Incrementing Keys" trigger working.. meaning
> Firebird accepts the trigger without barfing..
>
> However, it doesn't seem to be working.
>
> If I insert a column, the auto-increment trigger should magically
> work, right?
>
> If I try to insert a column with IBOconsole with the table editor it
> says that there needs to be a value in the auto-increment field.
> Doing a manual insert also produces an error too..
>
> I bought the "The Firebird Book" today and overall it has been great
> but I have not found any resolution to the problem that I stated
> above.
>
> thanks!
>
> > The following script works for me (tested in IBOConsole), there are
> a few
> > changes from what you posted (look at set term and NEW.ITEMNUM =
> GEN_ID...)
> >
> > CREATE TABLE ITEMS (
> > ITEMNUM INTEGER NOT NULL,
> > CATEGORYNUM INTEGER,
> > PRIMARY KEY (ITEMNUM)
> > );
> >
> > CREATE GENERATOR ITEMNUM_ID;
> >
> > COMMIT;
> >
> > SET TERM ## ;
> >
> > CREATE TRIGGER ITEM_ID_TRIG FOR ITEMS
> > BEFORE INSERT POSITION 0 AS
> > BEGIN
> > NEW.ITEMNUM = GEN_ID(ITEMNUM_ID, 1);
> > END ##
> >
> > SET TERM ; ##
> >
> > COMMIT;
> >
> > The error you were receiving was more than likely because the
> Generator had
> > already been created (presuming you ran this script more than once)
> >
> > Hih
> >
> > Si Carter
> > http://www.tectsoft.net/
> >
> >
> > > -----Original Message-----
> > > From: cowmix3 [mailto:mmarch@g...]
> > > Sent: 04 March 2005 10:51
> > > To: firebird-support@yahoogroups.com
> > > Subject: [firebird-support] Arg.. Autonum generator newbie
> question...
> > >
> > >
> > >
> > > I have looked at every example and I can't get things to
> > > work.. Here is what I have for my example:
> > >
> > > CREATE TABLE "ITEMS"
> > > (
> > > "ITEMNUM" INTEGER NOT NULL,
> > > "CATEGORYNUM" INTEGER,
> > > PRIMARY KEY ("ITEMNUM")
> > > );
> > >
> > >
> > >
> > >
> > > CREATE GENERATOR ITEMNUM_ID;
> > > COMMIT;
> > > SET TERM;
> > >
> > > CREATE TRIGGER ITEM_ID_TRIG FOR ITEMS
> > >
> > > BEFORE INSERT POSITION 0
> > > AS BEGIN
> > > ITEMS.ITEMNUM = GEN_ID(ITEMNUM_ID, 1);
> > > END
> > >
> > > SET TERM ;
> > >
> > > And I get something like this:
> > >
> > > ISC ERROR CODE:335544351
> > >
> > > ISC ERROR MESSAGE:
> > > unsuccessful metadata update
> > > DEFINE GENERATOR failed
> > > attempt to store duplicate value (visible to active
> transactions) in
> > >
> > > unique index "RDB$INDEX_11"
> > >
> > > Arg!
> > >
> > > Help!
> > >
> > > <march>
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >