Arsip: if then else pada query

more 15 years ago
sepakterjang
var
det1,det2 : string;
begin
IF datetime > 07:00 then
det1 := dateTostr(datetimepicker1.Datetime);
det2 := dateToStr(dateTimePicker2.Datetime);
query1.Close;
query1.SQL.text := 'select departmentName, employeeFirstName, datetime,datetime - 07*1/24/60 as wktUpdate from personalLog P ,employee E ,department D where datetime >= :a and datetime <= :b AND P.FingerPrintID = E.FingerPrintID AND E.departmentCode = D.DepartmentCode' ;
query1.ParamByName('a').AsString := det1;
query1.ParamByName('b').AsString := det2;
query1.Close;
query1.Open;
end;
dengan menggunakan code diatas bagai mana sy melakukan
IF datetime > 07:00 then
tolong donk deadline nih.. br blajar

more 15 years ago
reminder2k1
mmhhhh... ga di jelasin pake DBnya apaan... :)
Tapi, umumnya rata2 pake CASE WHEN, tapi ada juga yg pake IIF
coba lihat di help engine DB yg di pakai ya??? :mrgreen:

more 15 years ago
sepakterjang
jd kira2 tujuan sy kaya gini:
menampilkan seluruh record pada field datetime dengan ketentuan
apabila lewat pikul 07:00 maka record pada datetime di kurangi 7 menit..
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
- gimana cara bikin compact utk file Access (MDB) pd Delphi
by shindo in Hal umum tentang Pascal Indonesia more 17 years ago - Parameter utk report
by l1th1um in Reporting more 17 years ago - import file excel, caranya?
by cyberdhoe in Enginering more 17 years ago - [TANYA] algoritma motion detection VCL video 4.01
by nurmanwiguna in Multimedia & Graphic Enhancement more 13 years ago - Input Null Field in Ms Access with ADO
by RoenZ in Lain-lain more 16 years ago - Soal Font yang Cilik di forum ini
by danieljun in Kritik & Saran more 17 years ago - ModifySQL u/ data yg sama di MySQL 5.0.45 bermasalah!
by bugan in MySQL more 17 years ago - Error Win 2003
by kaka-delphi in OOT more 19 years ago - Cara menyimpan hasil aplikasi dari stringgrid ke explorer
by rahul_cayang in Hal umum tentang Pascal Indonesia more 17 years ago - Pilihan Backup Data
by n3o_cybertech in Network, Files, I/O & System more 17 years ago