Interesting. It seems to be using the entire string from the first double quote to the second double quote as the filter expression and ignoring everything after that; almost like an inline comment. I did something similar on my system like this:
SET FILTER TO address1="529 and LEFT(country,2)="US" SET([FILTER]) returns this: ADDRESS1="529 and LEFT(country,2)=" Of course no records match that expression but it's not invalid. -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Gene Wirchenko Sent: Tuesday, August 09, 2016 1:58 PM To: [email protected] Subject: Minor VFP Bug on Filter Expressions Hello: I just ran into a minor bug in VFP on filter expressions. I typed the following: use cwko order tag cwkow set filter to clcode="KAK and left(wccode,2)="SP" browse and got an empty browse. What? I missed the closing quote after "KAK". That second line should have been: set filter to clcode="KAK" and left(wccode,2)="SP" I did *not* get an error on the original set filter line or the browse despite the filter expression being invalid. Sincerely, Gene Wircheko [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/sn1pr10mb092877202f5fb7162e09995bd2...@sn1pr10mb0928.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
