James --

I was thinking along the lines of have a set of templates that define the SQL statement structures. Then the templates could be modified by the developer to meet their desired format. Or something like that.

If I think of anything, I will contact you.

>Greg --
>
>As part of PEM Editor (my contribution to VFPx), I am adding a number of features that go beyond what the current 'Beautify' does -- spaces around operators, making string delimiters constant, consistent usage for 'not' and 'not equal', etc.
>
>Thus my interest in this topic.
>
>Perhaps, if time and your interest permits, we could collaborate.
>
>(What I'd really prefer for SQL-Select statements is something that would not only exclude them from Beautify -- but also apply some standard layout for them ... alas, I think there would not be much agreement in what a standard layout would be).
>
>Jim
>
>>A much more complictated approuch. I, for one, will put it on my personal todo list and look into it when I have more free time.
>>
>>>Greg --
>>>
>>>My first response -- Very Nice !!
>>>
>>>And then -- I'll never take advantage of that because I use beautify all the time (almost every time I close a method or PRG) and I will probably not learn that I needed to put in those directives until too late.
>>>
>>>My hope is to find some way to globally indicate how beautify could identify code to be beautified ... without needing to modify the code at all. My thought was that I would start by looking for multiple-line select statements.
>>>
>>>>>I use it a LOT.
>>>>>
>>>>>At one time i thought there was some kind of option to surround code w/keywords to NOT apply beautify, but could never find it again,.
>>>>>
>>>>>I'd like to be able to specify how to format SELECT SQL comands.
>>>>>
>>>>>J
>>>>
>>>>I liked the idea, so i took a quick moment and added the functionality. All you need to do is to place a special directive (comment) at the begin and end of the excluded code. See the comments in the beginning of Beautify.prg.
>>>>
>>>>http://www.glrsoftware.com/download/download.asp?file=Beautify.zip