Arsip: ask query
more 13 years ago
don2103
suhu - suhu sekalian tolongin dong, hehehe...
saya ingin menampilkan data tanggal 7 hari kedepan,
contohnya sekarang kan tanggal 01/10/10 (tanggal yang ada dalam komputer) ingin menampilkan pada tanggal 08/10/10
berikut querynya, [sql]DM.tpemakaian.SQL.Add('WHERE jthtempopajak =#'+DateToStr(date+7)+'#');[/sql]
setelah saya compile its ok, nah ketika di klik malah isi datanya kosong....
Terima Kasih suhu - suhu sekalian.
more 13 years ago
mas_kofa
kemungkinan pengaruh format pada fungsi DateToStr, coba rubah pake parameter....
DM.tpemakaian.SQL.ADD('WHERE jthtempopajak = :tgl');
DM.tpemakaian.ParambyName('tgl').asDate := Date + 7;
more 13 years ago
don2103
@ mas kofa : saya punya table (tpemakaian : AdoQuery) -> database access, nah kalau membuat parameter, apakah tidak merusak data tpemaikan mas kofa? terus sudah saya coba buat parameter di tpemakaian akan tetapi kata delphinya begini :
[list:2560ae0566][Error] UFHari.pas(47): Undeclared identifier: 'ParambyName'
[Error] UFHari.pas(47): Missing operator or semicolon
[Fatal Error] UFUtama.pas(62): Could not compile used unit 'UFHari.pas'
[/list:u:2560ae0566]
itu kenapa yah mas kofa ??
more 13 years ago
mas_kofa
1. biasa nya format tanggal untuk query di akses adalah "mm/dd/YYYY";
2. untuk ADO paramaterbyName nya ada di properti Paramaters
ADOQuery.Parameters.ParambyName().Value;
saran ku, kamu coba point yg pertama, pake format 'mm/dd/YYYY';
DM.tpemakaian.SQL.Add('WHERE jthtempopajak =#'+FormatDateTime('mm/dd/YYYY', date+7) + '#');
kalo tidak tampil ganti
DM.tpemakaian.SQL.Add('WHERE jthtempopajak =#'+FormatDateTime('dd/mm/YYYY', date+7) + '#');
note :
kalo pake zeos lebih gampang....tinggal pake code seperti posting ku sebelumnya
more 13 years ago
don2103
@Mas kofa, betul - betul mas kofa top abizz.... akhirnya muncul dan berhasil lega dari penderitaan, masih ada satu lagi yg belum beres, hiks..hiks... so, matur nuwun yo mas.. :D
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 3 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 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 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- Help me...hasil pembagian firebird aneh.....
by batozai in FireBird more 16 years ago - arti dari ORDER BY 37,5
by lukersgn in MySQL more 12 years ago - Penambahan Secara Otomatis Do Dbgrid
by anie_manis in MySQL more 18 years ago - OOT: Sahabat Silat Peduli ke Padang
by LuriDarmawan in OOT more 14 years ago - Pilih yg mana ? (Delphi 7 / Delphi 2007 / Delphi 2010)
by itoru in Lain-lain more 12 years ago - Relasi form(or what?)
by Pontiac in Enginering more 18 years ago - [sug] searching by date
by cyber_hecker in Kritik & Saran more 16 years ago - ModifySQL u/ data yg sama di MySQL 5.0.45 bermasalah!
by bugan in MySQL more 16 years ago - (ask)DB&Fs
by Indr@ in Lain-lain more 13 years ago - Minta Tolong Koneksi Delphi dengan Interface PPI8255
by yodevil_house in Network, Files, I/O & System more 18 years ago