Hi Luiz,
there's
HFilter(..) which gives you a broad range of filtering. There's the command
HFilterIncludedBetween(..) which simplifies filtering for from-to values
since version 9 (!) and is not limited to key items of the filtered file! However, I do not recommend to use any of the HFilter.. commands because of speed issues and because of their application-wide filtering. If you don't / can't use HDeactivateFiler(..) then matters will become a bit complex. There are two much better ways to 'filter' a Table.
- use a Query. For big files use a stored procedure for routinely used 'filters'.
- use a memory Table and fill it by programming.
Kind regards,
Guenter