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:profoxtech-bounces@leafe.com] On Behalf Of Gene Wirchenko Sent: Tuesday, August 09, 2016 1:58 PM To: profoxtech@leafe.com 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]