Subject | Re: [firebird-php] SPs Docs |
---|---|
Author | Milan Babuskov |
Post date | 2004-11-17T21:59:05Z |
Nigel Weeks wrote:
ibase_query("execute procedure some_nonselectable_sp(params)");
If it is selectable do:
ibase_query("select * from some_selectable_sp(params)");
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org
>>It just can't be done (at least in current FB versions). YouSure.
>>need either
>>selectable stored procedure or a select to return *anything*.
>>Selectable
>>SP is out of the question. To insert records you need DML-SP which
>>cannot be selected from or joined with a table, so you can't go with
>>select either.
>
> Does anyone know if you can execute an 'Execute procedure' from PHP?
ibase_query("execute procedure some_nonselectable_sp(params)");
If it is selectable do:
ibase_query("select * from some_selectable_sp(params)");
--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org