FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Is the order of fields important for filtering data ?
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Is the order of fields important for filtering data ?
Posted: Wed Oct 09, 2024 03:25 PM

I wonder if using multiple fields to perform a filter (used in a Xbrowse with the headers search gets) the order is important.

Let say that I want foling fields filtered :

Index is on Name : filter like Name...+Color++++Size (filter setting)

Name : Test

Color : Blue

size : Large

Second option is the field Color is before the name in the browse, the filter will be :

Color...+Name....+Size (filter setting)

In the first case, the filter's first field is a index field and I think that it will go direct to a position of the name

In the second case the corlor has no index and I think that ALL record will be processed and then the rest of the filter.

I hope my question make sence )))

Witch is best ?

Marc Venken

Using: FWH 23.08 with Harbour

Continue the discussion