On Sat, May 18, 2019 at 12:01 AM Fletcher Johnson
<[email protected]> wrote:
> 1) It used to be that a Select statement would be optimized by VFP to open
> the source table again, in another work area, and then set a filter on it.
> This was a problem when people thought they had a cursor and updated the
> contents, only to find out they had edited the actual data.  So they added a
> "nofilter" clause that forced VFP to create a new cursor and not use the
> original approach.

Had to be bad coding, possibly mixing up aliases in the process.

> 5) I can't remember, but did set filter allow you to reference a variable?
> And, if so, did changing that variable then change the effect of the filter?
> If so, this might also be an option.

SET FILTER can use variables. Changing the values of the variables
should not affect executed SET FILTER if I remember correctly.

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Fedora 25 Server Spin
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

_______________________________________________
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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAGv=mjaxixafg5amsbsryflcjemj6i8a6qnfphufn_l6oee...@mail.gmail.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.

Reply via email to