> > > Should I be using bigint here. And if so, whats the datatype in
> > > Delphi7 for a bigint?
> >
> > Int64
> >
> > With regards,
> >
> > Martijn Tonies
>
>
> Martijn,
> I thought it was int64 but wanted to make sure. However,
> are you also saying I definitely should be using bigint instead of
> integer?

Well, if you're using Dialect 3 for the database and the generator
hits the max positive value for a signed 32 bit integer, then yes,
else you will get negative values in your Delphi app (32 bits has
1 sign bit, as you know) while your database is generating positive
numbers in 64bit.

With regards,

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