Arsip: Firebird alias record

 
user image
more 13 years ago

vera

da yg tau ga caranya query ntuk alias tpi record misal punya 1 kolom punya 2 record T dan F nah pngen nampilinnya nya Close untuk record T dan No Close untuk record F
user image
more 13 years ago

DelphiExpert


SELECT T as "Close", F as "No Close" FROM CLOSE_CLOSE_AN
user image
more 13 years ago

simba

@DE: pake case kali! :P
user image
more 13 years ago

DelphiExpert

@simba: wooh... ngga' teliti menelaah pertanyaan :mrgreen: benar pake case! ini gara2 abis begadang di RS - hik :(
user image
more 13 years ago

ImanD

xixixixi @DE gara2 rumah sakit nich sapa yg sakit ya {moga cepet sembuh az dech}, bentul kata @simba pke case atw if sample simple

if(Field_name = 'T', 'CLOSE','No Close')
-- or
case when Field_name = 'T' then 'Close' else 'No Close' end
user image
more 13 years ago

donlego

select CASE WHEN status = 'T' THEN 'CLOSE' WHEN status = 'F' THEN 'NO CLOSE' END as STATUS from TABLENAME
more ...
  • Pages:
  • 1
Share to

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com