Devart Forums

Hi guys,

I have a virtual field that cames from my SQL and when i create a persistent field in Delphi, it maps to a FloatField. Ok. When a create persistent field that original field in Oracle is datatype NUMBER(9), the Delphi maps it with a IntegerField. I need to do something like this: When i do it, i have a error message: Type mismatch for field "myfield": expecting: BCD' actual: FMTBcdField, Because the Oracle sends to Delphi that field is a Float Datatype.

So, i want make every Oracle datatype NUMBER(9) make on Delphi FloatNumber.

I already try to do all Oracle datatype NUMBER(9) make on FloatField in Delphi:

• Turn off EnabledBCD Params
  Set FloatPrecision=9 Params

But until now does not work.

Somebody have any idea how make it?

Thanks for All!

Hello,

To solve this problem, you should set the EnableBCD property of the TSQLConnection.AfterConnect event in the following way:
procedure TForm1.SQLConnection1AfterConnect(Sender: TObject);
const
coEnableBCD = TSQLConnectionOption(102);
begin
SQLConnection1.SQLConnection.SetOption(coEnableBCD, Integer(False));
end;
and you should not add fields in the design-time.
This is connected with the specificity of dbExpress 3. In version 4 these settings can be added in design-time (dbExpress version 4 is supported in Delphi starting from the 2007 version).

Hi AlexP,

Still does not work. What i really do to DBX never maps TIntegerField?

Hello,


Please specify the following information:
the version of the Oracle server and client;
the version of your dbExpress driver;
the version of your IDE.
Also please send us an application demonstrating the problem including scripts for creating and filling tables to alexp*devart*com.

Thanks a lot AlexP, but i solve it changing all my persistents NUMBER fields to use only TFMTBCDField...

Thank you very much!

Hello,

Glad to see that the problem was solved. If any other questions come up, please contact us.