> I have a question about the datatype you should use with
> generators.
>
> I think atomicity is the correct term for this, but lets say I have a
> field on a table thats sole purpose is uniqueness. Its an integer.
> Is it a potential problem for a generator to be autoincrementing to
> this field?
>
> iRecNo integer,
>
> iRecno = Gen_ID(agenerator, 1);
>
> Should I be using bigint here. And if so, whats the datatype in
> Delphi7 for a bigint?

Int64

With regards,

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