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
] 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
On 15-12-2012 13:48, SoftTech wrote:
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?
The biggest breaking changes were between 1.5 and 2.0, so I guess
Firebird v1.5
A SQL statement is stored in a table.
Inside of a stored procedure I need to retrieve this SQL statement, replace
:Param1 and :Param2 with actual values then execute it. I will of course
know the value, just don't know how to replace the :Param1 and 2 with the
value.
SELECT
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
Kuzmenko
To: firebird-support@yahoogroups.com
Sent: Friday, December 14, 2012 2:14 PM
Subject: {Disarmed} Re: [firebird-support] Replacement of parameters within a
stored procedure
Hello, SoftTech!
Friday, December 14, 2012, 10:01:51 PM, you wrote:
S I cannot do what I need
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