"Paul Reeves" <paul@...> a ecrit dans le message de news:
3D2C0FBF.7010102@......

> Theo Bebekis wrote:
>
>
> > Also...
> > I see that MASTSQL database, provided with some of Delphi's demo apps,
> > uses DOUBLE PRECISION for ORDERNO and CUSTNO
> > of the ORDERS table to name a few cases.
> >
> > Is that a wise decision? Why not just INTEGER?
> > Usually that kind of fields are of the INTEGER type, or not?
>
> Yes - these columns should be integer. I suspect that the person who
> ported MASTSQL probably took something like the Borland datapump, ran
> some paradox tables through it and generated an InterBase database. You
> can imagine they then stood back and said 'Look - it's that easy!'
>

And what about a field associated with a generator ?
What kind of field to use INTEGER or NUMERIC(18,0) ?