Re: Integerfields in Delphi with Oracle?

Hello Wolfram,

I guess you want Delphi to represent your datafield with a TIntegerField.
You could do so, by defining the column in Oracle as NUMBER(x, 0), there x is a number between 1 and 10. Numbers above 10 are always interpreted as TFloatFields by Delphi (the largest integer in Delphi is 2^31 that's a number with 10 digits).
Nethertheless you can store integers in a TFloatField by assigning the value in a way like this:
Qry.FieldByName('IntegerField').AsInteger := 12345;

Hope this will be a satisfying answer to your question.

Bye
Thomas

Wolfram Diestel schrieb:

> We have a database application written in Delphi 3.0
> which has to run with varios databases.
>
> There's no generic Integer datatype in Oracle,
> but in the BDE-Alias there is an option "ENABLE INTEGERS".
> By the BDE-documentation this option should convert
> numeric datatypes to integer - but it seems not to work.
>
> How to get it work? Are there any ideas?
>
> Thanks al lot for any hint,
>
> Wolfram.
>
> ____________________________________________________
> Wolfram Diestel <diestel_at_rzaix340.rz.uni-leipzig.de>
Received on Sat Feb 21 1998 - 00:00:00 CST