Subject | Problem with UDF |
---|---|
Author | Helmut Steinberger |
Post date | 2003-11-18T07:08:19Z |
Since updated to FB1.5 I have the following 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 use FB1.5 RC7.
Another thing. SInce I updated from FB1.5 RC6 to RC7 the fbguardian
does no longer start and stop the fbserver, when it is started or
stopped.
Until RC when I startet the Guardian, the Server was started too. Now
in RC7 it isn't. Is it a bug or a feature?
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 use FB1.5 RC7.
Another thing. SInce I updated from FB1.5 RC6 to RC7 the fbguardian
does no longer start and stop the fbserver, when it is started or
stopped.
Until RC when I startet the Guardian, the Server was started too. Now
in RC7 it isn't. Is it a bug or a feature?
cu
Helmut