Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread EDBManager should test for valid defaults
Fri, May 10 2013 9:39 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

EDBManager 2.12b1 ANSI

I'm not sure wether I'd class this as a bug or not so I'm just shoving it here as a suggestion which can be acted on or totally ignored.

The suggestion is that EDBManager should check wether a default is valid when the column is added to the definition rather than when the table is created.

I just created a table in EDBManager. Set up one column as boolean, set the defaul to TRUE. Then added more columns and EDBManager appended DEFAULT TRUE to all the definitions.


At least partly (possibly fully) my fault for not removing the default but since the next column was a VARCHAR perhaps EDBManager should do it for me?


Roy Lambert
Fri, May 10 2013 11:49 AMPermanent Link

Uli Becker

Roy,

I ran into that one quite a lot of times.

So +1 for your suggestion.

Uli
Fri, May 10 2013 4:47 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< The suggestion is that EDBManager should check wether a default is valid
when the column is added to the definition rather than when the table is
created. >>

It can't possibly do so, given the types of expressions that can be used
with default expressions and the bindings to various objects that are
required.  The only time that EDB has the "complete picture" is during the
actual create.

Tim Young
Elevate Software
www.elevatesoft.com
Sat, May 11 2013 3:01 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

><< The suggestion is that EDBManager should check wether a default is valid
>when the column is added to the definition rather than when the table is
>created. >>
>
>It can't possibly do so, given the types of expressions that can be used
>with default expressions and the bindings to various objects that are
>required. The only time that EDB has the "complete picture" is during the
>actual create.

I sort of agree with you, at least it would be difficult to evaluate all cases.

How about a setting - clear defaults between adding columns - as a checkbox on the create/alter table dialog.

I don't have many defaults so I'd even be happy with a blanket clear it out after you click add or alter

Roy
Tue, May 14 2013 11:55 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I don't have many defaults so I'd even be happy with a blanket clear it
out after you click add or alter >>

That's most likely what I'll do.  I hadn't realized that it was causing
issues, but I don't use it that much so I'm a bad judge.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, May 16 2013 5:55 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


><< I don't have many defaults so I'd even be happy with a blanket clear it
>out after you click add or alter >>
>
>That's most likely what I'll do. I hadn't realized that it was causing
>issues, but I don't use it that much so I'm a bad judge.

Hopefully none of us spend too much time creating tables so we're all likely to be bad judges. The most annoying part for me is the staring blankly at the screen trying to figure out what I've done wrong.


Roy Lambert
Tue, May 21 2013 6:29 PMPermanent Link

David Cornelius

Cornelius Concepts

Avatar

This has caught me as well a few times and has both surprised me and annoyed
me.  I think I was mostly surprised that the default was still there for the
next column I added.  Yes, clearing any default value after add/alter a
column would be very nice.

+1

--
David Cornelius
Cornelius Concepts
Image