Subject | Why this query doesn't work? |
---|---|
Author | fabiano_bonin |
Post date | 2005-07-11T17:22:29Z |
FB 1.5.2
select
*
from
table1
where
udf_digits(table1.code) like udf_digits(:code)
An error was found in the application program input parameters for the
SQL statement.
Dynamic SQL Error.
SQL error code = -804.
Data type unknown.
The error happens in IBExpert and IBObjects also.
Here is the DDL of the udf:
DECLARE EXTERNAL FUNCTION UDF_DIGITS
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'udf_Digits' MODULE_NAME 'tbudf'
Regards,
Fabiano.
select
*
from
table1
where
udf_digits(table1.code) like udf_digits(:code)
An error was found in the application program input parameters for the
SQL statement.
Dynamic SQL Error.
SQL error code = -804.
Data type unknown.
The error happens in IBExpert and IBObjects also.
Here is the DDL of the udf:
DECLARE EXTERNAL FUNCTION UDF_DIGITS
CSTRING(254)
RETURNS CSTRING(254)
ENTRY_POINT 'udf_Digits' MODULE_NAME 'tbudf'
Regards,
Fabiano.