Arsip: autocommit di zeos
more 16 years ago
rey1024
aloww,,,, ada yang pernah pake autocommit di zoes ga?
try
with dm do
begin
ZCon.Connected:=false;
ZCon.Database:='sakila';
ZCon.AutoCommit:=false;
ZCon.Connected:=true;
zcon.StartTransaction;
Zproc.Script.Clear;
zProc.Script.Add('drop procedure re;');
zproc.Execute;
// zcon.Commit; ga aku commit
end;
except on e:exception do
showMessage(e.Message);
end;
padahal ga ak commit, tapi procedure re tetep ilang :shock:
more 16 years ago
DelphiExpert
setahu saya di Zeos pada komponen ZConnection ada property CloseAction atau semacamnya. property ini menunjukkan aksi apa yg dilakukan jika dataset, commands atau connection "tertutup". seingat saya isinya adalah commit, commitretaining & none ... dll...
coba deh ente cek...
more 16 years ago
rey1024
udah bisa, jadinya gini
try
with dm do
begin
ZCon.Connected:=false;
ZCon.Database:=dm.dbSelect;
ZCon.AutoCommit:=false;
ZCon.Connected:=true;
zcon.StartTransaction;
zproc.Delimiter:=';';
Zproc.Script.Clear;
zProc.Script.Add('drop procedure re;');
zProc.Script.Add('drop procedure rexsssss;');
zproc.Execute;
showMessage('berhasil');
zcon.Commit;
end;
except on e:exception do
begin
dm.zcon.Rollback;
showMessage(e.Message);
end;
end;
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
- Save dan Load Gambar ke Database, was update dr artikel
by LuriDarmawan in Multimedia & Graphic Enhancement more 14 years ago - storedProc komponen....????
by nioko in MySQL more 17 years ago - restart program
by lela in Tip n Trik Pemrograman more 17 years ago - connect mysql to php
by cucu in MySQL more 14 years ago - Zeos + PostgreSQL events
by _lmz in OOT more 17 years ago - Da yang tau g?cara koneksi ke dialogic card (apliaksi IVR)
by fafa in Network, Files, I/O & System more 16 years ago - Preview Quick Report
by vikraa in Reporting more 16 years ago - Baca Hardware ID
by nda1312 in Tutorial & Community Project more 17 years ago - style text (bold,italic,underline)
by ianhade in Tip n Trik Pemrograman more 15 years ago - Access MYSQL 5.0
by rusli_chow in Tip n Trik Pemrograman more 16 years ago