I use the generic Indicator. Any variable in a select that is important enough to check for null will be checked by a direct method following the select and handled appropriately. Since 1985 I have seen no other instance when I thought otherwise.
----- Original Message ----- From: "Tony IJntema" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, August 29, 2012 5:27 PM Subject: [RBASE-L] - RE: INDICATOR variables : Mike, : : : : Only to give you some food to think about when you have nothing else to do. : : : : A lesson learned in the past is that you always will pay a price being lazy : in programming. : : In my opinion you better define a separate variable for each individual : indicator. : : : : You can clear them easily at the end of a procedure by using a simple : convention like starting every indicator with the abbreviation : vind_<columname> : : At the end of the procedure use the statement: : : : : Clear var VIND_* : : : : Mr P. Ovidius Naso (A Roman author a long time ago) wrote the following : sentence in one of his poems: : : : : Video meliora proboque, sed sequor detrioria : : : : In English: : : I see the better things and I approve them, : : But I follow the worse. : : : : I think this statement is also true in programming. : : : : : : Tony : : The Netherlands : : : : : : From: [email protected] [mailto:[email protected]] On Behalf Of : [email protected] : Sent: woensdag 29 augustus 2012 22:03 : To: RBASE-L Mailing List : Subject: [RBASE-L] - INDICATOR variables : : : : When using a SELECT . . . INTO . . . .INDICATOR statement can just one : generic INDICATOR variable be used for each value or should there be a : unique INDICATOR variable for each value? : : For example is it OK to do this: SELECT custname,custcity,custzip INTO : vname INDICATOR vind,vcity INDICATOR vind,vzip INDICATOR vind . . . . : : Or is this the best way: SELECT custname,custcity,custzip INTO vname : INDICATOR vnameind, vcity INDICATOR vcityind,vzip INDICATOR vzipind . . . . : : I'm guessing unique may be better but can a generic one be used? : : Any and all guidance is greatly appreciated. : : Thanks. : : Mike Ramsour : AK Steel Coshocton Works : Quality Department : Phone: 740-829-4340 : Cell: 740-502-1659 : : : Confidentiality Notice : This message is intended exclusively for the individual or : entity to which it is addressed and may contain privileged, : proprietary, or otherwise private information. : If you are not the named addressee, you are not authorized : to read, print, retain, copy or disseminate this message or : any part of it. If you have received this message in error, : please notify the sender immediately by e-mail and delete : all copies of the message. :
