Hello,

I am using TIB_DSQL to update a table.
In designtime I setup the component to execute: EXECUTE PROCEDURE
SP_UPDATE_PROJECT(:i_x) and give parameter i_x a value.
When I execute the component and I commit I can see the value appear in the
respective column. Great!

Now when I try to do this in runtime it is failing. What is causing this?

I am using Firebird 1.5 R7 and IBO 4.3.Aa

Kind regards,
Ronan van Riet


with IB_DSQL_SP_UPDATE_PROJECT do begin
if not prepared then prepare;

ParamByName('i_X').Value := '12122';

Execute;
end;

My SP looks like

CREATE PROCEDURE SP_UPDATE_PROJECT(
I_X INTEGER)
AS
begin
UPDATE E_PROJECT
SET X = :i_x;
end