Toad World® Forums

Formatting Options Query

I’ve moved to a new job and didn’t copy the “FmtPlus.opt” format options file when I left the old job.

On my old TOAD, if I did CTRL + SHIFT + F, the following SQL would look like this:

[pre]SELECT DISTINCT fat.application_name
, fdfv.title
, fdfcv.descriptive_flexfield_name
FROM apps.fnd_descriptive_flexs_vl fdfv
, apps.fnd_descr_flex_contexts_vl fdfcv
, applsys.fnd_application_tl fat
WHERE fdfv.application_id = fdfcv.application_id
AND fdfv.descriptive_flexfield_name = fdfcv.descriptive_flexfield_name
AND fdfv.application_id = fat.application_id
AND fat.application_name = ‘Receivables’
AND fdfv.title = ‘Address’;[/pre]

But on the new install, it comes out as:

[pre]SELECT DISTINCT fat.application_name
, fdfv.title
, fdfcv.descriptive_flexfield_name
FROM apps.fnd_descriptive_flexs_vl fdfv
, apps.fnd_descr_flex_contexts_vl fdfcv
, applsys.fnd_application_tl fat
WHERE fdfv.application_id = fdfcv.application_id
AND fdfv.descriptive_flexfield_name = fdfcv.descriptive_flexfield_name
AND fdfv.application_id = fat.application_id
AND fat.application_name = ‘Receivables’
AND fdfv.title = ‘Address’;[/pre]

I’ve changed lots of settings in the formatting options in TOAD, but can’t work out how to get the SQL to align as per my old version.

Any advice on how to get the formatter to generate output like in the first example would be much appreciated.

Thanks

Hi there,
We here on the Development team monitor our Yahoo groups daily, and we hope to see you there. (This forum’s content is no longer mirrored there, so we hope you will join that group, where Developers and expert users share tips and answers.)

YAHOO GROUP:
http://tech.groups.yahoo.com/group/toad/

If needed, our award-winning Support team can help (phone and link below).
SUPPORT:
https://support.quest.com/Default.aspx

Support can be emailed at:
Support@Quest.com

Support can be reached by phone at:
1.800.306.9329 or 949.754.8000

Thanks for using Toad!
Donna