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