topic-29909

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

function to build filters
Posted: Sun Jan 04, 2015 11:46 AM

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.

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: function to build filters
Posted: Sun Jan 04, 2015 02:02 PM

Code (fw): Select all Collapse

INDEX ON ... TO ... FOR cCondition

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: function to build filters
Posted: Sun Jan 04, 2015 02:18 PM

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

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: function to build filters
Posted: Sun Jan 04, 2015 02:31 PM

Lucas,

I don't know, sorry.

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: function to build filters
Posted: Sun Jan 04, 2015 02:35 PM

No problem.

It also can be paid.

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: function to build filters
Posted: Sun Jan 04, 2015 02:37 PM

Have you checked fivedbu ?

Regards

G. N. Rao.

Hyderabad, India

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: function to build filters
Posted: Sun Jan 04, 2015 02:54 PM

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

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: function to build filters
Posted: Sun Jan 04, 2015 03:13 PM

Lucas,

you can test them using TRY/CATCH/END.

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: function to build filters
Posted: Sun Jan 04, 2015 06:13 PM

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.

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: function to build filters
Posted: Sun Jan 04, 2015 06:17 PM

Yes please

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

Gross

Posts: 41

Joined: Sat Mar 09, 2013 08:17 AM

Re: function to build filters
Posted: Sun Jan 04, 2015 07:47 PM

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

Thank You!
Manfred

Manfred Groß

elvira

Posts: 518

Joined: Fri Jun 29, 2012 12:49 PM

Re: function to build filters
Posted: Mon Jan 05, 2015 04:23 PM

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

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: function to build filters
Posted: Mon Jan 05, 2015 11:11 PM

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

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: function to build filters
Posted: Mon Jan 05, 2015 11:57 PM

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

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: function to build filters
Posted: Tue Jan 06, 2015 10:21 AM

Great, thank you Silvio.

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

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

FiveTech Support Forums