Calculated Fields Question for the pros
Posted by Peterson on January 28, 2003 at 21:08:51:
I have a small problem;
I have two databases (paradox)
Currency fields in one and a number fields in the other.
I am creating a Calculated field based on currency and percentage.
procedure TForm1.Table1CalcFields(DataSet: TDataSet); begin Table1AgentGrossComm.Value := (Table1Coy_Gross_Commision.Value * Table2Split_Level.Value); End;
Result is I get all $0.00 in the Calculated field.
If I put in “ 0.65 “ in place of Table2Split_Level.Value (without the quotes of course) the calculation works perfectly.
In Table1 the field is defined as : Table1Coy_Gross_Commision: TCurrencyField;
In Table2 the field is defined as : Table2Split_Level: TFloatField;
I hope this is clear you, Would you be able to explain what I am doing wrong?
Thank you all in advance!