Subject | |
---|---|
Author | Dimitris |
Post date | 2002-06-04T18:46:39Z |
Hi all,
i have a custom UDF in FireBird/Win and i want to
call it from my app with IBO.
My UDF takes one parameter as string, and returns Integer.
Cause i am new to this, how can i execute the UDF and
supply the parameter at run-time...?
My UDF is like F_FOO( Param ).. I try to do it with
the IB_DSQL, and in the SQL property i put
'SELECT F_FOO('12qw') FROM RDB$DATABASE'.
And in IB_DSQL.FieldByName('F_FOO').AsInteger i get
the result ...
Now how can i change in run-time the '12qw' with
something :MyParam, and execute it ?
How i declare a Param in the IB_DSQL ?
Dimitris Ioannidis
Thessaloniki, Greece
[Non-text portions of this message have been removed]
i have a custom UDF in FireBird/Win and i want to
call it from my app with IBO.
My UDF takes one parameter as string, and returns Integer.
Cause i am new to this, how can i execute the UDF and
supply the parameter at run-time...?
My UDF is like F_FOO( Param ).. I try to do it with
the IB_DSQL, and in the SQL property i put
'SELECT F_FOO('12qw') FROM RDB$DATABASE'.
And in IB_DSQL.FieldByName('F_FOO').AsInteger i get
the result ...
Now how can i change in run-time the '12qw' with
something :MyParam, and execute it ?
How i declare a Param in the IB_DSQL ?
Dimitris Ioannidis
Thessaloniki, Greece
[Non-text portions of this message have been removed]