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
I have used Execute Statement in the past. Using it to run SQL statements
built on the fly. What my problem is, is taking an existing SQL statement and
replacing the Param1 and Param2 with actual values. Again, I cannot build it
on the fly.
- Original Message -
From: Dmitry
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