Why can't I multiply money with a numeric value as follows.

[delphiman]

I have Math in the Uses clause but the following nevertheless won't work. Can someone please tell me why?

  tblMStockItem.Value := FloatToCurr(tblMStockSqMtrs.Value * tblMStockCostPMetre.Value);

 

[earthandfire]

I haven't used Delphi for a long time, but:

It appears that you are trying to multiply a real (tblMStockSqMtrs.Value) by a currency (tblMStockCostPMetre.Value) and then assign the result to a currency (tblMStockItem.Value ).

Convert tblMStockCostPMetre.Value to a real (from memory using CurrToFloat) and then convert the result to currency

 

[gcaramia]

What's your DB and field's definitions?

 

[delphiman]

gcaramia

>What's your DB?

Parodox table "tblMStock".
Field "Item" is the required monetary value of the square area.
Field "SqMtrs" is obvious and a numric value
Field "CostPMetre" is obvious and a monetary value.