Hello Don,

> What happens when a generator reaches it's top limit (which I assume is an
> Integer value), does it wrap to 0 or to it's negative limit? With the

speed

> that recording could potentially occur at, this is quite an important

factor

> to consider before using a generator to generate a primary key for this
> table.

They wrap around to the most negative number.

In a "dialect 3" database, generators are 64bit numbers. I would
be surprised if you can run out of numbers to generate on those...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com