>>I think one should keep an open mind. For example, in a recent message to me Fabio Lunardon used the following:
SELECT cFromIP ;
>> , cPortProt ;
>> , cToPDom ;
>> , cToFDom ;
>> , COUNT(*) counts ;
>>INTO CURSOR GpTest1 ;
>> FROM Logs1;
>> GROUP BY 1,2,3,4
I don't know if Fabio purposely wanted tabs expanded out to 8 characters but that's not what's interesting here. I'd never before considered putting the comma for a list extension at the START of a new line, but it's thematic in the same way as:
>
>Old School SQL DBA is what I see there.
>
>As your building line by line, or removing, you never get buned in any part of your statement because the connections needed are on the same line.
>
>Much like creating dynamic SQL
>
>SQLstring = SQLstring + iif(colCount>1,', ','') + ColName
Agreed. I do the same thing, for the same reasons in much of my code. When I first saw Fabio's response my initial reaction was that it was really dumb. Then, after I considered it for a while, I saw why he did that, and that it's just an extension of something I've been doing all along. Just because something looks "funny" or "different" doesn't necessarily mean it's worse.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up