Subject Re: php/stored procedure error
Author ArnoldGamboa.com
> Ac> ... then, whenever I run this sql command in PHP:
>
> Ac> SELECT * FROM DELETE_PROPERTY WHERE the_property_id = 12
> ^^^
> |||not right
> right is:
> execute procedure DELETE_PROPERTY(12)
>
> --
> Best regards,
> Dmitry Kalugin
> Ukraine, Donetsk

Thanks. This worked.

When I did a PHP/Firebird program some 2 years ago (yeah, long time
ago), I remember executing stored procedures as typical select
statements (just like the one I mentioned above). This approach that
you gave is new to me.

My question is, when do we use the typical select statement and when
do we use the "execute procedure" approach in calling the procedure
from PHP?

Thanks again.

Arnold