Subject | Is anything changed in UDF handling in FB 2.0 RC3? |
---|---|
Author | Salvatore Besso |
Post date | 2006-07-27T17:22:15Z |
hello all,
is something changed in UDF handling in FB 2.0 RC3? I'm using Super Server
running as a service under Windows XP. Suddenly I get a total block using
IBExpert personal to execute the script. So I have also tried to execute it
using ISQL, and I get this result:
C:\SBSoftware\DB\WinAtgest>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect winatgest.fdb user sysdba password masterkey;
Database: winatgest.fdb, User: sysdba
SQL> select * from members;
SQL> input soci.sql; <------------------------
Statement failed, SQLCODE = -901 <------------------------
connection lost to database <------------------------
The problem happens at the first INSERT containing a call to two UDF's that
worked just fine with FB 1.5.3:
INSERT INTO MEMBERS
(PREFIX, UNIT, ....., NOTES)
VALUES(1, 3, ..... F_STRTOBLOB('Casa 1234567' || F_CRLF() || 'Uff.
1234567' || F_CRLF() || 'Mob. 1234567' || F_CRLF() || 'Mob. 1234567' ||
F_CRLF() || '1234567' || F_CRLF() || '50000' || F_CRLF() || '25 euro
2006'));
The two UDF's are F_STRTOBLOB and F_CRLF. The NOTES field is of type
BLOB_TEXT defined as:
CREATE DOMAIN BLOB_TEXT
AS BLOB
SUB_TYPE TEXT /* Sub type 1 */
SEGMENT SIZE 80
DEFAULT NULL;
As I already said, this statement (and other similar) were perfectly
inserted with FB 1.5.3. The UDF's are in a library made by me with Delphi 7
and the DLL is present in the UDF folder. The two UDF's are correctly
declared in the database creation script.
Any hints?
Regards
Salvatore
is something changed in UDF handling in FB 2.0 RC3? I'm using Super Server
running as a service under Windows XP. Suddenly I get a total block using
IBExpert personal to execute the script. So I have also tried to execute it
using ISQL, and I get this result:
C:\SBSoftware\DB\WinAtgest>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect winatgest.fdb user sysdba password masterkey;
Database: winatgest.fdb, User: sysdba
SQL> select * from members;
SQL> input soci.sql; <------------------------
Statement failed, SQLCODE = -901 <------------------------
connection lost to database <------------------------
The problem happens at the first INSERT containing a call to two UDF's that
worked just fine with FB 1.5.3:
INSERT INTO MEMBERS
(PREFIX, UNIT, ....., NOTES)
VALUES(1, 3, ..... F_STRTOBLOB('Casa 1234567' || F_CRLF() || 'Uff.
1234567' || F_CRLF() || 'Mob. 1234567' || F_CRLF() || 'Mob. 1234567' ||
F_CRLF() || '1234567' || F_CRLF() || '50000' || F_CRLF() || '25 euro
2006'));
The two UDF's are F_STRTOBLOB and F_CRLF. The NOTES field is of type
BLOB_TEXT defined as:
CREATE DOMAIN BLOB_TEXT
AS BLOB
SUB_TYPE TEXT /* Sub type 1 */
SEGMENT SIZE 80
DEFAULT NULL;
As I already said, this statement (and other similar) were perfectly
inserted with FB 1.5.3. The UDF's are in a library made by me with Delphi 7
and the DLL is present in the UDF folder. The two UDF's are correctly
declared in the database creation script.
Any hints?
Regards
Salvatore