Subject | Re: [IBO] Re: Problem with sqltype |
---|---|
Author | Helmut Steinberger |
Post date | 2003-11-17T08:59:06Z |
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
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