IBExpert.
Saya juga pernah mengalami masalah execute sp dengan komponen zstoredproc,
setelah dicoba pake komponen ZQuery tidak ada masalah, jadi kira2 kaya gini:
execute procedure spxyz :params1, :params2,...
----- Original Message -----
From: "Ikka Vertika (CBN)" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, December 28, 2004 12:48 AM
Subject: [Delphindo] Error pada ZEOS 6.1.5 Store Procedure
>
>
> 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.
