"select *" tab expand does not respect comma placement rule

austrianfoodispuke

enter ssf * from x

go back to * and hit TAB to expand the cols

commas are placed at the end of the line




my layout setting is to put it at the beginning

jerryhung

good point, I just ran into that issue this morning
not a big blocker though, just means I have to fix either the first few lines, or the last few lines

tanya

Hi,

Pressing tab expands the columns in the table and at this point of time it is SQL Prompt's code completion functionality that is at work.
For your layout settings to take effect, you need to click on Layout option in the SQL Prompt menu and that would format your code as you have customised in your settings.

I hope that helps.

Thanks,
Tanya

paschott

I'm just curious - wasn't this part of the standard SQL Prompt package at one point and not only available in the Professional edition? I could have sworn that I could do this in an earlier release and as far as I know I've never had a "Professional" edition.

I was looking for this today as I'm laying out some new code and found all of my commas placed at the end of the line rather than at the beginning as I'd hoped for.

Thanks.

-Peter Schott

Matthew.Wilkerson

This WAS a part of the original Prompt SQL (and possibly SQL Prompt 2.x), but unfortunately not 3.x. It was one of the first things I noticed when 3.x came out.