How to replace the field type and value in dbgrid?

How to replace the field type and value in dbgrid?

offline
  • Pridružio: 02 Apr 2018
  • Poruke: 1

How to replace the field type and value in dbgrid?

My SQL query:

Code: XML [Select] DBForm.DBquery.SQL.text:='select callstart, callend, origin, destination, direction from callrecord;

termtype are integer values 0...3, instead I would like to show in dbgrid column fields: None, Incoming, Outgoing or Internal, accordingly. These text values are not stored in any DB table to be joined with; it is also not allowed to add smth to this DB (in my case). Is there a way how to do this "on fly", when the dbgrid obtains the values from the DB?



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.
Ko je trenutno na forumu
 

Ukupno su 675 korisnika na forumu :: 32 registrovanih, 5 sakrivenih i 638 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 3466 - dana 01 Jun 2021 17:07

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: _commandos_, acatomic, amaterSRB, amonsrb, BlackPhantom, Buzdovan, doktor1964, dragoljub11987, Duh sa sekirom, Georgius, goxin, greenmachine, Insan, jednoruki krstivoje, kovinacc, madza, Majstorr, MareRema, mercedesamg, Milan A. Nikolic, Miroslav Griffin, nebkv, nenad81, pavle_pzs, pein, Sale.S, Slobodan Kovačević, sovanova95, vasa.93, vlvl, xJeremijAx, Živković