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 Kuzmenko To: [email protected] 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 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 parameters with actual values. Look at Execute Statement syntax. But what are you doing is road to hell - trigger, than SP, then parsing a then ES with THAT query. Be sure that performance will go to zero. -- Dmitry Kuzmenko, www.ib-aid.com -- 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]
