SELECT cFromIP ; > , cPortProt ; > , cToPDom ; > , cToFDom ; > , COUNT(*) counts ; >INTO CURSOR GpTest1 ; > FROM Logs1; > GROUP BY 1,2,3,4I 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:
* This
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__Stephen Russell
>>
"Simplicity is the ultimate sophistication."
Leonardo da Vinci
>> My old crummy site.