Generators
From InterBase
Go Up to Features and Dialects
InterBase 6 and later generators return a 64-bit value, and only wrap around after 264 invocations (assuming an increment of 1), rather than after 232 as in InterBase 5. Applications should use an ISC_INT64 variable to hold the value returned by a generator. A client using dialect 1 receives only the least significant 32 bits of the updated generator value, but the entire 64-bit value is incremented by the engine even when returning a 32-bit value to a client that uses dialect 1. If your database was using an INTEGER field for holding generator values, you need to recreate the field so that it can hold 64-bit integer values.