pcsoft.us.windevCopyright 2026, PC SOFT8 Mar 2016 13:59:00 Z8 Mar 2016 09:57:00 ZHi All I have such a simple problem; I have a file. It contains many records but 2 records I am interested in. The only difference in the 2 records is a boolean field; one record is set to true, the other record has the field set to false. I set a HFILTER() condition on the file for the boolean field = True. I then do a HREADSEEKFIRST() for a record I am looking for. The seek condition is NOT the boolean field, it is on another field. And it still finds the record whose boolean field does not match the HFILTER(). Help says that HFILTER() applies to HREADSEEKFIRST() and so should work. No error occurs when applying the HFILTER(). Why does this not work? TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56750/read.awp8 Mar 2016 13:59:00 ZDarren, Thanks. I find HFILTER fast enough for our purposes (record counts under 30,000) and if we use it on index fields. Bu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56750/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56750/read.awp[WD20] - HFILTER() Issueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56749/read.awp8 Mar 2016 13:58:00 ZM-K Thanks, understood.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56749/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56749/read.awp[WD20] - HFILTER() Issueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56745/read.awp8 Mar 2016 11:38:00 ZHi JP, It's tricky without seeing the code and the data, but I'd quickly write a query to return the same result set as your …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56745/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56745/read.awp[WD20] - HFILTER() Issueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56744/read.awp8 Mar 2016 11:33:00 ZHi JP, The help tells you that the filter is only taken into account when the seek involves the key used in the filter. You c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56744/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56741-wd20-hfilter-issue-56744/read.awp[WD20] - HFILTER() Issue