when the exception fires, it does not continue on to the value assignnment
or the suspend so don;t test for the result value only the true status of
the query
Alan
-----Original Message-----
From: hamacker [mailto:sirhamacker@...]
Sent: Saturday, November 06, 2004 1:30 AM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] how to capture last exception (from stored
procedure) in PHP ?


Hi guys,

I have one store procedure that some part is :
if (:ncount > 0 ) then
begin
EXCEPTION ERROR_SP_GENERIC 'You cant delete existing tickets
dependences';
result_value=0;
suspend;
EXIT;
end

In PHP, the error is OK, but none message.
I try like this :
if ($my_sp->RESULT_VALUE == 0) {
echo "Ops! Error :<br>";
echo ibase_errmsg(); }

But ibase_errmsg() always returning nothing.
There is a solution or workaround for this problem ?

There are some functions in PHP that returning the last warning message?


--
[]'s

Yahoo! Groups Sponsor

Get unlimited calls to

U.S./Canada




----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]