Arsip: Access Date Datatype on Excel by ADOQuery use Delphi
more 14 years ago
iammcrayeps
Hi..
Guys, gw ada sepenggal sourcecode.. gw ambil data dari excel, di excel data tersebut bertipe tanggal.. gw mau compare dan ambil data dari excel yang dimana tanggalnya adalah tanggal hari ini...
berikut sourcecode nya:
DataModule2.ADOQuery1.Close;
DataModule2.ADOQuery1.SQL.Text:='SELECT COUNT(REFNO) AS DATACOUNT FROM [FSALESH$] WHERE TRDATE='+DateToStr(tanggal)+' AND INVOICENO LIKE '+QuotedStr('STR%');
DataModule2.ADOQuery1.Open;
Tapi g bisa ambil data yang bertipe Date... Jadi recordcount nya 0 trus...
Anybody help?
Thanks
more 14 years ago
elva_ivana
kutipnya ketimggalan Bro ...
DataModule2.ADOQuery1.Close;
DataModule2.ADOQuery1.SQL.Text:='SELECT COUNT(REFNO) AS DATACOUNT FROM [FSALESH$] WHERE TRDATE='''+DateToStr(tanggal)+''' AND INVOICENO LIKE '+QuotedStr('STR%');
DataModule2.ADOQuery1.Open;
more 14 years ago
iammcrayeps
DataModule2.ADOQuery1.Close;
DataModule2.ADOQuery1.SQL.Text:='SELECT COUNT(REFNO) AS DATACOUNT FROM [FSALESH$] WHERE TRDATE='''+Datetostr(tanggal)+''' AND INVOICENO LIKE '+QuotedStr('STR%');
DataModule2.ADOQuery1.Open;
Tetep error bro, 'Data Type Mismatch in criteria expression'
ini ak sambung ke excel loh bro...
error bro...
more 14 years ago
iammcrayeps
DataModule2.ADOQuery1.Close;
DataModule2.ADOQuery1.SQL.Text:='SELECT COUNT(REFNO) AS DATACOUNT FROM [FSALESH$] WHERE TRDATE='''+Datetostr(tanggal)+''' AND INVOICENO LIKE '+QuotedStr('STR%');
DataModule2.ADOQuery1.Open;
Tetep error bro, 'Data Type Mismatch in criteria expression'
ini ak sambung ke excel loh bro...
error bro...
more 14 years ago
iammcrayeps
Ini kode gw :
path := 'c:\DOSemenTemp\FSALESH.xls';
connectString:='Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=' + path + ';' +
'Extended Properties=Excel 8.0;';
ADOConnection1.Close;
ADOConnection1.ConnectionString:=connectString;
ADOConnection1.Open;
tanggal:=Date-6;
FormatDateTime('m/d/yy',tanggal);
edit1.Text:=DateToStr(tanggal);
ADOQuery1.Close;
ADOQuery1.SQL.Text:='SELECT TRDATE FROM [FSALESH$] WHERE TRDATE='+DateToStr(tanggal);
ADOQuery1.Open;
ADOQuery1.First;
memo1.Clear;memo1.Lines.Add(IntToStr(ADOQuery1.RecordCount));
for I := 1 to ADOQuery1.RecordCount do
begin
memo1.Lines.Add(ADOQuery1['TRDATE']);
ADOQuery1.Next;
end;
data di excel 9/1/2009
tanggal di delphi 9/1/2009
sama persis tp g ketemu
recordcount nya 0!!
huxmore ...
- 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
- Borland Technology Day, ada yg ikut?
by LuriDarmawan in OOT more 17 years ago - Help .. Terjemahin in delphi Dunk ...
by daryl_sukma_gumilar in Hal umum tentang Pascal Indonesia more 14 years ago - Cara Tampilin Nomor Halaman Rave Report ....
by sianchan in Tip n Trik Pemrograman more 13 years ago - pengolahan citra
by roan_delphier in Enginering more 17 years ago - Cara mudah untuk Memasukkan TIMage ke Array?
by ivan in Hal umum tentang Pascal Indonesia more 16 years ago - Selamat Jalan Kawan, Hati-hati dan TetapSemangaT
by LuriDarmawan in Hal umum tentang Pascal Indonesia more 14 years ago - membaca MAC Address di delphi
by AirBening in Network, Files, I/O & System more 18 years ago - Modem GPRS untuk SMS gateway
by delphi1st in Enginering more 16 years ago - ShellTreeview....
by Indr@ in Multimedia & Graphic Enhancement more 13 years ago - Grouping pada report
by kepew in MsSQL more 13 years ago