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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>