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