>SELECT LName, FName, Mi, ThID, neSigOpt, lPin, lFingerReg, ; > PADR(ConfirmType(neSigOpt, lPin, lFingerReg), 30) AS ConfData, isactive, lOverride ; >FROM Ther ; >&lcFilter ; >INTO CURSOR SigTypeR; > ORDER BY LName, FName,isActive, neSigOpt DESC, 8, Mi, ThID>
>>SELECT LName, FName, Mi, ThID, neSigOpt, lPin, lFingerReg, ; >> PADR(ConfirmType(neSigOpt, lPin, lFingerReg), 30) AS ConfData, isactive, lOverride ; >>FROM Ther ; >>&lcFilter ; >>INTO CURSOR SigTypeR; >> ORDER BY isActive, neSigOpt DESC, 8, LName, FName, Mi, ThID >>>>where lcFilter = "Where (neSigOpt = 2 or neSigOpt .LessThan. 2) AND IsActive"
>>Lname, Fname neSigOpt (Not Diplayed) neSigOpt Translation (displayed) >>AA, Abel 3 PIN >>BB, Betty 3 PIN >>CC, Cain 3 PIN >>... 3 PIN >>AA, Andy 2 Fingerprint >>... >>ZZ,Zed 2 Fingerprint >>AA, Aaron 1 Not Authorized >>.. >>XX, Xena 1 Not Authorized >>AA, Annie (Blank) Not Authorized >>... >>>>I've tried manipulating the neSigOpt field with iif(empty(neSigOpt),1,neSigOpt) as neSigOpt - but it seems to make no difference.