|
Replies:
8
-
Pages:
1
-
Last Post:
Jun 23, 2012 11:27 AM
by: Mauritz
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
Remember re-arranged column order in "data" view after restart?
Posted:
Sep 26, 2011 3:26 AM
|
|
|
Assume opened a database table and went to the "Data" Tab with approx 20 table columns.
First question: When I double click on a table in Object explorer Toad jumps always at first to the "Column" tab.
How can I tell Toad to open by default at first the "Data" tab?
Ok, Now in the "Data" tab I changed some columns visually (I moved e.g. column from pos 15 to the leftmost column).
After disconnect, exit,reconnect, and reopening of the "Data" tab the 15th column is again the 15th column in the "Data" view.
Toad does not remember my previous visual column rearrangments.
Is there a way to fix these re-orderings of columns permanently?
Thank you
Peter
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Sep 26, 2011 11:23 AM
in response to: pstein
|
|
|
You can rearrange the tabs of the right hand side by going into the options and going into the explorer|objects page.
Unfortunately we don't preserve the layout of each individual data tab table.
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Sep 26, 2011 10:59 PM
in response to: Mauritz
|
|
|
Ok, thank you.
But could you include such a feature in the next release?
Is there a official feature application request form?
Peter
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Sep 26, 2011 11:49 PM
in response to: pstein
|
|
|
This will probably not be added because there are a couple of problems with having it.
1. It would have to be saved per table which means it would actually start taking up a lot of space in the case of people with a lot of connections and tables. Worse we will not be able to detect when they are no longer needed in case you move to other servers etc so they would pile up.
2. If the layout of the tables changed (Let's say you add a column) we would still restore the old layout and you wouldn't see the new column until you actually added it in from the column chooser (A feature I doubt most people even know exists).
|
|
|
Posts:
40
Registered:
1/27/11
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Sep 27, 2011 5:56 AM
in response to: pstein
|
|
|
Couldn't you just edit the column positions in the table itself, assuming you have rights to do so?
It shouldn't affect any existing apps unless one is somehow hard-coded to look-up by column order.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Sep 27, 2011 10:22 AM
in response to: Scott M. Sanders
|
|
|
Well, you can do that already but you need to do it using the alter table dialog.
Just keep in mind that this can be an expensive operation since it requires the entire table to be reconstructed because the column order decides how the data is stored in the drive. Doing this just because someone moves a column in a grid is just not going to happen.
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Dec 10, 2011 7:50 AM
in response to: pstein
|
|
|
I know that the columns can be physically re-arranged by an "Alter tabel" command.
But could Toad built this difficult ALTER TABLE command automatically from my visual drag&drop moves?
Assume I moved two columns to other positions. I want to click now a Toad "restructure" menu and Toad should ALTER TABLE the whole table correspondingly.
Could you implement this?
@Mauritz
In reply to your two considerations of 26 Sep let me suggest the following behaviour:
ad 1.: The new layout needs only to be saved when the user want a re-arrangement.
Otherwise nothing needs to be stroed.
I need a re-aarangement only rarely for certain tables.
ad 2.) If the layout of a TABLE changes (which is in reality rare as well) the former layout is obsolet and can be removed immediately.
So Taod only needs to check whether all columns in layout exist in current table as well.
Thats all. Easy to implement.
Given this would you mind to consider this feature?
Thank you
Peter
|
|
|
Posts:
27
Registered:
10/21/08
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Jun 22, 2012 11:59 PM
in response to: Mauritz
|
|
|
Just once more again:
If I re-arrange the columns visually in Toad I would appreciate to have a menu/icon which correspondingly re-arranges the columns physically in database (by an ALTER TABLE command).
Yes, I know it could be time consuming. But thats the decision of the user.
Can this be implemented in the next release?
Thank you
Peter
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Remember re-arranged column order in "data" view after restart?
Posted:
Jun 23, 2012 11:27 AM
in response to: pstein
|
|
|
I honestly doubt it I'm afraid. From my personal experience it is pretty rare to rearrange columns in the table so spending a lot of work to create a really slick interface to do this easily doesn't seem like time well spent.
The interface we have today to change the column order is not that bad and more importantly it makes it very obvious that you are altering the table which can have big ramifications if done to a large table or one that contains a lot of forreign keys etc.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
