| Subject | Re: [firebird-support] Replacement of parameters within a stored procedure |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2012-12-14T20:14:18Z |
Hello, SoftTech!
Friday, December 14, 2012, 10:01:51 PM, you wrote:
S> I cannot do what I need to do on the client side as you suggest.
S> This must be handled on the server using firebird. A trigger is used to call a stored
S> procedure and then inside this stored procedure I need to replace parameters with actual values.
Look at Execute Statement syntax.
But what are you doing is road to hell - trigger, than SP, then
parsing a then ES with THAT query. Be sure that performance will go to zero.
--
Dmitry Kuzmenko, www.ib-aid.com
Friday, December 14, 2012, 10:01:51 PM, you wrote:
S> I cannot do what I need to do on the client side as you suggest.
S> This must be handled on the server using firebird. A trigger is used to call a stored
S> procedure and then inside this stored procedure I need to replace parameters with actual values.
Look at Execute Statement syntax.
But what are you doing is road to hell - trigger, than SP, then
parsing a then ES with THAT query. Be sure that performance will go to zero.
--
Dmitry Kuzmenko, www.ib-aid.com