Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 7 of 7 total |
EDBManager should test for valid defaults |
Fri, May 10 2013 9:39 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
David Cornelius Cornelius Concepts | 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 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |