Alan, In this case select..into nofilter is according to me not the same as the english no filter, it means 'select again and disregard the previous select' Regards, Koen
Op do 16 mei 2019 om 10:49 schreef Alan Bourke alanpbourke@fastmail.fm:
Depending on the select it might well just be filtering internally anyway, hence the 'nofilter' clause.
-- 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 oftenshort, 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]