On Tuesday, December 28, 2004, 12:48:17 AM, Ikka Vertika (CBN) wrote:
> CREATE PROCEDURE SPGUESTBOOKCOUNT
> RETURNS (
> ITOTDATA INTEGER)
> AS
> begin
> select count(ID) from tbguestbook into :itotdata;
> end
> 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'.
SP tersebut menyertakan nilai kembalian (ITOTDATA), jadi
pemanggilannnya sebaiknya dalam bentuk Query.
SELECT * FROM SPGUESTBOOKCOUNT;
kemudian, stored procedure-nya sendiri harus mensuspend nilai
kembalian yang akan dikirimkan ke client, sehingga:
> begin
> select count(ID) from tbguestbook into :itotdata;
SUSPEND;
> end
--
Salam,
-Jaimy Azle
===========================================================
|| Personal Weblogs: http://jaim.log.web.id ||
|| Personal Delphi Weblogs: http://delphi.log.web.id ||
* Pengantar Pemrograman Database C/S, Delphi dan Firebird
http://delphi.log.web.id/blogs/delphi/000152.html
===========================================================
�Programming is like sex: one mistake and you have to support it
for the rest of your life.�
-- Michael Sinz
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/i7folB/TM
--------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
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:
http://docs.yahoo.com/info/terms/
