Yes, I was thinking something along those lines as well. Nothing at all defined, however ...

But, for me, it is only SQL-Select statements that I care about ... umm, maybe "Create Cursor" but that's a minor point.

>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