Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 7 of 7 total |
Another suggestion |
Fri, Jan 26 2007 9:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Can the default column type be made user selectable - I'll probably never user CHAR but will very frequently use VARCHAR? Roy Lambert ps The sooner altering a column definition allows you to actually alter it the better |
Fri, Jan 26 2007 1:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Can the default column type be made user selectable - I'll probably never user CHAR but will very frequently use VARCHAR? >> Sure, it can. I'll add to the list of minor enhancements for the EDB Manager. << The sooner altering a column definition allows you to actually alter it the better >> That's the standard, so it will stay for now. If you want to change a column's data type, then drop it and re-add it with the new type. It will pick up the old data now as of B6. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jan 27 2007 3:48 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>That's the standard, so it will stay for now. If you want to change a >column's data type, then drop it and re-add it with the new type. It will >pick up the old data now as of B6. I noticed that at least its a bit less painful Roy Lambert |
Sat, Jan 27 2007 10:49 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I noticed that at least its a bit less painful >> Yeah, especially since the EDB Manager keeps the old column's information, so all you have to do is Drop, modify the column info, and then Add and Move as required. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jan 27 2007 11:42 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Yeah, especially since the EDB Manager keeps the old column's information, >so all you have to do is Drop, modify the column info, and then Add and Move >as required. I'm guessing that's something we have to do for ourselves in an app? If so thanks for the code to crib from Roy Lambert |
Sat, Jan 27 2007 1:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I'm guessing that's something we have to do for ourselves in an app? If so thanks for the code to crib from >> Yes, in your application you'll need to do the same. However, I would expect that you would know what the new column definition should look like for the ADD COLUMN statement along with where you want to move it. Keep in mind also that the ADD COLUMN statement allows for an AT position at the end: http://www.elevatesoft.com/edb1sql_alter_table.htm -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Jan 28 2007 6:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Yes, in your application you'll need to do the same. However, I would >expect that you would know what the new column definition should look like >for the ADD COLUMN statement along with where you want to move it. Keep in >mind also that the ADD COLUMN statement allows for an AT position at the >end: Good, now all I need is to be able to figure out how to count columns - I was never able to get it right first time with DBISAM and I doubt I'll be any better with ElevateDB Roy Lambert |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |