Toad World® Forums

Comma formatting query


#1

Hi - I am using Toad 9.1.0.62

Working on an old SQL file formatted in someone else’s TOAD who has now left, I see this bit of SQL:

AND mug.group_name IN
(
‘COMMENT REQUEST - CCC’,
‘AP RESOLUTION PO PURCHASING’,
‘All Users’,
‘INVOICE APPROVER - CCC’,
‘MVC WEB INQUIRY CCC’
)

When I format the same SQL in my TOAD, it looks like this:

AND mug.group_name IN
(‘COMMENT REQUEST - CCC’
, ‘AP RESOLUTION PO PURCHASING’, ‘All Users’
, ‘INVOICE APPROVER - CCC’, ‘MVC WEB INQUIRY CCC’)

Please see attachment to show setting from View > Formatting Options, and then the “Commas” setting from within there.

Is there something I can change so that I can get each entry in the IN statement split into a line of its own?

Any advice much appreciated.

Thanks

format-option.png


#2

Hello,

Can you just help me quickly by passing me the version number of the formatter
options screen, see About box.

Thanks,

Andre


#3

Hi Andre,

Thanks for your reply.

The Formatter is Version 4.8.7

Thanks