Tim,

Is it correct that in EDBmngr you cannot change columns in the Alter Table
dialog? I tried to make a CHAR of length 1 to a length of 10 but it says
that only the description and default expression can be changed, or is this
simply not implemented?

Regards, Harry

Also, If I click on a field, change a description and press the OK button
error #700 is thrown (an error was found in the statement at line 2 column
19 (expected SET DROP MOVE DESCRIPTION but instead found DEFAULT)

Harry


"Harry de Boer" <harry@staaf.nl> schreef in bericht
news:7333AD63-AAAA-4753-98C0-4AB0A25A4F6E@news.elevatesoft.com...
> Tim,
>
> Is it correct that in EDBmngr you cannot change columns in the Alter Table
> dialog? I tried to make a CHAR of length 1 to a length of 10 but it says
> that only the description and default expression can be changed, or is
this
> simply not implemented?
>
> Regards, Harry
>
>

Harry,

<< Is it correct that in EDBmngr you cannot change columns in the Alter
Table dialog? I tried to make a CHAR of length 1 to a length of 10 but it
says that only the description and default expression can be changed, or is
this simply not implemented? >>

ALTER TABLE itself doesn't support changing the type of a column right now,
per the SQL standard.

--
Tim Young
Elevate Software
www.elevatesoft.com

Harry,

<< Also, If I click on a field, change a description and press the OK button
error #700 is thrown (an error was found in the statement at line 2 column
19 (expected SET DROP MOVE DESCRIPTION but instead found DEFAULT) >>

Fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

It is not the type of the column, just it's length, or can't you change that
too; that would be a pain.

Regards, Harry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:71CABBA8-B10B-416C-A2EB-24628E728A53@news.elevatesoft.com...
> Harry,
>
> << Is it correct that in EDBmngr you cannot change columns in the Alter
> Table dialog? I tried to make a CHAR of length 1 to a length of 10 but it
> says that only the description and default expression can be changed, or
is
> this simply not implemented? >>
>
> ALTER TABLE itself doesn't support changing the type of a column right
now,
> per the SQL standard.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Tim

>ALTER TABLE itself doesn't support changing the type of a column right now,
>per the SQL standard.

There was an appropriate comment in one of your replies to Ole about the SQL standard which I think applies in this case

Roy Lambert

PS guess what most of your customers will think

I think no one likes this, but...that's a wild guess

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:057DB1E1-0929-482E-B728-71C59A287580@news.elevatesoft.com...
> Tim
>
> >ALTER TABLE itself doesn't support changing the type of a column right
now,
> >per the SQL standard.
>
> There was an appropriate comment in one of your replies to Ole about the
SQL standard which I think applies in this case
>
> Roy Lambert
>
> PS guess what most of your customers will think

Harry


Yeah - you have to wonder which moron inflicted that on the standard - probably the same one who introduced nulls

Roy Lambert

Harry,

<< It is not the type of the column, just it's length, or can't you change
that too; that would be a pain. >>

The two are intrinsically tied together.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< There was an appropriate comment in one of your replies to Ole about the
SQL standard which I think applies in this case >>

Yes, but in this case there's a good reason for it.  Columns can be linked
via RI and other mechanisms that require that essential items like the data
type of the column doesn't change.   However, there are ways around this,
and it is something that will be addressed.  At the very least, the initial
release will allow you to drop and then re-add the column in the same alter,
preserving the column data in the final result.

--
Tim Young
Elevate Software
www.elevatesoft.com