My complaint has been that I don’t use a filter and yet when I come back
in, it defaults to showing only the files with the same extension as the one I
opened. So if I opened a package body, it doesn’t go to the PL/SQL
filter but the Package Body filter. And I forget to check and scroll all the
way over to my file that starts with a W, only to discover that I have to change
my filter settings and then scroll over again to find my file.
I guess I just don’t have enough different file types in the same
directory for it to even be of benefit to filter at all. And if I just opened
the Package body, chances are that I want to open the spec next. J
On the other hand, after all this time, I have kinda gotten used to this
behavior. It’s just that for me, the filters are not a shortcut but
cause extra steps which is counter-TOAD-like. . .
My complaint has been that I don’t use a filter and yet when I come back
in, it defaults to showing only the files with the same extension as the one I
opened. So if I opened a package body, it doesn’t go to the PL/SQL
filter but the Package Body filter. And I forget to check and scroll all the
way over to my file that starts with a W, only to discover that I have to change
my filter settings and then scroll over again to find my file.
I guess I just don’t have enough different file types in the same
directory for it to even be of benefit to filter at all. And if I just opened
the Package body, chances are that I want to open the spec next. J
On the other hand, after all this time, I have kinda gotten used to this
behavior. It’s just that for me, the filters are not a shortcut but
cause extra steps which is counter-TOAD-like. . .
Another way to “fix” it would be to ship with a predefined filter
list,
but give you complete control over reordering or even removing those filters
Since opinions are like … err … hairs, all mammals have one
Here’s mine:
I would vote for the option of having the list that is called
“predefined” removed. Have only an “optionally defined”
list. This, of course, can come with a few common defaults as set up by Quest.
Then the individual has full control of modifying the lists within Toad to suit
their own personal preferences and circumstances.
This solution would fall nicely into the “powerful, yet simple”
concept as well as allow the user the flexibility Toad has come to be known for.
Of course… that’s assuming – big assumption on my part –
that MS file functionality would allow it
oracle wont see it unless you assign a name to the file/directory resource and
grant Oracle user access to that file/directory resource e.g.
Martin Gainty
Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
Vertraulichkeitanmerkung/Note de déni et de confidentialité
Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy
jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának
készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és
semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek
könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet
ezen üzenet tartalma miatt.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
oracle wont see it unless you assign a name to the file/directory resource and
grant Oracle user access to that file/directory resource e.g.
Martin Gainty
Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
Vertraulichkeitanmerkung/Note de déni et de confidentialité
Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy
jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának
készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és
semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek
könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet
ezen üzenet tartalma miatt.
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
A little late but here is what I have done to get all files to display in the
open/save dialogs. Go into Options | Files | General and set the first line to
be ".log;.sql;.prc;.fnc;.pks;.pkb;.pls;.trg;.vw;.tps;.tpb;.txt;."
with the name "!all files".
I also added a few other extended file types that I wanted to filter against at
the top.
William
At 03-30-2010 12:08, you wrote:
Ok, this has come up before. It has been quite some time since investigating
it, but I seem to remember a couple of key points and roadblocks that
prevent fixing it at this time. Ill list them out even though you know
most of this already from observation.
We set the last used file extension, FNC in your case
We unfortunately (and probably incorrectly) have multiple filters that
include the FNC extension
Windows Common Dialogs search through the filters, in order, until one
is found that contains the extension and uses that filter
Toad has a predefined set of filters for the common dialogs and PLSQL is
one of many and happens to appear below some of the other PLSQL object
filters
The list of filters (Optionsà Files à General) cant be reordered and
the predefined filters cant be deleted
We have no way of obtaining the last used filter index from the common
dialog, just extension of the last opened file
One proposition from back in the day was to retain the last used filter and
not last used extension, but we cant do this because of 6 above. This
would be ideal, but as far as I know still not possible.
Another way to fix it would be to ship with a predefined filter list,
but give you complete control over reordering or even removing those filters
with a restore defaults option so that you can nuke all of the individual
PLSQL object type filters or at least push PLSQL to the top.
For now you can do the following which should work. Edit the filters for the
PLSQL object types that are listed above PLSQL (function, java, java source,
package, and package body) so that those filters look for a bogus extension,
.aaa for instance. This should cause your case below to always go to the
PLSQL filter, but means that the modified filters are now useless.
Michael
A little late but here is what I have done to get all files to display in the
open/save dialogs. Go into Options | Files | General and set the first line to
be ".log;.sql;.prc;.fnc;.pks;.pkb;.pls;.trg;.vw;.tps;.tpb;.txt;."
with the name "!all files".
I also added a few other extended file types that I wanted to filter against at
the top.
William
At 03-30-2010 12:08, you wrote:
Ok, this has come up before. It has been quite some time since investigating
it, but I seem to remember a couple of key points and roadblocks that
prevent fixing it at this time. Ill list them out even though you know
most of this already from observation.
We set the last used file extension, FNC in your case
We unfortunately (and probably incorrectly) have multiple filters that
include the FNC extension
Windows Common Dialogs search through the filters, in order, until one
is found that contains the extension and uses that filter
Toad has a predefined set of filters for the common dialogs and PLSQL is
one of many and happens to appear below some of the other PLSQL object
filters
The list of filters (Optionsà Files à General) cant be reordered and
the predefined filters cant be deleted
We have no way of obtaining the last used filter index from the common
dialog, just extension of the last opened file
One proposition from back in the day was to retain the last used filter and
not last used extension, but we cant do this because of 6 above. This
would be ideal, but as far as I know still not possible.
Another way to fix it would be to ship with a predefined filter list,
but give you complete control over reordering or even removing those filters
with a restore defaults option so that you can nuke all of the individual
PLSQL object type filters or at least push PLSQL to the top.
For now you can do the following which should work. Edit the filters for the
PLSQL object types that are listed above PLSQL (function, java, java source,
package, and package body) so that those filters look for a bogus extension,
.aaa for instance. This should cause your case below to always go to the
PLSQL filter, but means that the modified filters are now useless.
Michael
A little late but here is what I have done to get all files to display in the
open/save dialogs. Go into Options | Files | General and set the first line to
be ".log;.sql;.prc;.fnc;.pks;.pkb;.pls;.trg;.vw;.tps;.tpb;.txt;."
with the name "!all files".
I also added a few other extended file types that I wanted to filter against at
the top.
William
At 03-30-2010 12:08, you wrote:
Ok, this has come up before. It has been quite some time since investigating
it, but I seem to remember a couple of key points and roadblocks that
prevent fixing it at this time. Ill list them out even though you know
most of this already from observation.
We set the last used file extension, FNC in your case
We unfortunately (and probably incorrectly) have multiple filters that
include the FNC extension
Windows Common Dialogs search through the filters, in order, until one
is found that contains the extension and uses that filter
Toad has a predefined set of filters for the common dialogs and PLSQL is
one of many and happens to appear below some of the other PLSQL object
filters
The list of filters (Optionsà Files à General) cant be reordered and
the predefined filters cant be deleted
We have no way of obtaining the last used filter index from the common
dialog, just extension of the last opened file
One proposition from back in the day was to retain the last used filter and
not last used extension, but we cant do this because of 6 above. This
would be ideal, but as far as I know still not possible.
Another way to fix it would be to ship with a predefined filter list,
but give you complete control over reordering or even removing those filters
with a restore defaults option so that you can nuke all of the individual
PLSQL object type filters or at least push PLSQL to the top.
For now you can do the following which should work. Edit the filters for the
PLSQL object types that are listed above PLSQL (function, java, java source,
package, and package body) so that those filters look for a bogus extension,
.aaa for instance. This should cause your case below to always go to the
PLSQL filter, but means that the modified filters are now useless.
Michael
