Accessing Field DisplayFormat at runtime

[Guest]

Hi,
I'm trying to set a DisplayFormat to a Field at run time.
It's through an TMyQuery component. Just like for a TMyTable,
when you right-click on a TmyTable, you can access the fields
available and then set a DisplayMask for each of the present
fields.

How can I do this programatically?

I tried (C++)
qryGeneric->Fields->Fields[1]->DisplayFormat = "#.0" ;

But it seems that something's wrong. Either Fields[n] ir DisplayFormat
is not a member of the left-most member.
This drives me nuts.
Any clue?
Thanks for any help.
Steve

[Ikar]

DisplayFormat isn't a property of TField , but some its descendants.
You can read details about it in Delphi help.

[annlee]

Hi Anonymous,

I have almost exactly the same problem ur having except that im using paradox (not my choice... grrr!) im just wondering if you have found a solution to this already, id appreciate it very much if you can share it with me.

Thanks!

Hi,
I'm trying to set a DisplayFormat to a Field at run time.
It's through an TMyQuery component. Just like for a TMyTable,
when you right-click on a TmyTable, you can access the fields
available and then set a DisplayMask for each of the present
fields.

How can I do this programatically?

I tried (C++)
qryGeneric->Fields->Fields[1]->DisplayFormat = "#.0" ;

But it seems that something's wrong. Either Fields[n] ir DisplayFormat
is not a member of the left-most member.
This drives me nuts.
Any clue?
Thanks for any help.
Steve

[Guest]

((TNumericField*)(DataSet->Fields->Fields))->DisplayFormat="0.00";

will work if the field is a numeric field, otherwise it will cause an access violation.

[a.alekizoglou]

In this case it works correctly, but when you ran an Dataset.Execute the DisplayFormat gets back to ''.

I am using MyDAC 3.55.0.26 with Delphi 7

[Antaeus]

This happens because each time you open/reopen your dataset, fields are recreated.
Try to create fields at design time.