Re: Filtering Oddity

-- Alan Bourke alanpbourke (at) fastmail (dot) fm On Thu, 16 May 2019, at 6:26 AM, Koen Piller wrote: > Richard, > what you describe is a matter of personal taste. > There is no overhaed in building a cursor with select * from myData where > unpaid<>0 into cursor curUnpaid vs set fillter to unpaid <> 0 in myData. > I, personaly, would prefer #1 in the enduser environment environment# 2 in > my development environment - version(2)#0 vs version(2)=0. > There is also no need to call a select() statement an overhead. > Regards, > Koen > > > > Op do 16 mei 2019 om 00:23 schreef Richard Kaye rkaye@invaluable.com: > > > 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 > > > > -----Original Message----- > > From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Gene > > Wirchenko > > Sent: Wednesday, May 15, 2019 2:55 PM > > To: profoxtech@leafe.com > > Subject: RE: Filtering Oddity > > > > At 11:41 2019-05-15, Richard Kaye rkaye@invaluable.com wrote: > > >Gene and Woody's point is that XBASE tools are quite useful for us when > > >developing/testing, not that they are necessarily preferable for > > >production code. > > > > Exactly. > > > > One advantage that is particularly nice is that they are often > > short, simple, and fast. When I am chasing a bug or working on an idea, I > > prefer being able to get done what I want done fast. The protections that > > one might well want for an app are often not relevant. > > > > [snip] > > > > Sincerely, > > > > Gene Wirchenko > > > > [excessive quoting removed by server]