Subject Re: [IBO] FieldsDisplaySettings
Author Helen Borrie
At 09:32 PM 8/03/2003 +0000, you wrote:
>Hi all,
>i've got a problem, on which i couldn't find a good solution.
>I want to change the DisplayMask at runtime depending on the
>description for the quantity for example
>2 m of Rope displayed as 2,00m
>3 litre of gasoline displayed as 3,000 l
>3,25 m³ displayed as 3,250 m³.
>The values are stored as Numeric (15,3).
>
>Is it possible to change the FieldsDisplaySettings
>at runtime ?

Well - yes - but the change would be applied to the whole column, not just
a single cell.

One solution might be to define a calculated field (string) to contain the
display you want. Then, in the OnCalculateField event of the dataset, read
the value and the unit-of-measure from the Row object, and construct a
string for your calculated field.

Helen