Subject | Input parameters |
---|---|
Author | bogdan |
Post date | 2008-10-06T08:11:05Z |
Hi
I wonder if there was a change from version 1.5.x to 2.0.x.
In 1.5.x i could modify input parameters inside stored procedure.
In 2.0.x i can still modify input parameters, but the change has no effect.
Example:
Procedure xxx (
Imaterial_id integer (null)
Icode integer (123)
)
As
begin
select material_id from material where code = :icode
into :imaterial_id;
/* imaterial_id should be 554, but it is still Null */
end
The procedure worked ok until i recompile it in 2.0.x.
regards, Bogdan
[Non-text portions of this message have been removed]
I wonder if there was a change from version 1.5.x to 2.0.x.
In 1.5.x i could modify input parameters inside stored procedure.
In 2.0.x i can still modify input parameters, but the change has no effect.
Example:
Procedure xxx (
Imaterial_id integer (null)
Icode integer (123)
)
As
begin
select material_id from material where code = :icode
into :imaterial_id;
/* imaterial_id should be 554, but it is still Null */
end
The procedure worked ok until i recompile it in 2.0.x.
regards, Bogdan
[Non-text portions of this message have been removed]