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 1209 korisnika na forumu :: 132 registrovanih, 14 sakrivenih i 1063 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: Aleksandar Tomić, Aleksandar1991, aleksmajstor, ambra, antonije64, Aristotle2002, asdfjklc, Aska, AudioTehnica, Automaticar, Baždaranac, Bbbggg1979, blankspace, bobo85, bojcistv, brandža84, cifra, Crazzer, cyprus, darkojbn, Darth Malak, Dekanovic, Deki Duga Devetka, deLacy, Dimitrise93, Dioniss, Djuro2000, Doca, draganca, dunavzed, dusan.l, Dzambas, ElvisP, Ercomero, Feller, Filip1, france93, gale48, galerija, Gall, Giro77, Goran_, Goxy1, GT, hatman, Igor Antonic, InzenjerBL, IpMan, ivran064, Jakonjveliki, Jovan1983, Još malo pa deda, Kamov, kihot, kirucar, ladro, ljuba.b, lord sir giga, luja, luka35, maiden6657, Marko Marković, Medojed, mercedesamg, Mickey91, Miha79, mikrimaus, MiljanXD, milos97, Mirage 2000N, Mićko, mkukoleca, Mrav Obrad, mrvica78, Mzee, Naj-Turs, Nemanja Opalić, neutrino, nevjerna beba, nisamBot, nnovakis, NNPD, nobutado, novator, Orc, pceklic, pein, Pero, Perudin_92, Pilence, Pilipenda, Plavi Jadran, Plavi1, PMsnow, prasinar, Primus17, Resnica, RS28, Rsbg91, ruma, samocitam, SamoGledam, sasa87, Schmidt, Silvertooth, Solunac na steroidima, ssekir75, stalja, steksi, strelac07, Teodor60, The_new_Statesman, travisrise, tvlada, udbas, vaci, vathra, vensla, vlado_pg, voja64, vrlenija, vukajlo71, vuksa72, Wehicle, zajcev1, Zandar, zgoljo, zlatkoa987, Zoran1959, zubri, Zvone, 1107