Hi,

How does one set a default value for a BYTE field? I thought this should work

ALTER TABLE "table" ALTER COLUMN "ByteColumn" AS BYTE(1) DEFAULT X'01' NOT NULL

however it gives with Error #700 An error was found in the default column expression at line 1 and column 1 (Expected NULL, Byte, GUID, or VarByte expression but instead found '01')

none of this variations work
...AS BYTE(1) DEFAULT 1 NOT NULL
...AS BYTE DEFAULT 1 NOT NULL

What I actually wabted was to set the default when I created the table but also nothing worked, so then I tried altering and now I'm stuck...

Thanks
Lucian

Lucian
>
> How does one set a default value for a BYTE field? I thought this should work
>
> ALTER TABLE "table" ALTER COLUMN "ByteColumn" AS BYTE(1) DEFAULT X'01' NOT NULL
>

How about

ALTER TABLE "table" ALTER COLUMN "ByteColumn" AS BYTE(1) DEFAULT cast(X'01' as byte) NOT NULL

John

Thanks a lot, that works
Lucian

Lucian,

<< How does one set a default value for a BYTE field? I thought this should
work

ALTER TABLE "table" ALTER COLUMN "ByteColumn" AS BYTE(1) DEFAULT X'01' NOT
NULL

however it gives with Error #700 An error was found in the default column
expression at line 1 and column 1 (Expected NULL, Byte, GUID, or VarByte
expression but instead found '01') >>

This is a bug, and is fixed for the new build coming out this week.  John's
workaround is correct.

--
Tim Young
Elevate Software
www.elevatesoft.com

>This is a bug, and is fixed for the new build coming out this week.

Cool!
Lucian