At 05:50 PM 2/04/2007, you wrote:

>Hi,
>
>What is the maximum number a firebird generator will reach before
>resetting to zero? I've seen 140372906 but it does not make sense
>that the generator will automatically go back to zero after hitting
>that number.

In a dialect 1 database, its highest positive number is 2,147,483,647
(it is a 32-bit integer in that environment).

In a dialect 3 database, the highest positive number is
9,223,372,036,854,775,807 (it is a 64-bit integer in dialect 3)

./heLen