Page 1 of 1
RRW 8.0 XBase: Special Characters
Posted: Fri May 24, 2002 5:33 pm
by Matt_Kiley_(Guest)
To whom it may concern:____I am interested in where the special characters come from and if I understand the true meaning. __ Examples - __CHKDED->CODE$"940,941,942,943,944,945,946,948,952,953" indicates that in the CHKDED database the field CODE is in the list "940,941,etc".____Should CHKDED->CODE#"940,941,942,943,944,945,946,948,952,953" indicate that in the CHKDED d/b the field CODE is NOT in the list? ____Thank you.__Matt.
=> RRW 8.0 XBase: Special Characters
Posted: Mon May 27, 2002 6:44 am
by kfleming
CHKDED->CODE$"940,941,942,943,944,945,946,948,952,953" __does indicates that in the CHKDED database the field CODE is in __the list and would be true for codes 1,2,3,94,40,46 as well so you need to consider that as well.____You could alternatively use:__INLIST(CHKDED->CODE,"940","941","942","943","944","945","946","948","952","953")>0__to test explicitly for this list of values__or __INLIST(CHKDED->CODE,"940","941","942","943","944","945","946","948","952","953")=0__to determine that the current value is not one of these.____Kathleen__R&R Support
==> RRW 8.0 XBase: Special Characters
Posted: Wed Jun 05, 2002 6:09 pm
by Matt_Kiley_(Guest)
Thank you. Your ^tip^ below helped.____PS - Those that read this should be aware that using >0 at the end of the INLIST() function will change it from a numeric to a logic field (T/F).____Sincerely,__matthew_kiley@dell.com