Arsip: display data menggunakan parameter tanggal

more 13 years ago
lukersgn
ada yg bisa bantu ngga bro,,gw ada problem, mau display data di datagrid menggunakan parameter tanggal, cuma selalu minta declare variabel, sudah di add var nya, tapi masih tetap error yg sama, apa yah yg kurang disini? terima kasih bro,, berikut code nya :
procedure TFormCashAdvanceSum.BtnRunClick(Sender: TObject);
begin
sql := 'SELECT * FROM HR_EMP_MISSION_ORDER';
if tgl.text <> '' then begin
DecodeDate(piltg.Date, myYear, myMonth, myDay);
sql := sql + ' and (DAY(tgl) = '+IntToStr(myDay)+') AND (MONTH(tgl) = '+IntToStr(myMonth)+') AND (YEAR(tgl) = '+IntToStr(myYear)+')';
end;
qCA.SQLs.SelectSQL.Text:= sql;
qCA.Active := True;
if qCA.RecordCount = 0 then
begin
MessageDlg('Data Not Found', mtCustom, [mbOK],0)
end;
end;
procedure TFormCashAdvanceSum.piltgChange(Sender: TObject);
begin
DecodeDate(piltg.Date, myYear, myMonth, myDay);
tgl.Text := IntToStr(myDay)+'/'+IntToStr(myMonth)+'/'+IntToStr(myYear);
end;
berikut errornya
[Error] CashAdvanceSum.pas(60): Undeclared identifier: 'myYear'
[Error] CashAdvanceSum.pas(60): Types of actual and formal var parameters must be identical
[Error] CashAdvanceSum.pas(73): Undeclared identifier: 'myYear'
[Error] CashAdvanceSum.pas(73): Types of actual and formal var parameters must be identical
[Fatal Error] Sysapp.dpr(39): Could not compile used unit 'CashAdvanceSum.pas'

more 13 years ago
henry_sys
schema table bagaimana...?
menurut gw lu kesulitan untuk membalikkan tanggal dari format dd/mm/yyyy menjadi yyyy/mm/dd, moga2 saya benar, karena adanya function decodate() di coding anda;
sara saya knp tdk menggunakan TDateTimePicker biar gampang tinggal dibalikkan aja formatnya
misal
sql.close;
SQL.Text :='Select * from nama_table where tgl='+('yyyy/mm/dd'.DpTgl.datetime);
sql.open;
kr2 begitu.....
semoga membantu.....

more 13 years ago
cyber_hecker
databasenya pake apa ? kalo pake MS SQL lebih gampang pake cara ini :
if edtTgl.Text <> '' then
SQL.Text = 'SELECT FROM NM_TABLE WHERE TGL BETWEEN CONVERT(DATETIME,'+
QuotedStr(edtTgl.Text)+',103) AND CONVERT(DATETIME,'+QuotedStr(edtTgl2.Text)+',103)';
dengan syarat format tanggal adalah dd/MM/yyyy. tapi kalo sudah menggunakan komponen yang
ada tanggalnya. lebih gampang lagi, jadi seperti ini :
if edtTgl.Text <> '' then
SQL.Text = 'SELECT FROM NM_TABLE WHERE TGL BETWEEN CONVERT(DATETIME,'+
QuotedStr(FormatDateTime('dd/MM/yyyy', edtTgl.Date))+',103) AND CONVERT(DATETIME,'+
QuotedStr(FormatDateTime('dd/MM/yyyy', edtTgl2.Date))+',103)';
kalo menggunakan Firebird atau mySQL langsung pake format yyyy-MM-dd
more 13 years ago
cyber_hecker
kalo saya umumnya ku simpan di parameter. jadi di query :
[sql]
...
WHERE
B.AC3_GRUP = :ac3
AND A.TGL_JURNAL BETWEEN :dr_tgl AND :sp_tgl
[/sql]
di program tinggal di tulis
...
Params.ParamByName('dr_tgl').AsString := FormatDateTime('yyyy-MM-dd', pDR_TGL);
Params.ParamByName('sp_tgl').AsString := FormatDateTime('yyyy-MM-dd', pSP_TGL);
...
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
- ada yang tau gak kalo pengen gini??
by alvonz in Tip n Trik Pemrograman more 15 years ago - konversi C++ ke delphi
by demarda in Network, Files, I/O & System more 18 years ago - Jam Analog..??
by asiyrob in Tip n Trik Pemrograman more 17 years ago - Lomba Hack-Shareware Aplikasi Delphi (spontanitas)
by LuriDarmawan in Hal umum tentang Pascal Indonesia more 19 years ago - TMemo...
by dcnter in Tip n Trik Pemrograman more 16 years ago - Selisih waktu dalam milidetik
by LuriDarmawan in Tip n Trik Pemrograman more 19 years ago - quick report with zquery
by sulth4n in Tip n Trik Pemrograman more 19 years ago - Database Connection
by aciang_007 in Hal umum tentang Pascal Indonesia more 16 years ago - help my
by kaka in Paradox more 17 years ago - Tanya? Bagaimana cara meyeleksi list di combobox
by maseko in Reporting more 16 years ago