Thanks every one for the help. I think the problem I was having was not committing the transaction. I was a little confused with Flame Robin as far executing sql and committing your sql statements. Also I have since discovered that "Flame Robin" will create the generator and trigger for you.

Dave

--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:
>
> Hello David,
>
> > 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 ??
>
>
> In addition to what others have said, I woud like to point out that a
> generator
> has -nothing- to do with a table, it's a separate database object, Firebird
> doesn't
> care if you use it for values in a table or whatever else.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>