![]() |
|||||||||||||||||
|
|
|||||||||||||||||
|
|
|||||||||
|
Company
|
SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
Oracle Integer to BDE or Delphi float, ENABLE INTEGERS BDE 3.5 and up Q: 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. A: 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). PUB ORA LINK TECH VENDOR JK, BC 7.10.97 |
|
|
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 16:27:08 PST |
|||||