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, ThIDwhere 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.