FiveTech Software tech support forums

by **driessen** » Mon Jun 04, 2007 2:49 pm

Hello,

I need to filter my data and show them in a TwBrowse.

Which is the best to do the filtering very fast ?

Thanks.

by **Enrico Maria Giordano** » Mon Jun 04, 2007 8:42 pm

Scopes and conditional indexes.

EMG

by **driessen** » Tue Jun 05, 2007 12:14 am

EnricoMaria, Thanks for you answer.

Can you give me an example of filtering by scopes ?

Thanks.

by **Enrico Maria Giordano** » Tue Jun 05, 2007 6:56 am

You must have an index on the key you want to scope:

Code: Select all Expand view RUN: USE TEST INDEX ON FIELD -> last + FIELD -> first TO TEST CLOSE

And then you can use it:

Code: Select all Expand view RUN: USE TEST INDEX TEST SET SCOPE TO "F", "L " GO TOP BROWSE() CLOSE

EMG

by **driessen** » Tue Jun 05, 2007 10:18 am

EnricoMaria,

Thanks for your example.

Unfortunately, I got a syntax error on "SCOPE".

Is it standard procedure in xHarbour ?

Thanks.

by **Enrico Maria Giordano** » Tue Jun 05, 2007 10:28 am

Try using

#include "Ord.ch"

or use the function instead of the command:

ORDSCOPE( 0, "F" )
ORDSCOPE( 1, "L " )

EMG

Filtering in TwBrowse