On 5/15/2019 6:23 PM, Richard Kaye wrote:
And here's a use case where SET FILTER can be quite useful in a production application. Let's say you have a form that displays account receivable transactions for a customer (invoices, payments, adjustments, etc.). You want to be able to display only open (i.e. unpaid) transactions or transactions related to a specific invoice. The primary query has returned all the rows I need to display for that customer. SET FILTER handles that quickly and simply without the overhead of running another query against the main database.
--
rk
EXACTLY!!! That's been (part of) the beauty of FoxPro for years, something other programs didn't (and perhaps still don't) have.
--- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus