>>>I know this may sound like heresy to some, but I make extensive use of VFP's ability to execute &-macro defined command lines. This is an extremely powerful feature that sets VFP apart from any other language I know of.
>>
>>Just for debate's sake, could you give an example of one of these uses? I have yet to see a good one...
>
>I use this to build a SQL statement to work out the maximum column widths of data in a grid - as it's generic the SQL has to be built for each column in the grid depending on the data type.
>
>
>Select max(_screen.Textwidth(column1))), ;
>max(_screen.TextWidth(Transform(column2)), ;
>
>
>etc.
There's no macro expansion in your above code.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer