> Hello
>
> I need some help. I have a database I exported from Access 97 into a
> Firebird 2.1 Database. I need to create a auto increment field. I
> cannot seem to create a Generator. I tried the following which seem to
> execute without failure but it does not show up in FlameRobin.
>
> When I try to create a trigger it fails and complains about missing
> generator. Is it possible to create a generator for a table with
> existing data?? If so how ??
>
> Here is my code:
>
> CREATE GENERATOR gen_tabADDRESS_ID;
> SET GENERATOR gen_tabADDRESS_ID TO 42659; (42659 is the last row)
>
> Thanks,
>
> Dave

I'm not familiar with FlameRobin but I would guess you need to commit the
transaction in which you executed this code so you can see it.
Alan