# FILE OPEN problem with Toad 10.1 **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 30, 2010, 10:12am UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385 "2010-03-30T10:12:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 10:12am UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/1 "2010-03-30T10:12:32Z")
When you open a file in the editor it will open it in a tab and remember the extension. If I try to open another file it will only show files with that same extension. I would like it to always show all .SQL, .PKB, .PKS, .FNC and .PRC. I have not found an option for that. You do have categories for that. There is the PL/SQL category. But once you chose a file it uses that extension rather than the category extensions. ---
**Author:** ![ianjackson](https://avatars.discourse-cdn.com/v4/letter/i/eb9ed0/32.png) [@ianjackson](https://forums.toadworld.com/u/ianjackson)\ **Post date:** [March 30, 2010, 10:44am UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/2 "2010-03-30T10:44:38Z")
Glad you brought that up Erwin … this bugs me too. ian ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 30, 2010, 1:17pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/3 "2010-03-30T13:17:41Z")
I am not sure that I follow. I launch the Open File dialog and select a .SQL file. The file opens in a new tab. I click the Open File button again and in the dialog the filter dropdown is set to PLSQL, the filename edit is blank, and the file browser listview shows all files matching the filter. I see .SQL and .PKB files in my test. What exactly are you seeing? Michael ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:33pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/4 "2010-03-30T13:33:52Z")
Here is my scenario ![image001.png](https://global.discourse-cdn.com/quest/original/2X/b/bf2af73c5aafcf016f724e7bf237bb1a0154c7e0.png) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:33pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/5 "2010-03-30T13:33:52Z")
Here is my scenario ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:33pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/6 "2010-03-30T13:33:52Z")
Here is my scenario ![image002.png](https://global.discourse-cdn.com/quest/original/1X/46a869c9a431ea2ab37ebd9fff936747a613459b.png) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [March 30, 2010, 1:37pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/7 "2010-03-30T13:37:22Z")
So instead of it remembering the type of file you opened previously you want it to always stay at the PLSQL\* level? ![image002.png](https://global.discourse-cdn.com/quest/original/1X/46a869c9a431ea2ab37ebd9fff936747a613459b.png) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [March 30, 2010, 1:37pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/8 "2010-03-30T13:37:22Z")
So instead of it remembering the type of file you opened previously you want it to always stay at the PLSQL\* level? ![image001.png](https://global.discourse-cdn.com/quest/original/2X/b/bf2af73c5aafcf016f724e7bf237bb1a0154c7e0.png) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:39pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/9 "2010-03-30T13:39:51Z")
YES. Because I will be opening SQL, PKB, PKS, files. I don’t want to start a separate window for each type of object. If nothing else, PKB and PKS should be always be shown together. ![image001.png](https://global.discourse-cdn.com/quest/original/2X/b/bf2af73c5aafcf016f724e7bf237bb1a0154c7e0.png) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:39pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/10 "2010-03-30T13:39:51Z")
YES. Because I will be opening SQL, PKB, PKS, files. I don’t want to start a separate window for each type of object. If nothing else, PKB and PKS should be always be shown together. ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:39pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/11 "2010-03-30T13:39:51Z")
YES. Because I will be opening SQL, PKB, PKS, files. I don’t want to start a separate window for each type of object. If nothing else, PKB and PKS should be always be shown together. ![image002.png](https://global.discourse-cdn.com/quest/original/1X/46a869c9a431ea2ab37ebd9fff936747a613459b.png) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [March 30, 2010, 1:41pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/12 "2010-03-30T13:41:12Z")
PKB and PKS make sense to have together, but you can always just change the file type drop down as needed, right? ![image002.png](https://global.discourse-cdn.com/quest/original/1X/46a869c9a431ea2ab37ebd9fff936747a613459b.png) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [March 30, 2010, 1:41pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/13 "2010-03-30T13:41:12Z")
PKB and PKS make sense to have together, but you can always just change the file type drop down as needed, right? ![image001.png](https://global.discourse-cdn.com/quest/original/2X/b/bf2af73c5aafcf016f724e7bf237bb1a0154c7e0.png) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:50pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/14 "2010-03-30T13:50:36Z")
Yes. But that requires extra effort. Now that we have much wider monitors I would have no problem with two OPEN FILE icons. One could be the current OPEN FILE (meaning open same as previous) The other could be OPEN PLSQL This way no OPTION to change. Just two choices. I can even live with having to do a CUSTOMIZE MENU to get and drag that second OPEN PLSQL icon to the icon bar. ![image001.png](https://global.discourse-cdn.com/quest/original/2X/b/bf2af73c5aafcf016f724e7bf237bb1a0154c7e0.png) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:50pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/15 "2010-03-30T13:50:36Z")
Yes. But that requires extra effort. Now that we have much wider monitors I would have no problem with two OPEN FILE icons. One could be the current OPEN FILE (meaning open same as previous) The other could be OPEN PLSQL This way no OPTION to change. Just two choices. I can even live with having to do a CUSTOMIZE MENU to get and drag that second OPEN PLSQL icon to the icon bar. ![image001.jpeg](https://global.discourse-cdn.com/quest/original/1X/e8288ef7bf69daaab6959f752b25ca292478b911.jpeg) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [March 30, 2010, 1:50pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/16 "2010-03-30T13:50:36Z")
Yes. But that requires extra effort. Now that we have much wider monitors I would have no problem with two OPEN FILE icons. One could be the current OPEN FILE (meaning open same as previous) The other could be OPEN PLSQL This way no OPTION to change. Just two choices. I can even live with having to do a CUSTOMIZE MENU to get and drag that second OPEN PLSQL icon to the icon bar. ![image002.png](https://global.discourse-cdn.com/quest/original/1X/46a869c9a431ea2ab37ebd9fff936747a613459b.png) ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 30, 2010, 2:08pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/17 "2010-03-30T14:08:25Z")
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. I’ll 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) can’t be reordered and the predefined filters can’t 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 can’t 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 ![image003.jpeg](https://global.discourse-cdn.com/quest/original/2X/a/a6a61a8e147c6feb9a24bb343ec8a33a36191009.jpeg) ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 30, 2010, 2:08pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/18 "2010-03-30T14:08:25Z")
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. I’ll 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) can’t be reordered and the predefined filters can’t 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 can’t 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 ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/22dd4976866d7109af84cd4849ee3a188145e041.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [March 30, 2010, 2:36pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/19 "2010-03-30T14:36:35Z")
Can you perhaps improve the process at step #1? Have an option “Remember last-opened file type”, checked by default, such that when NOT checked you simply don’t set the last-used-file-extension (and clear it if it was set earlier in the session). What would Windows Common Dialogs then use for a filter? Nate Schroeder IT Commercial Technical Services - Data Management Team Monsanto Company 800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167 314-694-2592 ![image003.jpeg](https://global.discourse-cdn.com/quest/original/2X/a/a6a61a8e147c6feb9a24bb343ec8a33a36191009.jpeg) ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [March 30, 2010, 2:36pm UTC](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385/20 "2010-03-30T14:36:35Z")
Can you perhaps improve the process at step #1? Have an option “Remember last-opened file type”, checked by default, such that when NOT checked you simply don’t set the last-used-file-extension (and clear it if it was set earlier in the session). What would Windows Common Dialogs then use for a filter? Nate Schroeder IT Commercial Technical Services - Data Management Team Monsanto Company 800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167 314-694-2592 ![image004.jpeg](https://global.discourse-cdn.com/quest/original/2X/2/22dd4976866d7109af84cd4849ee3a188145e041.jpeg) [Next page](https://forums.toadworld.com/t/file-open-problem-with-toad-10-1/9385.md?page=2)