FiveTech Software tech support forums

This is a interesting sample for filtering.... Mr. Rao, Would you please be so kind to enhance this sample so that there is a second combobox selecting ages like (20 - 40 - 50 etc) and state like (NY, WY etc) Any small sample with more combo's ...

In this case, no. Using data architect, I tried filtering for not empty but it still includes them


Sent from my iPhone using Tapatalk

... purposes. I have to reread xbrowse systems for better use with array. Not sure that I will go that way.... Who has information about the RDD (CDX) filtering techniques ? Mr. Rao wrote that this is one of the most important speed issues in xbrowse when not done the best way.

BarGet's purpose is not just for filtering. This helps us to GET some value and it is for us to do whatever with that Value, whether we use for filter or for seek or for setting scopes or for whatever purpose. Do not underestimate filters. ...

BarGet's purpose is not just for filtering. This helps us to GET some value and it is for us to do whatever with that Value, whether we use for filter or for seek or for setting scopes or for whatever purpose. Do not underestimate filters. ...

... the data for quick access case cData = "CustStreet" set index street scope the data otherwise // more fields have been filled in, so filtering will be a better option do the filter stuff endcase here is my current filtercode :    //  From insite the Xbrowse setup  ...

Due to several post, I indeed started to use Scopes a lot more, and they are pretty fast.. In this case, it is the bBargetAction that i'm looking into. Since Mr. Rao made it possible to use a function of ourselves, maybe there I have to changes stuff for better performance/speed. In this version the...

Mr Marc 1. I wonder if this code is still optimised for the current version of FW. The code is somewhere from the forum, but sure a longer time ago. Changes needed ? Optimization has nothing to do the version of FWH. Optimization of filters is dependent of (x)Harbour RDD. DBFCDX and ADS optimize fil...

James

You are correct that scopes are faster for DBFCDX .. filters are even faster in Sql ...

Rick Lipkin

Marc, There have been a number of recent forum discussions about filters vs scopes. The basics are that with a filter you have to read every record in the database, but with a scope you only read the records within the scope. For example, you are using a browse and you want to only show customers in...

Hello, In my xbrowser's i use the folowing syntax for my BargetAction, that i use alot. // xbrowse setup ...   :bBarGetAction := {|| ( oBrwSel:cAlias )->( MARC_SETFILTER( oBrwSel ) ) } FUNCTION MARC_SETFILTER( oBrw )   LOCAL cFilter := ""   LOCA...

... You have it running... That's mostly the goal .... But did you try the scope ? I would think it should be faster and less code. A new second filtering (maybe not needed) would also be faster. Mostly out of interest this question. I don't really trust the ...scope then Nages told me to use ...

Silvio,

You have it running... That's mostly the goal ....

But did you try the scope ? I would think it should be faster and less code. A new second filtering (maybe not needed) would also be faster.

Mostly out of interest this question.

... makes a physical copy of the dbf, instead I wanted to create at least for the "Virtual" archive only the structure and then through a filtering system insert the selected records in the new archive How could I do ? If nTipo=2    oDbf :=TDatabase():Open( , cDir+"Virtuale", ...

... record database - 20,543 records match criteria (state="CA") - Time for filter 23.13 seconds - Time for scope 0.32 seconds Thus filtering took 23.13 / 0.32 = 72 times longer than a scope. And the winner is, scopes!