Subject | FB 1.5.3 return data type not supported |
---|---|
Author | Bill Meaney |
Post date | 2006-02-02T16:25:08Z |
I have a DB running on FB1.5.1 SS dialect 1 that works fine. I moved it to
a brand new server with FB1.5.3 Classic dialect 1. (This is the first time
I've used Classic.) The restore ran without error.
The relavent data is defined as:
CREATE DOMAIN uVCSml AS
VARCHAR(16)
CREATE DOMAIN uVCMed AS
VARCHAR(32)
CREATE TABLE SUSR (
UsrId INTEGER NOT NULL,
UsrNam uVCSml NOT NULL,
FllNam UVCMed NOT NULL
)
When I attempt to:
UPDATE sUsr
SET UsrNam = 'MYNAME'
WHERE UsrId = 23
or
UPDATE sUsr
SET FllNam = 'My Name'
WHERE UsrId = 23
I get the following message:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
return data type not supported.
This same statement works fine on the 1.5.1 SS version.
Any ideas?
Bill Meaney
a brand new server with FB1.5.3 Classic dialect 1. (This is the first time
I've used Classic.) The restore ran without error.
The relavent data is defined as:
CREATE DOMAIN uVCSml AS
VARCHAR(16)
CREATE DOMAIN uVCMed AS
VARCHAR(32)
CREATE TABLE SUSR (
UsrId INTEGER NOT NULL,
UsrNam uVCSml NOT NULL,
FllNam UVCMed NOT NULL
)
When I attempt to:
UPDATE sUsr
SET UsrNam = 'MYNAME'
WHERE UsrId = 23
or
UPDATE sUsr
SET FllNam = 'My Name'
WHERE UsrId = 23
I get the following message:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
return data type not supported.
This same statement works fine on the 1.5.1 SS version.
Any ideas?
Bill Meaney