VFP's query engine decides what has less overhead; running the query or doing a USE...AGAIN with a filter. NOFILTER and READWRITE force VFP to create a temp file with the results.
-- rk -----Original Message----- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Peter Cushing Sent: Tuesday, May 21, 2019 6:35 AM To: profoxt...@leafe.com Subject: Re: Filtering Oddity On 20/05/2019 19:39, Fletcher Johnson wrote: > Not sure where the "Had to be bad coding" comes in. > > For example, if you did "select * from employee where last name = 'Smith'" > you would get a cursor of only those employees. The employee table > would still be open, but VFP opened it again, in a different work > area, with a different alias, and then put a set filter. Edits to > this cursor would be written to the actual source table. > > Are you sure about that? Never heard of that behaviour before. If I do a "Select * from picorder where vt_desc = 'India' into cursor mycursor" I get a standalone cursor that I can't update (DBF() = C:\TEMP\0000FABT02AV.TMP) If I do a "Select * from picorder where vt_desc = 'India' into cursor mycursor READWRITE" I still get a stand alone cursor that can be updated but won't affect the source table. If I leave off the into cursor mycursor then I still get a stand alone cursor called query. I don't know if that behaviour was from an older VFP version but I don't remember it. Am I getting Alzheimer's? Somebody put me out of my misery :-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960 _______________________________________________ Post Messages to: ProFox@leafe.com 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/220dcea1-730f-f7ac-6340-d2846c84d...@whisperingsmith.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. Report [OT] Abuse: http://leafe.com/reportAbuse/220dcea1-730f-f7ac-6340-d2846c84d...@whisperingsmith.com _______________________________________________ Post Messages to: ProFox@leafe.com 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/bn6pr10mb14584ac1c94c4c5b16ea630ad2...@bn6pr10mb1458.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.