Still more info:

I unistalled FB 1.5.3 Classic and installed FB 1.5.1 Classic and had the
same problem. I uninstalled FB 1.5.1 Classic and installed FB 1.5.1 which I
usually use and had no problem.

Bill Meaney

>
> More info:
>
> I copied (Windows) the db from the FB 1.5.3 Classic server to a
> FB 1.5.1 SS
> server and this update worked fine.
>
> Could the problem be the client? The client I'm using is from FB 1.5.1.
>
> Suppose you have a client that needs to use databases that are on
> different
> FB versions. Which client should be used? Does it matter?
>
> Thanks,
> Bill Meaney
>
> >
> > 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
> >
> >
> >
>