| Subject | :PARAM inside function call not working! |
|---|---|
| Author | Robert Osowiecki |
| Post date | 2005-06-07T18:09:17Z |
I put an IBOQuery with SQL set to:
SELECT * from ARTICLEDATA
where (my_udf_function(ar_code, :AR_CODE)=0)
whenever I use ParamByName("AR_CODE") i get error code -804: data type
unknown.
I get this error even when I do ParamByName("AR_CODE")->DataType=ftString!
Setting DataType and InputType to AR_CODE param in IDE does'nt help...
What's wrong?
R.
SELECT * from ARTICLEDATA
where (my_udf_function(ar_code, :AR_CODE)=0)
whenever I use ParamByName("AR_CODE") i get error code -804: data type
unknown.
I get this error even when I do ParamByName("AR_CODE")->DataType=ftString!
Setting DataType and InputType to AR_CODE param in IDE does'nt help...
What's wrong?
R.