Change DBGrid display Text

[clemsonzhe]

help!!! I'm trying to change the data being displayed in a DBGrid cell to another language; but i would like to keep the data set (the query that DBGrid is attached to) intact (with all the data still in english).
Is there any way to do this? I tried dbgrid.fields.text := 'blah', but it wouldn't change becuase the data set isn't in edit mode (from this, it looks like Delphi makes you change the query data as well); but if I try IBQuery.edit, it complains that it "cannot Update"
thanks in advance..

 

[ChrisGSchultz]

I'd suggest approaching this a different way....

You can keep the DBGrid, but you need an extra (calculated) field to use as a scratch pad for your translated language.

The new field is then displayed dynamically, depending on the language you use. With this approach you can use an on scroll event or similar to perform the calculation.

Another approach would be to display your data in a string grid, loading it from the IBquery - it keeps your original data intact. However, it requires more work to set it up....

Chris ;-)

 

[clemsonzhe]

Thanks for the idea!
my problem is that I must do this for a "dynamic query" (aka, no fields in field editor, they get filled at run time); and I cannot abandon our custom-made DBGrid to use a string grid...
any other suggestions?
Thanks!