Subject Re: [IBO] Re: Problem with sqltype
Author Helmut Steinberger
During my testing, I discovered another new problem.

I have an UDF like this one:

DECLARE EXTERNAL FUNCTION testudf
integer,
cstring(100),
integer,
double precision,
double precision,
date,
integer,
integer,
timestamp,
timestamp
RETURNS INTEGER BY VALUE
ENTRY_POINT 'testudf' MODULE_NAME 'teslib'^

Until now this UDF worked well, but now (maybe after Updateing to
FB1.5) when I use this UDF I get the Error

An error was found in the application program input parameters for the
SQL statement.
Dynamic SQL Error.
SQL error code = -804.
Data type unknown.

When I change the declaration of the UDF to

DECLARE EXTERNAL FUNCTION testudf2
integer,
char(100),
integer,
double precision,
double precision,
date,
integer,
integer,
timestamp,
timestamp
RETURNS INTEGER BY VALUE
ENTRY_POINT 'testudf2' MODULE_NAME 'teslib'^

so change cstring (100) to char (100), it works.

Is cstring no longer supported as UDF parameter?

I know, this is not an IBO issue, but I hope someone here can help me
with this problem.

cu
Helmut