Hi support.
It's assumed to include the following data on the table.
create table TABLE1(
KEY1 VARCHAR2(3) NOT NULL,
NUMDATA1 NUMBER(7,3)
NUMDATA2 NUMBER(7,3)
);
/
select * from TABLE1;
KEY1 NUMDATA1 NUMDATA2
---- -------- --------
001 0.7 0.35
002 0.7 0.35
When I access this data in ODAC, and XML is acquired in TClientDataSet.XMLData, it'll be as follows.
When it's operated in dbExpress equally, a result changes.
NUMDATA1 will be the strange value and be a problem at the time of use of data.
Why is this?
Please tell me whether there isn't a way to avoid.
Thanks
about XMLData fieldtype and value
ODAC creates TFloatField for NUMDATA1 and NUMDATA2. dbExpress creates TFmtBcdField for these columns. Therefore XML is different.
You can set EnableBcd driver option to False. In this case TFloatField will be created by dbExpress. You can use the following code to set EnableBcd option:
If you use TCRSQLConnection component, you can set EnableBcd option in Params property of TCRSQLConnection. In Delphi 2007 you also can set this option in Params property with standard TSQLConnection component.
You can set EnableBcd driver option to False. In this case TFloatField will be created by dbExpress. You can use the following code to set EnableBcd option:
Code: Select all
const
coEnableBCD = TSQLConnectionOption(102);
...
SQLConnection1.Open;
SQLConnection1.SQLConnection.SetOption(coEnableBCD, Integer(False));