Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Yoda coding styles
Message
From
24/04/2006 13:42:40
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01115355
Message ID:
01116087
Views:
19
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform