Subject Re: Procedures/Firebird
Author Ruslan
Äìèòðèé, ñïàñèáî âàì áîëüøîå çà òàêîå ïîäðîáíîå ðàçúÿñíåíèå è çà âñå
âàøè îòâåòû íà ìîé âîïðîñû :) ß ïîïðîáóþ ñäåëàòü òàê êàê âû ñêàçàëè.
Ñïàñèáî!

--- In firebird-php@yahoogroups.com, Dmitry Kalugin <dskalugin@r...>
wrote:
> Hello, Ruslan!
>
> R>So I want to execute from php a statement like this:
> R> execute procedurename('in_param','in_param').
> R> Can somebody tell me how to do this ?
>
> Åñëè ïðîöåäóðà ñîçäàíà íà îñíîâå
> "FOR SELECT ... DO SUSPEND...",
> òî âûçûâàòü åå íàäî êàê "Select * from proc(p1,p2)"
>
> À åñëè íà îñíîâå DELETE, INSERT, UPDATE,
> òî ñîîòâåòñòâåííî "execute proc(p1,p2)"
> ñ ïîñëåäóþùèì ÷òåíèåì ïàðàìåòðîâ
>
> If procedure is created on the basis of "FOR SELECT ...
> DO SUSPEND...", to cause it it is necessary as "Select
> * from proc(p1,p2)"
>
> And if on the basis of DELETE, INSERT, UPDATE,
> according to "execute proc(p1,p2)"
> with the subsequent reading of parameters
>
>
>
> --
> Best regards,
> Dmitry Kalugin
> Ukraine, Donetsk