Главная страница | назад





Article #18788: Oracle Integer to BDE or Delphi float, ENABLE INTEGER

 Question and Answer Database

FAQ3788B.txt   Oracle Integer to BDE or Delphi float, ENABLE INTEGER
Category   :Database (Oracle)
Platform    :Win95/NT
Product    :   All32Bit

Question:
I've created an Oracle table using the INTEGER type but the BDE shows 
the INTEGER field as a FLOAT even though I have ENABLE INTEGERS set to 
True.



Answer:
The Oracle server will set the fields precision to '*' and the scale 
to '0' (MYFIELD(*,0) for example) when a field is created as INTEGER. 
This translates to an Oracle precision of 38. 
The maximum precision for Oracle NUMBERs INTEGERS and SMALLINTS is 38.  
The maximum precision for Delphi/BDE INTEGERs is 10 (-2,147,483,648 to 
2,147,483,647 or 9,999,999,999).

3/26/99 

Last Modified: 01-SEP-99