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 666 korisnika na forumu :: 39 registrovanih, 4 sakrivenih i 623 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 3028 - dana 22 Nov 2019 07:47

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: A.R.Chafee.Jr., AC-DC, amaterSRB, babaroga, Bane san, Boris90, celeron, Cirkon, dac, dankisha, djboj, Djokkinen, dogodine, dolinalima, dule10savic, GORDI, ivica976, kovinacc, madza, MB120mm, mercedesamg, Misirac, oddsock, ostoja, pavle_pzs, pedja63, Profica, RJ, S2M, sakota79, Sale.S, Snorks, Srki94, trutcina, VaRvArI 85, virked, VJ, wolverined4, yrraf