Subject Re: RE: [firebird-support] Go ahead and laugh, SQL gurus
Author Pavel Menshchikov
Hello Clay,

CS> << If I were you, I would perform translation on client side, in
CS> application. It is very easy with something like this:

CS> ComboBox1.ItemIndex :=
CS> DataSet.FieldByName('COMPENSATION').AsInteger;>>

CS> Right, but I want to show the data in a DBGrid (CDS grid, to be more
CS> precise), and I want the "English" values to show, not simply the integers.

I think that Dmitry means that you fill your combo-box items
"statically" with "Good", "Excellent", etc. and then change an item
index accordingly.
AFAIR, with TDBGrids and TDataSets you can use OnGetText/OnSetText
events (of TDataSets' fields) to handle your situation on client side.


--
HTH
Best regards,
Pavel Menshchikov
http://www.ls-software.com