Subject Re: [firebird-support] Replacement of parameters within a stored procedure
Author Mark Rotteveel
On 14-12-2012 21:49, Dmitry Kuzmenko wrote:
> 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.

EXECUTE STATEMENT only accepts parameters on Firebird 2.5, not on
Firebird 1.5 (which is the version SoftTech is using).

Mark
--
Mark Rotteveel