My Query tool (download# 31868) has a SQL statement (sort of), but is tuned to the tool. I will take a look at its engine and see if it can be salvaged to this purpose.

>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