MyCity » Baze podataka » How to replace the field type and value in dbgrid?

How to replace the field type and value in dbgrid?

Napisano na dan: 2.4.2018

How to replace the field type and value in dbgrid?

Idi na vrh

Poslao: 02 Apr 2018 04:24
Idi na vrh
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.

MyCity » Baze podataka » How to replace the field type and value in dbgrid?

Ko je trenutno na forumu
 

Ukupno su 1861 korisnika na forumu :: 65 registrovanih, 9 sakrivenih i 1787 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 20624 - dana 04 Apr 2026 04:18

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: 015, 357magnum, 9k38, _Sale, Ailton, awathorn, Baždaranac, bojank, Bojcca, bojcistv, BOXRR, Buzdovan, cenejac111, d.arsenal321, dekan.m, deLacy, DJORDJE-NO-1, DonRumataEstorski, dukajov, dunavzed, dusanobr, Electron, Fructo, galerija, Gerilac, goxin, Great White, Jakonjveliki, jarovitt, JK, king111, Koplje, laurusri, Lazur_01, leopard83, Lieutenant, Lj_ubo, Lucije Kvint, mat, mačković, miki kv, mikrimaus, mile.ilic75, milos.cbr, nebkv, nenad81, Nmr, nnnnnnnnnn, OKT, Pavel Medved, pceklic, pein, ping15, Prometeus, Robin, royst33, S-G, stegonosa, tamno.nebo, Tumansky, vathra, xAlex2, zaoka, zdrebac, zombicar153