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 1073 korisnika na forumu :: 110 registrovanih, 10 sakrivenih i 953 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: 015, A.R.Chafee.Jr., AK - 230, AleksSE, Alexa77, amadeus, amaterSRB, Apok, Armadillo, Ba4e, babaroga, bbogdan, Ben Roj, blue, Bombarder, Boris BM, BtR-45, bukefal, BWG, Cian, colji, cvrle312, debeli, Denaya, Django777, Djokislav, Drakce65, drpera, Duh sa sekirom, dukajov, Dungorth, famoso, Foxdie, GeoM, Georgius, Gheljda, Hardenberg, Haris, hatman, HrcAk47, ILGromovnik, Jose, Kobrim, komsija1, Krusarac, Kuroje, ladro, lcc, ljubo70, LostInSpaceandTime, Lotus, M-HOBBY, M74AB3, marko.markovic, markomacii9, mean_machine, Mercury, miki kv, mikrimaus, Milan A. Nikolic, milanpetkovicv, milenko crazy north, MILO-VAN, milos97, mist-mist, Mićko, monomah, Mskok, naki011, nazgul75, Neuromancer, niksa517, nuke92, perko91, PlayerOne, Povratak1912, Prašinar, predragc, PrincipL, raster12, renvoi, RJ, Rogan33, royst33, Rusmir, Sami_1ali, samo opusteno, sap, sekretar, Smajser, stegonosa, Str2022, Tas011, TBF1D, Token, tubular, vaci, vathra, vidra boy, vjetar, VladaDi, Vrač, vukdra, vuksa72, W123, Wrangler, x011, yrraf, zillbg, zmajbre