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
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 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 5 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
- nanya update SQL statement..pliss
by divanda in Hal umum tentang Pascal Indonesia more 17 years ago - Membuat Form LOGIN.......
by vebnu in Tip n Trik Pemrograman more 18 years ago - Import ke MSSQL dari database lain
by xmbohx in MsSQL more 17 years ago - ask : saat program running tdk bisa tekan alt+tab
by adhisyanda in Hal umum tentang Pascal Indonesia more 15 years ago - Input data faktur
by onsir in Hal umum tentang Pascal Indonesia more 17 years ago - [?] Bikin Pack atau Update-an u/ Program yg Sudah Berjalan?
by babypigs in Enginering more 17 years ago - [ASK] MySQL Error Can't Create TCP/IP
by holmes in MySQL more 16 years ago - Record Dbgrid yg dipilih
by e_soep in Tip n Trik Pemrograman more 17 years ago - link game delphi....
by EkoIndri in Games more 18 years ago - Indexing Document
by trimbil in Enginering more 15 years ago