Self Defeating Select Statements

Johnson, Tracy Tracy.Johnson@msiusa.com
Thu, 10 Feb 2005 17:08:03 -0500


I'm debugging a line of old Quiz code and I found the following two lines next to each other:

...
SEL IF ARCLSD <> 2;SEL IF ARCLSD EQ 0
QUAL ARCLSD VALUE "0"
...

The second line is an OMNIDEX call in Quiz, what I think it is telling me is to only pick the field ARCLSD if the value is zero (it only accepts strings, hence the numeric field is in quotes.)

In effect the first statement is redundantly null and void since I'm only asking for zeroes anyway.

Or did I miss something 'magical' in Omnidex?

(The first statement also looks like the original programmer was testing SELection theories and commented one of his earlier tests behind the semicolon.)



BT


Tracy Johnson
MSI Schaevitz Sensors