Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Alter Table in ElevateDB Manager
Sun, Aug 19 2007 9:38 AMPermanent Link

Chris
Hi,

maybe I'm to stupid or isn't it able to change a not Nullable column to Nullable in the
DB-Mangager? I'm working with the newest version.
Mon, Aug 20 2007 9:47 AMPermanent Link

"Harry de Boer"
Chris,

Try dropping the column (column specs are still visible) check nullable and
add the column.

Regards, Harry

"Chris" <christoph.boenig@onlinehome.de> schreef in bericht
news:FFDAB77D-E6DA-471C-92CF-B22DB8E85A53@news.elevatesoft.com...
> Hi,
>
> maybe I'm to stupid or isn't it able to change a not Nullable column to
Nullable in the
> DB-Mangager? I'm working with the newest version.
>

Mon, Aug 20 2007 4:54 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Chris,

<< maybe I'm to stupid or isn't it able to change a not Nullable column to
Nullable in the DB-Mangager? I'm working with the newest version. >>

To alter any properties other than the default value or description, you
must drop the column and then re-add it with the desired properties.  This
limitation will be removed when 1.06 is released.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Aug 21 2007 2:42 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>To alter any properties other than the default value or description, you
>must drop the column and then re-add it with the desired properties. This
>limitation will be removed when 1.06 is released.

Hurrah!

Does this mean that IF EXISTS is back?

Roy Lambert
Tue, Aug 21 2007 3:29 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Does this mean that IF EXISTS is back? >>

That is certainly a very creative interpretation of that last statement. Smiley

And, unfortunately, no, IF EXISTS will not be back in 1.06.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Aug 22 2007 3:19 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


Just hope - my interpretation was REDEFINE is back and I thought IF EXISTS might have joined it Smiley

Roy Lambert
Wed, Aug 22 2007 6:40 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Just hope - my interpretation was REDEFINE is back and I thought IF
EXISTS might have joined it Smiley>>

It won't be REDEFINE, but a slightly different syntax.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image