On Fri, 14 Dec 2012 08:47:59 +1300, Robert martin wrote:
> Hi
>
> One of our clients has a machine where intermittently the system crawls
> to almost stop. Launching programs (like paint) takes about 2 minutes
> to open. The CPU usage is low (1-3 %) but HDD usage shows at between 97
> - 100%
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 DIS
W dniu 2012-12-14 17:57, SoftTech pisze:
>
> 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
I cannot do what I need to do on the client side as you suggest. This must be
handled on the server using firebird. A trigger is used to call a stored
procedure and then inside this stored procedure I need to replace parameters
with actual values.
Thanks,
Mike
- Original Message -
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 Kuzm
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 c