# formatter question **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [December 15, 2009, 2:11pm UTC](https://forums.toadworld.com/t/formatter-question/9064 "2009-12-15T14:11:15Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 15, 2009, 2:11pm UTC](https://forums.toadworld.com/t/formatter-question/9064/1 "2009-12-15T14:11:15Z")
I have the same package source from 2 software versions saved in a folder on my computer and open in the editor so I can compare them. I have my toad options set to ‘format when opening a file’, but when I compare the files they show many differences because the are not formatted the same. I clicked the ‘format code’ icon on both to format them. They both appear to format ok, but one formats and one does not. I tried changing the code and formatting again…same result. No errors, one of them just doesn’t format even though it says it does. There is really not much difference between the files. What would cause one of them not to format and how can I work around this? ---
**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\ **Post date:** [December 16, 2009, 3:41pm UTC](https://forums.toadworld.com/t/formatter-question/9064/2 "2009-12-16T15:41:55Z")
Wendy, After you sent me the files I saw that the “bad” file contains variable declarations with %TYPE. You’re using QP5 version 5.139. Unfortunately this version has issues with %TYPE and %ROWTYPE which sometimes will cause parts of the text not to get formatted. Please try to use 5.142, found the latest Toad drops if I’m not mistaken. This formats your file most fine. Sorry about that. Thanks, Andre ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 17, 2009, 2:39pm UTC](https://forums.toadworld.com/t/formatter-question/9064/3 "2009-12-17T14:39:15Z")
Hi Andre, Thanks! I can find just that file on the website and download it? When I do Help | Check for updates it says I have the most recent version of Toad. Wendy Andre Vergison wrote: ``` Wendy, After you sent me the files I saw that the “bad” file contains variable declarations with %TYPE. You’re using QP5 version 5.139. Unfortunately this version has issues with %TYPE and %ROWTYPE which sometimes will cause parts of the text not to get formatted. Please try to use 5.142, found the latest Toad drops if I’m not mistaken. This formats your file most fine. Sorry about that. Thanks, Andre ``` ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [December 17, 2009, 3:13pm UTC](https://forums.toadworld.com/t/formatter-question/9064/4 "2009-12-17T15:13:43Z")
Hi Wendy, The version Andre is speaking of is in the Toad beta. If you’re interested in trying it out, go here: [http://www.toadfororacle.com/beta.jspa](http://www.toadfororacle.com/beta.jspa) ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 18, 2009, 8:25am UTC](https://forums.toadworld.com/t/formatter-question/9064/5 "2009-12-18T08:25:48Z")
Hi Brad, I’m guessing that means I can’t just download the new QP5 version…? I’ll have to install the toad beta and then possibly move the new QP5 version to my commercial install? Wendy Brad Boddicker wrote: ``` Hi Wendy, The version Andre is speaking of is in the Toad beta. If you’re interested in trying it out, go here: http://www.toadforo racle.com/ beta.jspa ``` ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [December 18, 2009, 9:11am UTC](https://forums.toadworld.com/t/formatter-question/9064/6 "2009-12-18T09:11:57Z")
There is one annoyance in TOAD 10 concerning the subject. While in version 9 i was able to hit F4 on the table and then CTRL-C the column i needed to use, it now copies the entire row in the clipboard. The same problem exists if i need just an index or a trigger name. For example, this is what gets copied to the clipboard for the index: PLAIN CDREFENTITY\_UQ Y YES 1 CD\_ENTITY\_NAME Asc 1 CLIENT\_ADMIN while i want only CDREFENTITY\_UQ Is there an option that controls what is being copied? Many thanks. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [December 18, 2009, 9:17am UTC](https://forums.toadworld.com/t/formatter-question/9064/7 "2009-12-18T09:17:42Z")
Rt-click, turn off row select. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [December 18, 2009, 10:01am UTC](https://forums.toadworld.com/t/formatter-question/9064/8 "2009-12-18T10:01:40Z")
Thank you, John. I think “Row Select Off” should a default behavior. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [December 18, 2009, 10:07am UTC](https://forums.toadworld.com/t/formatter-question/9064/9 "2009-12-18T10:07:26Z")
Correct, but be aware that commercial Toad 10 has not been certified with any other QP5.dll version other than the one it ships with. It will most likely work fine, but if you have any problems, be sure you hold on to the original version. ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 18, 2009, 12:41pm UTC](https://forums.toadworld.com/t/formatter-question/9064/10 "2009-12-18T12:41:42Z")
Thanks! Brad Boddicker wrote: ``` Correct, but be aware that commercial Toad 10 has not been certified with any other QP5.dll version other than the one it ships with. It will most likely work fine, but if you have any problems, be sure you hold on to the original version. ``` ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [December 21, 2009, 2:22am UTC](https://forums.toadworld.com/t/formatter-question/9064/11 "2009-12-21T02:22:09Z")
---
**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:** [December 21, 2009, 7:28am UTC](https://forums.toadworld.com/t/formatter-question/9064/12 "2009-12-21T07:28:47Z")
Available in the beta only ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 21, 2009, 8:16am UTC](https://forums.toadworld.com/t/formatter-question/9064/13 "2009-12-21T08:16:30Z")
Hi Jeff, I tried downloading the lastest beta and installing it, but the QP5 version is 5.136.908.31019, Andre says it should be 5.142? Wendy Jeff Smith wrote: Available in the beta only ---
**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:** [December 21, 2009, 8:31am UTC](https://forums.toadworld.com/t/formatter-question/9064/14 "2009-12-21T08:31:28Z")
My copy has the .142 version. You downloaded the beta, and then also ran the updater in the 2nd link on the beta page? ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 21, 2009, 8:48am UTC](https://forums.toadworld.com/t/formatter-question/9064/15 "2009-12-21T08:48:14Z")
No, I didn’t run the updater, I’ll try that… Jeff Smith wrote: My copy has the .142 version. You downloaded the beta, and then also ran the updater in the 2nd link on the beta page? ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [December 21, 2009, 9:00am UTC](https://forums.toadworld.com/t/formatter-question/9064/16 "2009-12-21T09:00:04Z")
The beta has two downloads (as Jeff points out and that many people don’t understand). The installer is done once at the beginning of the beta cycle - and will lay down the very first beta and all the files. The second download is updated regularly - like once or twice a week - and is just a zip file you unzip into the beta install directory and contains just the files that changed … ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 21, 2009, 11:10am UTC](https://forums.toadworld.com/t/formatter-question/9064/17 "2009-12-21T11:10:13Z")
I installed the Beta, but can't get it to run because it says I don't have the most recent version of Toad installed, but when I 'check for updates', it says I do have the most recent version. My license says I have a 'Trial' version...could that be the issue with runnning the beta? So, I tried copying the QP5.dll to my commercial install directory and doing a source compare, but the 2 versions of the package are still not being formatted the same. Could it be because one version of the database is UTF-8 and the other is not? Bert Scalzo wrote: > Message from: bscalzo > > The beta has two downloads (as Jeff points out and that many people > don't understand). The installer is done once at the beginning of the > beta cycle - and will lay down the very first beta and all the files. > The second download is updated regularly - like once or twice a week - > and is just a zip file you unzip into the beta install directory and > contains just the files that changed .... > > * * * > > Historical Messages > > Author: Bert Scalzo > Date: Mon Dec 21 07:00:04 PST 2009 > The beta has two downloads (as Jeff points out and that many people > don't understand). The installer is done once at the beginning of the > beta cycle - and will lay down the very first beta and all the files. > The second download is updated regularly - like once or twice a week - > and is just a zip file you unzip into the beta install directory and > contains just the files that changed .... > \_\_ > > Author: Jeff Smith > Date: Mon Dec 21 06:31:28 PST 2009 > My copy has the .142 version. You downloaded the beta, and then also > ran the updater in the 2nd link on the beta page? > \_\_ > > Author: wpenfold > Date: Mon Dec 21 06:16:30 PST 2009 > Hi Jeff, I tried downloading the lastest beta and installing it, but > the QP5 version is 5.136.908.31019, Andre says it should be 5.142? > Wendy Jeff Smith wrote: Available in the beta only > \_\_ > > Author: Jeff Smith > Date: Mon Dec 21 05:28:47 PST 2009 > Available in the beta only > \_\_ > > Author: Rob Zijlstra > Date: Mon Dec 21 00:22:09 PST 2009 > > \_\_ > > Author: wpenfold > Date: Fri Dec 18 10:41:42 PST 2009 > Thanks! Brad Boddicker wrote: Correct, but be aware that commercial > Toad 10 has not been certified with any other QP5.dll version other > than the one it ships with. It will most likely work fine, but if you > have any problems, be sure you hold on to the original version. > \_\_ > > Author: Brad Boddicker > Date: Fri Dec 18 08:07:26 PST 2009 > Correct, but be aware that commercial Toad 10 has not been certified > with any other QP5.dll version other than the one it ships with. It > will most likely work fine, but if you have any problems, be sure you > hold on to the original version. > \_\_ > > Author: [George.Meltser@aigfpc.com](mailto:George.Meltser@aigfpc.com) > Date: Fri Dec 18 08:01:40 PST 2009 > Thank you, John. I think "Row Select Off" should a default behavior. > \_\_ > > Author: John Dorlon > Date: Fri Dec 18 07:17:42 PST 2009 > Rt-click, turn off row select. > \_\_ > > Author: [George.Meltser@aigfpc.com](mailto:George.Meltser@aigfpc.com) > Date: Fri Dec 18 07:11:57 PST 2009 > There is one annoyance in TOAD 10 concerning the subject. While in > version 9 i was able to hit F4 on the table and then CTRL-C the column > i needed to use, it now copies the entire row in the clipboard. The > same problem exists if i need just an index or a trigger name. For > example, this is what gets copied to the clipboard for the index: > PLAIN CDREFENTITY\_UQ Y YES 1 CD\_ENTITY\_NAME Asc 1 CLIENT\_ADMIN while i > want only CDREFENTITY\_UQ Is there an option that controls what is > being copied? Many thanks. > \_\_ > > Author: wpenfold > Date: Fri Dec 18 06:25:48 PST 2009 > Hi Brad, I'm guessing that means I can't just download the new QP5 > version...? I'll have to install the toad beta and then possibly move > the new QP5 version to my commercial install? Wendy Brad Boddicker > wrote: Hi Wendy, The version Andre is speaking of is in the Toad > beta. If you?re interested in trying it out, go here: > [http://www.toadforo](http://www.toadforo) [racle.com/](http://racle.com/) beta.jspa > \_\_ > > Author: Brad Boddicker > Date: Thu Dec 17 13:13:43 PST 2009 > Hi Wendy, The version Andre is speaking of is in the Toad beta. If > you?re interested in trying it out, go here: > [http://www.toadfororacle.com/beta.jspa](http://www.toadfororacle.com/beta.jspa) > \_\_ > > Author: wpenfold > Date: Thu Dec 17 12:39:15 PST 2009 > Hi Andre, Thanks! I can find just that file on the website and > download it? When I do Help | Check for updates it says I have the > most recent version of Toad. Wendy Andre Vergison wrote: Wendy, > After you sent me the files I saw that the ?bad? file contains > variable declarations with %TYPE. You?re using QP5 version 5.139. > Unfortunately this version has issues with %TYPE and %ROWTYPE which > sometimes will cause parts of the text not to get formatted. Please > try to use 5.142, found the latest Toad drops if I?m not mistaken. > This formats your file most fine. Sorry about that. Thanks, Andre > \_\_ > > Author: Andre Vergison > Date: Wed Dec 16 13:41:55 PST 2009 > Wendy, After you sent me the files I saw that the ?bad? file contains > variable declarations with %TYPE. You?re using QP5 version 5.139. > Unfortunately this version has issues with %TYPE and %ROWTYPE which > sometimes will cause parts of the text not to get formatted. Please > try to use 5.142, found the latest Toad drops if I?m not mistaken. > This formats your file most fine. Sorry about that. Thanks, Andre > \_\_ > > Author: wpenfold > Date: Tue Dec 15 12:11:15 PST 2009 > I have the same package source from 2 software versions saved in a > folder on my computer and open in the editor so I can compare them. I > have my toad options set to 'format when opening a file', but when I > compare the files they show many differences because the are not > formatted the same. I clicked the 'format code' icon on both to format > them. They both appear to format ok, but one formats and one does not. > I tried changing the code and formatting again...same result. No > errors, one of them just doesn't format even though it says it does. > There is really not much difference between the files. What would > cause one of them not to format and how can I work around this? > \_\_ > > * * * I installed the Beta, but can't get it to run because it says I don't have the most recent version of Toad installed, but when I 'check for updates', it says I do have the most recent version. My license says I have a 'Trial' version...could that be the issue with runnning the beta? So, I tried copying the QP5.dll to my commercial install directory and doing a source compare, but the 2 versions of the package are still not being formatted the same. Could it be because one version of the database is UTF-8 and the other is not? Bert Scalzo wrote: ``` Message from: bscalzo ``` The beta has two downloads (as Jeff points out and that many people don't understand). The installer is done once at the beginning of the beta cycle - and will lay down the very first beta and all the files. The second download is updated regularly - like once or twice a week - and is just a zip file you unzip into the beta install directory and contains just the files that changed .... ``` _____________________ __________________ Historical Messages ``` Author: Bert Scalzo Date: Mon Dec 21 07:00:04 PST 2009 The beta has two downloads (as Jeff points out and that many people don't understand). The installer is done once at the beginning of the beta cycle - and will lay down the very first beta and all the files. The second download is updated regularly - like once or twice a week - and is just a zip file you unzip into the beta install directory and contains just the files that changed .... \_\_ ``` Author: Jeff Smith Date: Mon Dec 21 06:31:28 PST 2009 My copy has the .142 version. You downloaded the beta, and then also ran the updater in the 2nd link on the beta page? __ Author: wpenfold Date: Mon Dec 21 06:16:30 PST 2009 Hi Jeff, I tried downloading the lastest beta and installing it, but the QP5 version is 5.136.908.31019, Andre says it should be 5.142? Wendy Jeff Smith wrote: Available in the beta only __ Author: Jeff Smith Date: Mon Dec 21 05:28:47 PST 2009 Available in the beta only __ Author: Rob Zijlstra Date: Mon Dec 21 00:22:09 PST 2009 __ Author: wpenfold Date: Fri Dec 18 10:41:42 PST 2009 Thanks! Brad Boddicker wrote: Correct, but be aware that commercial Toad 10 has not been certified with any other QP5.dll version other than the one it ships with. It will most likely work fine, but if you have any problems, be sure you hold on to the original version. __ Author: Brad Boddicker Date: Fri Dec 18 08:07:26 PST 2009 Correct, but be aware that commercial Toad 10 has not been certified with any other QP5.dll version other than the one it ships with. It will most likely work fine, but if you have any problems, be sure you hold on to the original version. __ Author: George.Meltser@ aigfpc.com Date: Fri Dec 18 08:01:40 PST 2009 Thank you, John. I think "Row Select Off" should a default behavior. __ Author: John Dorlon Date: Fri Dec 18 07:17:42 PST 2009 Rt-click, turn off row select. __ Author: George.Meltser@ aigfpc.com Date: Fri Dec 18 07:11:57 PST 2009 There is one annoyance in TOAD 10 concerning the subject. While in version 9 i was able to hit F4 on the table and then CTRL-C the column i needed to use, it now copies the entire row in the clipboard. The same problem exists if i need just an index or a trigger name. For example, this is what gets copied to the clipboard for the index: PLAIN CDREFENTITY_ UQ Y YES 1 CD_ENTITY_NAME Asc 1 CLIENT_ADMIN while i want only CDREFENTITY_ UQ Is there an option that controls what is being copied? Many thanks. __ Author: wpenfold Date: Fri Dec 18 06:25:48 PST 2009 Hi Brad, I'm guessing that means I can't just download the new QP5 version...? I'll have to install the toad beta and then possibly move the new QP5 version to my commercial install? Wendy Brad Boddicker wrote: Hi Wendy, The version Andre is speaking of is in the Toad beta. If you?re interested in trying it out, go here: http://www.toadforo racle.com/ beta.jspa __ Author: Brad Boddicker Date: Thu Dec 17 13:13:43 PST 2009 Hi Wendy, The version Andre is speaking of is in the Toad beta. If you?re interested in trying it out, go here: http://www.toadforo racle.com/ beta.jspa __ Author: wpenfold Date: Thu Dec 17 12:39:15 PST 2009 Hi Andre, Thanks! I can find just that file on the website and download it? When I do Help | Check for updates it says I have the most recent version of Toad. Wendy Andre Vergison wrote: Wendy, After you sent me the files I saw that the ?bad? file contains variable declarations with %TYPE. You?re using QP5 version 5.139. Unfortunately this version has issues with %TYPE and %ROWTYPE which sometimes will cause parts of the text not to get formatted. Please try to use 5.142, found the latest Toad drops if I?m not mistaken. This formats your file most fine. Sorry about that. Thanks, Andre __ Author: Andre Vergison Date: Wed Dec 16 13:41:55 PST 2009 Wendy, After you sent me the files I saw that the ?bad? file contains variable declarations with %TYPE. You?re using QP5 version 5.139. Unfortunately this version has issues with %TYPE and %ROWTYPE which sometimes will cause parts of the text not to get formatted. Please try to use 5.142, found the latest Toad drops if I?m not mistaken. This formats your file most fine. Sorry about that. Thanks, Andre __ Author: wpenfold Date: Tue Dec 15 12:11:15 PST 2009 I have the same package source from 2 software versions saved in a folder on my computer and open in the editor so I can compare them. I have my toad options set to 'format when opening a file', but when I compare the files they show many differences because the are not formatted the same. I clicked the 'format code' icon on both to format them. They both appear to format ok, but one formats and one does not. I tried changing the code and formatting again...same result. No errors, one of them just doesn't format even though it says it does. There is really not much difference between the files. What would cause one of them not to format and how can I work around this? __ _____________________ __________________ ``` ![moz-screenshot-138.jpeg](https://global.discourse-cdn.com/quest/original/2X/b/b22502943bad7a33d2201540bfc5ca514af6238c.jpeg) ---
**Author:** ![wpenfoldithaca.edu](https://avatars.discourse-cdn.com/v4/letter/w/35a633/32.png) [@wpenfoldithaca.edu](https://forums.toadworld.com/u/wpenfoldithaca.edu)\ **Post date:** [December 21, 2009, 11:10am UTC](https://forums.toadworld.com/t/formatter-question/9064/18 "2009-12-21T11:10:13Z")
I installed the Beta, but can't get it to run because it says I don't have the most recent version of Toad installed, but when I 'check for updates', it says I do have the most recent version. My license says I have a 'Trial' version...could that be the issue with runnning the beta? So, I tried copying the QP5.dll to my commercial install directory and doing a source compare, but the 2 versions of the package are still not being formatted the same. Could it be because one version of the database is UTF-8 and the other is not? Bert Scalzo wrote: > Message from: bscalzo > > The beta has two downloads (as Jeff points out and that many people > don't understand). The installer is done once at the beginning of the > beta cycle - and will lay down the very first beta and all the files. > The second download is updated regularly - like once or twice a week - > and is just a zip file you unzip into the beta install directory and > contains just the files that changed .... > > * * * > > Historical Messages > > Author: Bert Scalzo > Date: Mon Dec 21 07:00:04 PST 2009 > The beta has two downloads (as Jeff points out and that many people > don't understand). The installer is done once at the beginning of the > beta cycle - and will lay down the very first beta and all the files. > The second download is updated regularly - like once or twice a week - > and is just a zip file you unzip into the beta install directory and > contains just the files that changed .... > \_\_ > > Author: Jeff Smith > Date: Mon Dec 21 06:31:28 PST 2009 > My copy has the .142 version. You downloaded the beta, and then also > ran the updater in the 2nd link on the beta page? > \_\_ > > Author: wpenfold > Date: Mon Dec 21 06:16:30 PST 2009 > Hi Jeff, I tried downloading the lastest beta and installing it, but > the QP5 version is 5.136.908.31019, Andre says it should be 5.142? > Wendy Jeff Smith wrote: Available in the beta only > \_\_ > > Author: Jeff Smith > Date: Mon Dec 21 05:28:47 PST 2009 > Available in the beta only > \_\_ > > Author: Rob Zijlstra > Date: Mon Dec 21 00:22:09 PST 2009 > > \_\_ > > Author: wpenfold > Date: Fri Dec 18 10:41:42 PST 2009 > Thanks! Brad Boddicker wrote: Correct, but be aware that commercial > Toad 10 has not been certified with any other QP5.dll version other > than the one it ships with. It will most likely work fine, but if you > have any problems, be sure you hold on to the original version. > \_\_ > > Author: Brad Boddicker > Date: Fri Dec 18 08:07:26 PST 2009 > Correct, but be aware that commercial Toad 10 has not been certified > with any other QP5.dll version other than the one it ships with. It > will most likely work fine, but if you have any problems, be sure you > hold on to the original version. > \_\_ > > Author: [George.Meltser@aigfpc.com](mailto:George.Meltser@aigfpc.com) > Date: Fri Dec 18 08:01:40 PST 2009 > Thank you, John. I think "Row Select Off" should a default behavior. > \_\_ > > Author: John Dorlon > Date: Fri Dec 18 07:17:42 PST 2009 > Rt-click, turn off row select. > \_\_ > > Author: [George.Meltser@aigfpc.com](mailto:George.Meltser@aigfpc.com) > Date: Fri Dec 18 07:11:57 PST 2009 > There is one annoyance in TOAD 10 concerning the subject. While in > version 9 i was able to hit F4 on the table and then CTRL-C the column > i needed to use, it now copies the entire row in the clipboard. The > same problem exists if i need just an index or a trigger name. For > example, this is what gets copied to the clipboard for the index: > PLAIN CDREFENTITY\_UQ Y YES 1 CD\_ENTITY\_NAME Asc 1 CLIENT\_ADMIN while i > want only CDREFENTITY\_UQ Is there an option that controls what is > being copied? Many thanks. > \_\_ > > Author: wpenfold > Date: Fri Dec 18 06:25:48 PST 2009 > Hi Brad, I'm guessing that means I can't just download the new QP5 > version...? I'll have to install the toad beta and then possibly move > the new QP5 version to my commercial install? Wendy Brad Boddicker > wrote: Hi Wendy, The version Andre is speaking of is in the Toad > beta. If you?re interested in trying it out, go here: > [http://www.toadforo](http://www.toadforo) [racle.com/](http://racle.com/) beta.jspa > \_\_ > > Author: Brad Boddicker > Date: Thu Dec 17 13:13:43 PST 2009 > Hi Wendy, The version Andre is speaking of is in the Toad beta. If > you?re interested in trying it out, go here: > [http://www.toadfororacle.com/beta.jspa](http://www.toadfororacle.com/beta.jspa) > \_\_ > > Author: wpenfold > Date: Thu Dec 17 12:39:15 PST 2009 > Hi Andre, Thanks! I can find just that file on the website and > download it? When I do Help | Check for updates it says I have the > most recent version of Toad. Wendy Andre Vergison wrote: Wendy, > After you sent me the files I saw that the ?bad? file contains > variable declarations with %TYPE. You?re using QP5 version 5.139. > Unfortunately this version has issues with %TYPE and %ROWTYPE which > sometimes will cause parts of the text not to get formatted. Please > try to use 5.142, found the latest Toad drops if I?m not mistaken. > This formats your file most fine. Sorry about that. Thanks, Andre > \_\_ > > Author: Andre Vergison > Date: Wed Dec 16 13:41:55 PST 2009 > Wendy, After you sent me the files I saw that the ?bad? file contains > variable declarations with %TYPE. You?re using QP5 version 5.139. > Unfortunately this version has issues with %TYPE and %ROWTYPE which > sometimes will cause parts of the text not to get formatted. Please > try to use 5.142, found the latest Toad drops if I?m not mistaken. > This formats your file most fine. Sorry about that. Thanks, Andre > \_\_ > > Author: wpenfold > Date: Tue Dec 15 12:11:15 PST 2009 > I have the same package source from 2 software versions saved in a > folder on my computer and open in the editor so I can compare them. I > have my toad options set to 'format when opening a file', but when I > compare the files they show many differences because the are not > formatted the same. I clicked the 'format code' icon on both to format > them. They both appear to format ok, but one formats and one does not. > I tried changing the code and formatting again...same result. No > errors, one of them just doesn't format even though it says it does. > There is really not much difference between the files. What would > cause one of them not to format and how can I work around this? > \_\_ > > * * * I installed the Beta, but can't get it to run because it says I don't have the most recent version of Toad installed, but when I 'check for updates', it says I do have the most recent version. My license says I have a 'Trial' version...could that be the issue with runnning the beta? So, I tried copying the QP5.dll to my commercial install directory and doing a source compare, but the 2 versions of the package are still not being formatted the same. Could it be because one version of the database is UTF-8 and the other is not? Bert Scalzo wrote: ``` Message from: bscalzo ``` The beta has two downloads (as Jeff points out and that many people don't understand). The installer is done once at the beginning of the beta cycle - and will lay down the very first beta and all the files. The second download is updated regularly - like once or twice a week - and is just a zip file you unzip into the beta install directory and contains just the files that changed .... ``` _____________________ __________________ Historical Messages ``` Author: Bert Scalzo Date: Mon Dec 21 07:00:04 PST 2009 The beta has two downloads (as Jeff points out and that many people don't understand). The installer is done once at the beginning of the beta cycle - and will lay down the very first beta and all the files. The second download is updated regularly - like once or twice a week - and is just a zip file you unzip into the beta install directory and contains just the files that changed .... \_\_ ``` Author: Jeff Smith Date: Mon Dec 21 06:31:28 PST 2009 My copy has the .142 version. You downloaded the beta, and then also ran the updater in the 2nd link on the beta page? __ Author: wpenfold Date: Mon Dec 21 06:16:30 PST 2009 Hi Jeff, I tried downloading the lastest beta and installing it, but the QP5 version is 5.136.908.31019, Andre says it should be 5.142? Wendy Jeff Smith wrote: Available in the beta only __ Author: Jeff Smith Date: Mon Dec 21 05:28:47 PST 2009 Available in the beta only __ Author: Rob Zijlstra Date: Mon Dec 21 00:22:09 PST 2009 __ Author: wpenfold Date: Fri Dec 18 10:41:42 PST 2009 Thanks! Brad Boddicker wrote: Correct, but be aware that commercial Toad 10 has not been certified with any other QP5.dll version other than the one it ships with. It will most likely work fine, but if you have any problems, be sure you hold on to the original version. __ Author: Brad Boddicker Date: Fri Dec 18 08:07:26 PST 2009 Correct, but be aware that commercial Toad 10 has not been certified with any other QP5.dll version other than the one it ships with. It will most likely work fine, but if you have any problems, be sure you hold on to the original version. __ Author: George.Meltser@ aigfpc.com Date: Fri Dec 18 08:01:40 PST 2009 Thank you, John. I think "Row Select Off" should a default behavior. __ Author: John Dorlon Date: Fri Dec 18 07:17:42 PST 2009 Rt-click, turn off row select. __ Author: George.Meltser@ aigfpc.com Date: Fri Dec 18 07:11:57 PST 2009 There is one annoyance in TOAD 10 concerning the subject. While in version 9 i was able to hit F4 on the table and then CTRL-C the column i needed to use, it now copies the entire row in the clipboard. The same problem exists if i need just an index or a trigger name. For example, this is what gets copied to the clipboard for the index: PLAIN CDREFENTITY_ UQ Y YES 1 CD_ENTITY_NAME Asc 1 CLIENT_ADMIN while i want only CDREFENTITY_ UQ Is there an option that controls what is being copied? Many thanks. __ Author: wpenfold Date: Fri Dec 18 06:25:48 PST 2009 Hi Brad, I'm guessing that means I can't just download the new QP5 version...? I'll have to install the toad beta and then possibly move the new QP5 version to my commercial install? Wendy Brad Boddicker wrote: Hi Wendy, The version Andre is speaking of is in the Toad beta. If you?re interested in trying it out, go here: http://www.toadforo racle.com/ beta.jspa __ Author: Brad Boddicker Date: Thu Dec 17 13:13:43 PST 2009 Hi Wendy, The version Andre is speaking of is in the Toad beta. If you?re interested in trying it out, go here: http://www.toadforo racle.com/ beta.jspa __ Author: wpenfold Date: Thu Dec 17 12:39:15 PST 2009 Hi Andre, Thanks! I can find just that file on the website and download it? When I do Help | Check for updates it says I have the most recent version of Toad. Wendy Andre Vergison wrote: Wendy, After you sent me the files I saw that the ?bad? file contains variable declarations with %TYPE. You?re using QP5 version 5.139. Unfortunately this version has issues with %TYPE and %ROWTYPE which sometimes will cause parts of the text not to get formatted. Please try to use 5.142, found the latest Toad drops if I?m not mistaken. This formats your file most fine. Sorry about that. Thanks, Andre __ Author: Andre Vergison Date: Wed Dec 16 13:41:55 PST 2009 Wendy, After you sent me the files I saw that the ?bad? file contains variable declarations with %TYPE. You?re using QP5 version 5.139. Unfortunately this version has issues with %TYPE and %ROWTYPE which sometimes will cause parts of the text not to get formatted. Please try to use 5.142, found the latest Toad drops if I?m not mistaken. This formats your file most fine. Sorry about that. Thanks, Andre __ Author: wpenfold Date: Tue Dec 15 12:11:15 PST 2009 I have the same package source from 2 software versions saved in a folder on my computer and open in the editor so I can compare them. I have my toad options set to 'format when opening a file', but when I compare the files they show many differences because the are not formatted the same. I clicked the 'format code' icon on both to format them. They both appear to format ok, but one formats and one does not. I tried changing the code and formatting again...same result. No errors, one of them just doesn't format even though it says it does. There is really not much difference between the files. What would cause one of them not to format and how can I work around this? __ _____________________ __________________ ``` ![moz-screenshot-137.jpeg](https://global.discourse-cdn.com/quest/original/2X/0/0b1fe0364caa6523b225666ced67e5e0a7efe47b.jpeg) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [December 21, 2009, 11:35am UTC](https://forums.toadworld.com/t/formatter-question/9064/19 "2009-12-21T11:35:47Z")
You have to have the latest GA version. Trial versions don’t count for beta program ![moz-screenshot-138.jpeg](https://global.discourse-cdn.com/quest/original/2X/b/b22502943bad7a33d2201540bfc5ca514af6238c.jpeg) ---
**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\ **Post date:** [December 21, 2009, 11:35am UTC](https://forums.toadworld.com/t/formatter-question/9064/20 "2009-12-21T11:35:47Z")
You have to have the latest GA version. Trial versions don’t count for beta program ![moz-screenshot-137.jpeg](https://global.discourse-cdn.com/quest/original/2X/0/0b1fe0364caa6523b225666ced67e5e0a7efe47b.jpeg) [Next page](https://forums.toadworld.com/t/formatter-question/9064.md?page=2)