Filtering in TwBrowse

[driessen]

Hello,

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

Which is the best to do the filtering very fast ?

Thanks.

[Enrico Maria Giordano]

Scopes and conditional indexes.

EMG

[driessen]

EnricoMaria, Thanks for you answer.

Can you give me an example of filtering by scopes ?

Thanks.

[Enrico Maria Giordano]

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

Code: Select all  Expand view

USE TEST

INDEX ON FIELD -> last + FIELD -> first TO TEST

CLOSE

And then you can use it:

Code: Select all  Expand view

USE TEST INDEX TEST

SET SCOPE TO "F", "L "

GO TOP

BROWSE()

CLOSE

EMG

[driessen]

EnricoMaria,

Thanks for your example.

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

Is it standard procedure in xHarbour ?

Thanks.

[Enrico Maria Giordano]

Try using

#include "Ord.ch"

or use the function instead of the command:

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

EMG