Arsip: Firebird alias record
more 16 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 16 years ago
DelphiExpert
@simba: wooh... ngga' teliti menelaah pertanyaan :mrgreen: benar pake case!
ini gara2 abis begadang di RS - hik :(
more 16 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 16 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 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- kaos delphi ID
by dney in OOT more 15 years ago - Masukkin data time dgn mask edit???
by camp_sire in Tip n Trik Pemrograman more 16 years ago - Apakah MySQL Gratis ?
by hendrang in MySQL more 17 years ago - Mengambil Huruf Arab Dan mengermbalikannya Ke Edit Text..??
by juan81 in Hal umum tentang Pascal Indonesia more 16 years ago - Flash ActiveX pada Delphi 2007
by sudrun in Tip n Trik Pemrograman more 16 years ago - Baca file text
by pegal_linux in Tip n Trik Pemrograman more 19 years ago - Menampilkan Log PABX ke dalam Tabel
by s0t4 in Tip n Trik Pemrograman more 14 years ago - nampilin jpg dari MySQL
by lela in MySQL more 18 years ago - ttg tanggal.....???
by Rogeb_Shewrite in Tip n Trik Pemrograman more 17 years ago - perintah ADOQuery yang mendeteksi posisi record
by sutomohd in MsSQL more 18 years ago