TFMTBCDField usage

[marc.wilson]

Is it not possible to use a manually defined TFMTBCDField with TOracleDataset?

I currently have two tables I wish to setup a master/detail relationship with. The key field 'CONN_ID_KEY' is defined as a NUMBER and a data sample would be '49822304585931369' (17 digits).

DOA wants to autoamtically create the field to be TFloatField. This is true even when creating static field defs at design time.

I have attempted to delete the Delphi field def in question, and re-create it manually using "New Field...". I have set the field type to TFMTBCDField.

However, when I try to activate the dataset I receive and error from TOracleDataset indicating that it beleives the field should be a TFloatField.

I have looked in the Forum archive and found that the issue I am experiencing may have existed for almost 3 years now.

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=001686#000000
-and-
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=000842#000003

Is there any way to work around this limitation?

dbExpress seems to allow me to define the field as TFMTBCDField without complaint. But I definately do not want to use dbExpress.

Any help you can provide would be greatly appreciated.

--marc

 

[Marco Kalter]

It is currently not possible to define a BCD field. You can however set TOracleSession.Preferences.FloatPrecision to (for example) 15. All number fields with a higher precision will be translated to a TStringField, with full precision.