Page 1 of 2
function to build filters
Posted: Sun Jan 04, 2015 11:46 am
by 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.
Re: function to build filters
Posted: Sun Jan 04, 2015 2:02 pm
by Enrico Maria Giordano
Code: Select all
INDEX ON ... TO ... FOR cCondition
EMG
Re: function to build filters
Posted: Sun Jan 04, 2015 2:18 pm
by lucasdebeltran
I mean the dialog with field, operator and condition... function that processs and verifies the condition, operator and field type...
Re: function to build filters
Posted: Sun Jan 04, 2015 2:31 pm
by Enrico Maria Giordano
Lucas,
I don't know, sorry.
EMG
Re: function to build filters
Posted: Sun Jan 04, 2015 2:35 pm
by lucasdebeltran
No problem.
It also can be paid.
Re: function to build filters
Posted: Sun Jan 04, 2015 2:37 pm
by nageswaragunupudi
Have you checked fivedbu ?
Re: function to build filters
Posted: Sun Jan 04, 2015 2:54 pm
by lucasdebeltran
Yes but that routine is not finished, Does not verify expresions, field types and operators...
Re: function to build filters
Posted: Sun Jan 04, 2015 3:13 pm
by Enrico Maria Giordano
Lucas,
you can test them using TRY/CATCH/END.
EMG
Re: function to build filters
Posted: Sun Jan 04, 2015 6:13 pm
by 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.
Re: function to build filters
Posted: Sun Jan 04, 2015 6:17 pm
by lucasdebeltran
Yes please
Re: function to build filters
Posted: Sun Jan 04, 2015 7:47 pm
by Gross
Can you send me the class?
That's exactly what I'm looking for a long time.
Thank You!
Manfred
Re: function to build filters
Posted: Mon Jan 05, 2015 4:23 pm
by 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!!!!.
Re: function to build filters
Posted: Mon Jan 05, 2015 11:11 pm
by Silvio.Falconi
this week I recompiled my sources and I found a strange error nEditTypes .. I dont Know I asked to Nages
Re: function to build filters
Posted: Mon Jan 05, 2015 11:57 pm
by Silvio.Falconi
Sorry ...I found the error give me this tonight to recompiled all sources and make some tries ...
Re: function to build filters
Posted: Tue Jan 06, 2015 10:21 am
by lucasdebeltran
Great, thank you Silvio.
If you post here the samples, several people can help to test it.