Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Array DML inserting wrong values for numeric fields in Delphi 10/Firebird


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Apr 20, 2016 1:35 PM Last Post By: Ronell Recio
Daniel Sonda

Posts: 3
Registered: 9/1/09
Array DML inserting wrong values for numeric fields in Delphi 10/Firebird  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 20, 2016 7:25 AM
I'm using Delphi 10 Seatle and FireDAC array DML to insert 43 records in a Firebird 2.5.1 database. The table has some numeric(15,4) fields and their relative params are filled with:

FDQuery.Params.ParamByName('field_A').AsCurrencys[Index] := Value;


All fields are inserted with correct values, except numeric ones. They are all inserted with the same wrong value 0.1044 instead of the parameter value.
Ronell Recio

Posts: 15
Registered: 7/12/07
Re: Array DML inserting wrong values for numeric fields in Delphi 10/Firebird  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 20, 2016 1:35 PM   in response to: Daniel Sonda in response to: Daniel Sonda
Daniel Sonda wrote:
I'm using Delphi 10 Seatle and FireDAC array DML to insert 43 records in a Firebird 2.5.1 database. The table has some numeric(15,4) fields and their relative params are filled with:

FDQuery.Params.ParamByName('field_A').AsCurrencys[Index] := Value;


All fields are inserted with correct values, except numeric ones. They are all inserted with the same wrong value 0.1044 instead of the parameter value.

Hi

Similar issue:

[https://forums.embarcadero.com/thread.jspa?threadID=119282&tstart=0]
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02