Arsip: Firebird alias record

more 14 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

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

more 14 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

more 14 years ago
donlego
select
CASE
WHEN status = 'T' THEN 'CLOSE'
WHEN status = 'F' THEN 'NO CLOSE'
END as STATUS
from
TABLENAME
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 2 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 10 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 10 years ago
Random Topic
- ask: .bpl konflik ?
by cyber_hecker in Tip n Trik Pemrograman more 12 years ago - pletak pletuk mysqLL
by nurez in MySQL more 17 years ago - export excel ke delphi
by tanyaku in Hal umum tentang Pascal Indonesia more 15 years ago - Menjelang Perubahan Tahun
by ichan29 in OOT more 13 years ago - Turbo Delphi
by delphi_warrior in Hal umum tentang Pascal Indonesia more 15 years ago - Masukin gambar format .Gif
by p2bf in Tip n Trik Pemrograman more 16 years ago - survey , mohon direspon.
by mat_koder in OOT more 15 years ago - Inser tanggal selama 1 tahun
by delphi1st in Tip n Trik Pemrograman more 16 years ago - Pemakaian Inno Setup ?
by budi_bunga in Tip n Trik Pemrograman more 15 years ago - insufficient memory
by Rogeb_Shewrite in Paradox more 16 years ago