Subject | Re: [firebird-php] Procedures/Firebird |
---|---|
Author | Dmitry Kalugin |
Post date | 2005-03-12T08:07:46Z |
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
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