Data Maping Expecting: Integer, Actual: Float
Posted: Fri 23 Dec 2016 10:53
Using Oracle 11g Release 2.
In an sql I have Number (10) and Number (5) fields.
In the ClientDataSet both are as TIntegerField, but when opening the search shows "Type mismatch for field 'FIELD', expecting: Integer actual: Float".
The problem is in the Number (5) field. The Number (10) field works fine as TIntegerField.
with SQLConnection1 do
begin
Connected := False;
DriverName := 'DevartOracle';
GetDriverFunc := 'getSQLDriverORA';
Params.Values['DataBase'] := 'database';
Params.Values['User_Name'] := 'username';
Params.Values['Password'] := '*****';
Params.Values['BlobSize'] := '-1';
Params.Values['LocaleCode'] := '0000';
Params.Values['Oracle TransIsolation'] := 'ReadCommited';
Params.Values['RoleName'] := 'Normal';
Params.Values['LongStrings'] := 'True';
Params.Values['EnableBCD'] := 'False';
Params.Values['FetchAll'] := 'False';
Params.Values['UseUnicode'] := 'False';
Params.Values['BCDPrecision'] := '0';
Params.Values['FloatPrecision'] := '38';
Params.Values['IntegerPrecision'] := '38';
end;
In an sql I have Number (10) and Number (5) fields.
In the ClientDataSet both are as TIntegerField, but when opening the search shows "Type mismatch for field 'FIELD', expecting: Integer actual: Float".
The problem is in the Number (5) field. The Number (10) field works fine as TIntegerField.
with SQLConnection1 do
begin
Connected := False;
DriverName := 'DevartOracle';
GetDriverFunc := 'getSQLDriverORA';
Params.Values['DataBase'] := 'database';
Params.Values['User_Name'] := 'username';
Params.Values['Password'] := '*****';
Params.Values['BlobSize'] := '-1';
Params.Values['LocaleCode'] := '0000';
Params.Values['Oracle TransIsolation'] := 'ReadCommited';
Params.Values['RoleName'] := 'Normal';
Params.Values['LongStrings'] := 'True';
Params.Values['EnableBCD'] := 'False';
Params.Values['FetchAll'] := 'False';
Params.Values['UseUnicode'] := 'False';
Params.Values['BCDPrecision'] := '0';
Params.Values['FloatPrecision'] := '38';
Params.Values['IntegerPrecision'] := '38';
end;