Arsip: DBExpress - ExecSQL selalu commit ??

more 17 years ago
mastoto
Yth rekan2 senior,...
Saya ingin meminta bantuan pencerahan terhadap masalah yang sedang saya hadapi.
Saya sedang menggunakan componen DBExpress berupa TSQLQuery dan TSQLConnection untuk koneksi ke Oracle DB.
Aplikasi saya menjalankan insert ke DB menggunakan method TSQLQuery.ExecSQL setelah sebelumnya saya memasukkan sql string ke property TSQLQuery.SQL.Text.
SQ1.SQL.Text := 'INSERT INTO COBA VALUES (1,2,3)';
SQ1.ExecSQL(true);
...
SQ1.SQL.Text := 'INSERT INTO COBA VALUES (4,5,6)';
SQ1.ExecSQL(true);
...
semuanya berjalan lancar dan data masuk ke DB.
hanya masalahnya saya tidk ingin data tersebut langsung masuk, karena dengan metode tersebut seolah-oleh terjadi autocommit. setiapkali ExecSQL jalan selalu Commit di database.
Kemudian saya sempat explorasi menggunakan TSQLConnection.StartTransaction,... TSQLConnection.Commit, TSQLConnection.Rollback ....(sepertinya ini yang saya kehendaki). Tapi ternyata pada saat saya jalankan StartTransaction,... error = "Multiple transactions not enabled"
Adakah cara agar ExecSQL tersebut tidak langsung menyebabkan commit pada database ?... dan pada saatnya saya bisa Commit atau Rollback.
Terima kasih sebelumnya atas bantuan dari rekan2...

more 17 years ago
DelphiExpert
kalau ngga' salah ingat model transaction bisa di set di komponen TSQLConnection, klik kanan "Edit Connection Properties"
parameters yg muncul tergantung driver db-nya, value mungkin sekitar "CommitRetain, TransactionIsolation" dsj

more 17 years ago
mastoto
DelphiExpert ....thanks banget !!
setelah coba buka connection properties,..lalu edit properti MultipleTransaction jadi True...
setelah itu menggunakan StartTransaction,..Commit... berhasil !!
Terima kasih sekali...
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- GIS
by p2bf in Enginering more 17 years ago - tolong di bantu iaa coding join table
by alisiana in MySQL more 13 years ago - konversi *.bmp atau *.jpg
by dinox in Multimedia & Graphic Enhancement more 19 years ago - split string in delphi
by mbahdien in Form Enhancement & Graphical Controls more 17 years ago - runtime error 217
by taruna in Tutorial & Community Project more 17 years ago - Siapa yang gak pelit???
by n3o_cybertech in Tip n Trik Pemrograman more 17 years ago - Task Manager
by saysansay in Tip n Trik Pemrograman more 19 years ago - Kopi Darat Delphi Team
by DelphiExpert in OOT more 15 years ago - find my-template.cnf
by nurez in Bedah Kasus more 17 years ago - perbesaran citra...
by grace in Bedah Kasus more 16 years ago