OK.
But I put only an example, my problem is that ibase_errmsg() allways
returning empty string and I need to capture the last exception error.

I can correct a prior example, try :
if (:ncount > 0 ) then
begin
result_value=0;
suspend;
EXCEPTION ERROR_SP_GENERIC 'You cant delete existing tickets
dependences';
EXIT;
end

and the same problem, I can capture in PHP the message "You cant delete
existing tickets dependences';

This message are displayed only if "error_reporting = E_ALL &
~E_NOTICE" in php.ini and ibase_errmsg() allways returning empty string.

My PHP is php4-4.3.6 / Conectiva Linux 10 (kernel 2.6.5)



[]'s


Alan McDonald wrote:

> 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]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>