Arsip: SQL : Select utk tipe data Number di Ms Access

more 14 years ago
onsir
Bagaimana cara untuk mencari data dengan perintah SQL, dimana data yang sebagai criteria tsb bertipe Number di Ms-Access.
CustomerID bertipe Number.
Saya sdh coba spt ini tetapi masih eror
sql1:='';
sql1:='select * from orders where CustomerId= ' + QuotedStr(smdbgrid1.Fields[5].AsString);
adoQuery1.SQL.Clear;
adoQuery1.SQL.Add(sql1);
adoQuery1.Open;
if adoQuery1.Eof then //jika tidak ketemu atau tidak ada, lakukan insert data
begin
//proses simpan data
end
else
begin
Application.MessageBox('Data sdh ada','Bintasy',mb_ok);
end;

more 14 years ago
yayaretina
@onsir:sql1:='select from orders where CustomerId= ' + QuotedStr(smdbgrid1.Fields[5].AsString);
sql1:='select from orders where CustomerId= ' + smdbgrid1.Fields[5].AsInteger;

more 14 years ago
bagussb
@onsir.. querynya sih sudah benar...
@yayaretina... mm.. sql1 kan tipe datanya string.. kalo digabung dengan fields[x].asinteger bukannya bakal ada error baru.. :-D
mmmm.. kalo menurut saya errornya karena smdbgrid1.Fields[5].AsString itu ngga ada valuenya..
jadinya hasilnya empty string alias ('')... kalo gini kan emang pasti error querynya.. :-D
hi hi hi.. mudah2an beners..

more 14 years ago
bagussb
eh.. ada yang kelewat kayanya...
kalo tipe datanya number.. kenapa pake quotedstr yah....?

more 14 years ago
onsir
masih gak bisa erronya spt ini,
[Error] uAdmSales.pas(530): Incompatible types: 'String' and 'Integer'
klw sy buat spt ini
sql1:='select * from orders where CustomerId= ' + StrToInt(smdbgrid1.Fields[5].AsString);
error juga

more 14 years ago
yayaretina
coba pake dengan parameter..
sql1:='select * from orders where CustomerId= :custId';
..ParamByName('custId').AsInteger:=smdbgrid1.Fields[5].AsInteger
atau di coba dulu smdbgrid1.Fields[5].AsInteger diganti dengan nilai CustomerID yang sudah ada.
klo bisa, harusnya script diatas juga bisa.. :D
more 14 years ago
onsir
Ya, sdh bisa pake parameter.
sql1:='select * from orders where CustomerId = :custID';
sql1:=sql1 + ' and EmployeeID = :emplId';
sql1:=sql1 + ' and OrderDate = :ordDate';
sql1:=sql1 + ' and PurchaseOrderNumber = :poId';
sql1:=sql1 + ' and ProductID = :prodId';
adoQuery1.SQL.Clear;
adoQuery1.SQL.Add(sql1);
adoQuery1.Parameters.ParamValues['custId']:=smdbgrid1.Fields[15].AsInteger;
adoQuery1.Parameters.ParamValues['emplId']:=smdbgrid1.Fields[16].AsString;
adoQuery1.Parameters.ParamValues['ordDate']:=smdbgrid1.Fields[0].AsDateTime;
adoQuery1.Parameters.ParamValues['poId']:=smdbgrid1.Fields[5].AsString;
adoQuery1.Parameters.ParamValues['prodId']:=smdbgrid1.Fields[17].AsString;
adoQuery1.Open;
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 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 2 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 10 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 10 years ago
Random Topic
- Mohon bantuan dari sahabat delphi-id.org forum ?
by putu_niki in Tip n Trik Pemrograman more 15 years ago - halaman dinamis fastreport????
by bintanghtm in Reporting more 14 years ago - Pemrosesan file text di delphi
by CurutZ in Tip n Trik Pemrograman more 15 years ago - Ask: Direct Printing Code ?
by cyber_hecker in Tip n Trik Pemrograman more 17 years ago - Upload Image (fitur baru)
by LuriDarmawan in Hal umum tentang Pascal Indonesia more 17 years ago - hitung biaya kamar?
by rose_see in MySQL more 15 years ago - SIP Delphi
by tatang.arifin in Hal umum tentang Pascal Indonesia more 16 years ago - ada yang punyaK pA ga yak *sos kod* buwad TRANSTOOL...?
by selx99 in Paradox more 14 years ago - PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 2 years ago - ada yang pernah pake ISO buat transaksi ATM
by alvonz in Enginering more 14 years ago