Arsip: resultset
more 16 years ago
muktaf
saya punya masalah di zeos dan mysql untuk inputan saya menggunakan tabel dan query... paada saya melakukan inputan keluar
error " ezsqlexception with message 'Can not open a Resultset' ".
terimakasih
more 16 years ago
Manz
bisa di tampilkan snapshot code nya ??? biar gak mabok alias lieur ??? :mrgreen:
more 16 years ago
muktaf
ini untuk querynya
procedure lii(ss:string);
begin
form1.zqall.Active:=false;
form1.zqall.SQL.Clear;
form1.zqall.SQL.Add(ss);
form1.zqall.ExecSQL();
form1.zqall.Active:=true;
end;
procedure TForm13.Button7Click(Sender: TObject);
var i : integer;
begin
if messagedlg('Surat Ini Akan di simpan sementara?',
mtConfirmation, [mbYes, mbNo], 0)=mryes then
begin
with form1 do
begin
zngub.Open;
zngub.Append;
zngubhari.Value:=edit18.Text;
zngubtanggal.Value:=edit19.Text;
zngubwaktu.Value:=edit20.Text;
zngubtempat.Value:=edit21.Text;
zngubalamat.Value:=edit22.Text;
zngub.Post;
end;
for i := 1 to jvb.RowCount do
begin
lii('insert into ntr(f1,f2,no) select '+#39+jvb.Cells[0,i]+#39
+','+#39+jvb.Cells[1,i]+#39+', nilai from urutan');
end;
end;
end;
ini codenya... :o [/pas][/php]
more 16 years ago
Manz
saya rasa kalo dah ExecSQL gak perlu Active := true lagi ... coba dihilangkan dan pakai salah satunya...
kalo mo ngambil resultset (kayak di vb ajah nih :mrgreen:) itu pake Active := true, tapi kalo mo tanpa resultset pake ExecSQL ajah ...
hope this help
more 16 years ago
Manz
:mrgreen: you're welcome ... daku namanya manz_delphi ( i nya satu ) :lol: just kidding bro ...
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
- Delphi oh Delphi
by Butani in OOT more 17 years ago - soal keyboard
by teru2bozo in Tip n Trik Pemrograman more 16 years ago - tentang pngimage
by misdie in OOT more 13 years ago - scrollbar jadi bunder
by Cip_rud in Form Enhancement & Graphical Controls more 15 years ago - Pilih Turbo Pascal/Delphi
by -BreWok- in OOT more 17 years ago - insert data pake sql server di delphi.net
by strevo in Delphi.NET more 17 years ago - open dan ngerun file shortcut codingnya gmn ya?
by adidot in Tip n Trik Pemrograman more 16 years ago - buat program seperti msconfig
by tanpopobebe in Tip n Trik Pemrograman more 18 years ago - OUT OF MEMORY
by darsaneit in Tip n Trik Pemrograman more 12 years ago - mau tanya TmxAnyExport
by toing in Tip n Trik Pemrograman more 15 years ago