Subject Re: {Disarmed} Re: [firebird-support] Replacement of parameters within a stored procedure
Author SoftTech
OK, I'm sure I've seen this in the list before... Where can I find documentation on moving from v1.5 to v2.5?

----- Original Message -----
From: Mark Rotteveel
To: firebird-support@yahoogroups.com
Sent: Saturday, December 15, 2012 4:23 AM
Subject: {Disarmed} Re: [firebird-support] Replacement of parameters within a stored procedure



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



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[Non-text portions of this message have been removed]