Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 10 of 17 total |
EDBmngr (5) alter table flaws? |
Thu, Jan 11 2007 7:14 AM | Permanent Link |
"Harry de Boer" | 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 |
Thu, Jan 11 2007 7:21 AM | Permanent Link |
"Harry de Boer" | 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 > > |
Thu, Jan 11 2007 8:32 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Jan 11 2007 8:43 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Jan 11 2007 9:00 AM | Permanent Link |
"Harry de Boer" | 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 > > |
Thu, Jan 11 2007 9:06 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Jan 11 2007 10:12 AM | Permanent Link |
"Harry de Boer" | 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 |
Thu, Jan 11 2007 11:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
Yeah - you have to wonder which moron inflicted that on the standard - probably the same one who introduced nulls Roy Lambert |
Thu, Jan 11 2007 7:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Jan 11 2007 8:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |