FiveTech Software tech support forums

... even if we still complain about a flickering when xbrowse changes the size, it should do it without creating flash in the dialog because it is ugly to see. obviously this is a general test, I have to try it with the school's warehouse items archive where there are many types of filters to be made

A temporary index file are really convenient. I use them together with XBROWSE for creation of accumulative filters, WildMatch () and (or) small reports.
Work with them is simple and the universality allows to work with any dbf files without creation of the additional interface.
......
index on ...

... under the fields and and select the information is useful and functional

I already have a class (Tfilter created by me many years ago) to make filters using logical operators. You can find it in the utilities folders of fwh. But unfortunately it is not functional in the sense that only ...

Dear Silvio,

It looks simply great :D


yes but not run ok

as I explained above:

- the filter must be cumulative, that is, now it filters individually
- when you cancel a checkbox, the procedure, in addition to changing the height of the xbrowse, must make only the relative controls of the ...

... video I tried to cancel the checkboxes according to the initial activation

the changes I need are:
the filter must be cumulative, that is, now it filters individually
when you cancel a checkbox, the procedure, in addition to changing the height of the xbrowse, must make the controls disappear so as ...

... data from top to bottem.

2. This is correct thinking or not ?

ChatGPT also thinks that arranging the filter with field that have tag as first filters are faster.

ChatGpt second option :

rearrange the filter string also that field with a tag are in front of the Filterstring
then process like ...

I use 2 sort of filters.

1. Filters created by me and let the user select them from a pulldown menu. (Filters are stored in dbf file and used corresponding a specific XBrwowse
These filters are not for change by user

2. Use the build-in filter system from xbrowse using aBarGet system. (every column ...

... function also.

So I have 9 folders in folderex.

What I see is that when startup the program, ALL 9 xbrowsers are processed and also all the filters are setup.
I was thinking that folder 1 was processed and all others only when they are called (selected from the folderex)

Does this have to do ...

As Mr. Vilian said, the expressions used for oRs.SetFilter and oRs:Locate should use DBF syntax.
Very same expressions you use for setting filters or locate for statements in DBF.

There is another method which helps you to make these expression easily for you.

? cLocate := oCn:ExprnDBF( "HIREDATE ...

Marc, how do you make your filters? I always prefer using these commands:

Marc, ¿cómo haces tus filtros? Siempre prefiero usar estos comandos:


// C:\FWH\SAMPLES\SETSCOPE.PRG

#include "FiveWin.ch"

ANNOUNCE RDDSYS
REQUEST OrdKeyNo, OrdKeyCount, OrdCreate, OrdKeyGoto
REQUEST DBFCDX, DBFFPT ...

Several members had filter, scopes etc. questions last period, so samples of optimised filters are VERY welcome.
Allmost all actions in my program are filter based.

... existing software.

1. Use Filter instead of Scope:

I am sure you will not like this idea at all.
Most of us are brain-washed to believe that filters are very very slow.
Not so.
Situation changed 3 decades back when FoxPro introduced Rushmore technology and our present DBFCDX uses similar ...

Ya están aquii

Marco,

It seems that you pull all dfb's for all selected months and than process each record from every dbf's over the net. No filters, seeks etc. ? I think here is you problem, or maybe i'm missing something

... once a other machine changes/adds data, the local indexes would be wrong not ?

In previous posts, I remember that this issue meanly is creating the right indexes... Using the RDD's optimised filters etc.. Mr. Rao onces started to explaine (thanks !!) but we didn't get to the final approuch (samples)