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