Arsip: syntax error in from clause
more 13 years ago
fongers
Dear master delphi mau nanya ne apa yang salah ya pada query ini?
saat event combobox on change selalu muncul "syntax error in from clause"
dm.qryQEksportKeExcel.SQL.Clear;
SQLKoe:='SELECT a.NOMOR, a.NBaru, a.NAMA, a.ALAMAT, a.ZONA, b.Telp, b.Hp, a.GOL, a.STS, a.LOK, a.tCatat=:xcatat, a.JML=:xrek, a.DENDA=:xdenda, a.TOTAL from [REKL a],[TELPHP b], WHERE a.NOMOR = b.NoPam ';//and a.tCatat='+cbtglcatateksportexcel.Text+' ';
dm.qryQEksportKeExcel.SQL.Add(SQLKoe);
dm.qryQEksportKeExcel.Parameters.ParamByName('xcatat').Value:=cbtglcatateksportexcel.Text;
dm.qryQEksportKeExcel.Parameters.ParamByName('xrek').Value := edtrekeksport.Text;
dm.qryQEksportKeExcel.Parameters.ParamByName('xdenda').Value := edJumdenda.Text;
dm.qryQEksportKeExcel.Open;
pnlBawahEksportkeexcel.Caption := 'Jumlah Data Yang akan diEksport = '+IntToStr(dm.qryQEksportKeExcel.RecordCount)+'-Record';
more 13 years ago
budi_sleman
@fongers: Dear master delphi mau nanya ne apa yang salah ya pada query ini? saat event combobox on change selalu muncul "syntax error in from clause"kalau perintah select itu kan ngambil data dari tabel, kok ada a.tCatat=:xcatat, a.JML=:xrek, a.DENDA=:xdenda, from [REKL a],[TELPHP b] coba dibenahi SQL nyadm.qryQEksportKeExcel.SQL.Clear; SQLKoe:='SELECT a.NOMOR, a.NBaru, a.NAMA, a.ALAMAT, a.ZONA, b.Telp, b.Hp, a.GOL, a.STS, a.LOK, a.tCatat=:xcatat, a.JML=:xrek, a.DENDA=:xdenda, a.TOTAL from [REKL a],[TELPHP b], WHERE a.NOMOR = b.NoPam ';//and a.tCatat='+cbtglcatateksportexcel.Text+' '; dm.qryQEksportKeExcel.SQL.Add(SQLKoe); dm.qryQEksportKeExcel.Parameters.ParamByName('xcatat').Value:=cbtglcatateksportexcel.Text; dm.qryQEksportKeExcel.Parameters.ParamByName('xrek').Value := edtrekeksport.Text; dm.qryQEksportKeExcel.Parameters.ParamByName('xdenda').Value := edJumdenda.Text; dm.qryQEksportKeExcel.Open; pnlBawahEksportkeexcel.Caption := 'Jumlah Data Yang akan diEksport = '+IntToStr(dm.qryQEksportKeExcel.RecordCount)+'-Record';
more 13 years ago
cyber_hecker
kalo menggunakan perintah seperti ini bisa ga ?
[sql]SELECT :XPARAM1 AS FIELD1, :XPARAM2 AS FIELD2
FROM TABEL1[/sql]
aku ndiri gak pernah make cara kayak yang diatas, karena lebih sering menggunakan variable untuk querynya. contoh :
[sql]DECLARE @A INT, @B INT
SET @A = :XPARAM1
SET @B = :XPARAM2
SELECT @A AS FIELD1, @B AS FIELD2
FROM TABEL1[/sql]
more 13 years ago
DelphiExpert
Error kebanyakan koma bro, ilangin dulu deh :lol:
... [TELPHP b], WHERE a.NOMOR = ...
// -----------^ Kebanyakan koma :)
more 13 years ago
dadanarifin
@fongers: Dear master delphi mau nanya ne apa yang salah ya pada query ini? saat event combobox on change selalu muncul "syntax error in from clause"bETUL Komanya kebanyakan.. Sesudah [TELPHP b] jANGAN pAKE kOMA lAGIdm.qryQEksportKeExcel.SQL.Clear; SQLKoe:='SELECT a.NOMOR, a.NBaru, a.NAMA, a.ALAMAT, a.ZONA, b.Telp, b.Hp, a.GOL, a.STS, a.LOK, a.tCatat=:xcatat, a.JML=:xrek, a.DENDA=:xdenda, a.TOTAL from [REKL a],[TELPHP b] WHERE a.NOMOR = b.NoPam ';//and a.tCatat='+cbtglcatateksportexcel.Text+' '; dm.qryQEksportKeExcel.SQL.Add(SQLKoe); dm.qryQEksportKeExcel.Parameters.ParamByName('xcatat').Value:=cbtglcatateksportexcel.Text; dm.qryQEksportKeExcel.Parameters.ParamByName('xrek').Value := edtrekeksport.Text; dm.qryQEksportKeExcel.Parameters.ParamByName('xdenda').Value := edJumdenda.Text; dm.qryQEksportKeExcel.Open; pnlBawahEksportkeexcel.Caption := 'Jumlah Data Yang akan diEksport = '+IntToStr(dm.qryQEksportKeExcel.RecordCount)+'-Record';
more 13 years ago
fongers
-----------------------------
var SQLKoe : string;
begin
if cbtglcatateksportexcel.Text ='' then Messagebox(handle, 'Peringatan Keras !!! '#13'Nomor pam Tidak Boleh Kosong'#13'Data Tidak Ada yang di Tampilkan','PERINGATAN !! ',MB_ICONWARNING or MB_OK);
begin
dm.qryQEksportKeExcel.SQL.Clear;
SQLKoe:='SELECT REKL.NOMOR, REKL.NBaru, REKL.NAMA, REKL.ALAMAT, REKL.ZONA, TELPHP.Telp, TELPHP.Hp, REKL.GOL, REKL.STS, REKL.LOK, REKL.tCatat=:xcatat, REKL.JML=:xjrek, REKL.DENDA=:xdenda, REKL.TOTAL '+
'FROM REKL ,TELPHP WHERE REKL.NOMOR = TELPHP.NoPam ';//and a.tCatat='+cbtglcatateksportexcel.Text+' ';
dm.qryQEksportKeExcel.SQL.Add(SQLKoe);
dm.qryQEksportKeExcel.Parameters.ParamByName('xcatat').Value:=cbtglcatateksportexcel.Text;
dm.qryQEksportKeExcel.Parameters.ParamByName('xjrek').Value := edtrekeksport.Text;
dm.qryQEksportKeExcel.Parameters.ParamByName('xdenda').Value := edJumdenda.Text;
dm.qryQEksportKeExcel.Open;
pnlBawahEksportkeexcel.Caption := 'Jumlah Data Yang akan diEksport = '+IntToStr(dm.qryQEksportKeExcel.RecordCount)+'-Record';
akhir nya run juga..... sory dak jeli lihat nya maklum bos udah ngantuk :)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
- Menjumlah nilai suatu field setiap group pada QReport
by umarbakri in Hal umum tentang Pascal Indonesia more 18 years ago - Bina ISV di UGM 27-29 Nov
by yayaretina in OOT more 17 years ago - BANYOLAN ALA PROGRAMMER
by MrMixer in Tip n Trik Pemrograman more 17 years ago - [Fwd] A funny yet crazy extreme test on Delphi 7 compiler
by deLogic in Enginering more 16 years ago - Function Untuk Liat versi Mssql Atau MySql
by saysansay in MsSQL more 18 years ago - belajar delphi API dimana ya?
by tanpopobebe in Tip n Trik Pemrograman more 18 years ago - [ask] dimana bisa download delphi 5 trial ??
by R960XT in OOT more 17 years ago - Send and Receive RS232 From Skema
by scrafthole in Network, Files, I/O & System more 13 years ago - muncul error dgn komponen UNIDAC
by aandrie77 in Lain-lain more 12 years ago - Mengatur posisi Form dengan 2 monitor
by mimamima in Form Enhancement & Graphical Controls more 13 years ago