Arsip: if then else pada query

 
user image
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
user image
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:
user image
more 15 years ago

sepakterjang

db : access pake query...pliss donk tolongin
user image
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
Share to

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

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