function to build filters

[lucasdebeltran]

Hello friends,

I'm looking for a function to filter in a dbf, that allows for various conditions, and or in the subsequent conditions, different operators, etc., so that the user can be dynamically building the filter.

Is there anything ?. Thank you very much and happy 2015.

[Enrico Maria Giordano]

Code: Select all  Expand view

INDEX ON ... TO ... FOR cCondition

EMG

[lucasdebeltran]

I mean the dialog with field, operator and condition... function that processs and verifies the condition, operator and field type...

[Enrico Maria Giordano]

Lucas,

I don't know, sorry.

EMG

[lucasdebeltran]

No problem.

It also can be paid.

[nageswaragunupudi]

Have you checked fivedbu ?

[lucasdebeltran]

Yes but that routine is not finished, Does not verify expresions, field types and operators...

[Enrico Maria Giordano]

Lucas,

you can test them using TRY/CATCH/END.

EMG

[Silvio.Falconi]

Two years ago I asked to insert on xbrowse a small filter to use on xbrowse easy.
After some work ( it is was not a interest for anyone) I made a small Class Tfilter to use with xbrowse



the procedure need only the obrw object and the procedure save on memory : fields,Headers and type of fields and with this data you can create the filter as you can see on picture
You can save all filter created on ini file and call from your procedure easy
It save on file ini
if you want try it send to me a msg.

[lucasdebeltran]

Yes please

[Gross]

Can you send me the class?
That's exactly what I'm looking for a long time.

Thank You!
Manfred

[elvira]

Me too please .

Or maybe it´s better to post in the forums, as the Rating class.

In my opinion, this class TFilter is more useful and we should help Silvio to debug it!!!!.

[Silvio.Falconi]

this week I recompiled my sources and I found a strange error nEditTypes .. I dont Know I asked to Nages

[Silvio.Falconi]

Sorry ...I found the error give me this tonight to recompiled all sources and make some tries ...

[lucasdebeltran]

Great, thank you Silvio.

If you post here the samples, several people can help to test it.