Temans,
Saya menggunakan Zeos 6.1.5 Stable dengan database Firebird Embedded versi
1.5.1.4481.
Saya mempunyai store prosedur sederhana untuk menghitung jumlah data,
sebagai berikut :
CREATE PROCEDURE SPGUESTBOOKCOUNT
RETURNS (
ITOTDATA INTEGER)
AS
begin
select count(ID) from tbguestbook into :itotdata;
end
^
Sebelum menggunakan SP (dengan komponen TZStoredProc), saat
ZConnection1.Disconnect semuanya lancar. Tetapi, ketika sudah ada
TZStoredProc, keluar error dibawah ini :
project xyz.exe raised exception class EZSQLException with message 'SQL
Error: Invalid statement handle. Error Code: -901. Unsuccessful execution
caused by system error that does not preclude successful execution of
subsequent statement'.
Process stopped. Use Step or Run to continue
Cara saya memanggil TZStoredProc adalah sebagai berikut :
ZStoredProc1.ExecProc;
MOHON bantuan teman-teman sekalian...
Salam,
Ikka
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
