Subject Re: [firebird-support] Go ahead and laugh, SQL gurus
Author Dmitry Sibiryakov
On 25 Jul 2005 at 16:49, Clay Shannon wrote:

>I am storing beaucoup integers in a table which correspond to a
>multiple-choice selection (1 = excellent, 2 = good, etc.)
>
>When displaying the values on a form, I want to show those text values
>rather than integers.

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

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

--
SY, Dimitry Sibiryakov.