| Subject | Re: [firebird-support] Replacement of parameters within a stored procedure |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2012-12-14T20:49:03Z |
Hello, SoftTech!
Saturday, December 15, 2012, 12:36:32 AM, you wrote:
S> I have used Execute Statement in the past. Using it to run SQL
S> statements built on the fly. What my problem is, is taking an existing SQL statement and
S> replacing the Param1 and Param2 with actual values. Again, I cannot build it on the fly.
well, then, I can't understand the problem.
You have statement in the varchar variable, and you can change it
to anything.
And, ES accepts parameters.
Can you explain what you need to get (what you have we see)?
--
Dmitry Kuzmenko, www.ib-aid.com
Saturday, December 15, 2012, 12:36:32 AM, you wrote:
S> I have used Execute Statement in the past. Using it to run SQL
S> statements built on the fly. What my problem is, is taking an existing SQL statement and
S> replacing the Param1 and Param2 with actual values. Again, I cannot build it on the fly.
well, then, I can't understand the problem.
You have statement in the varchar variable, and you can change it
to anything.
And, ES accepts parameters.
Can you explain what you need to get (what you have we see)?
--
Dmitry Kuzmenko, www.ib-aid.com