As best I recall, simply setting a filter will not move the record pointer. You need to do that and then check to see if you are at EOF. And it gets a little more complicated if you have any relations set to your filtered table. Or you have dirty buffers and are using row buffering.
--
rk
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Monday, May 08, 2017 4:39 PM To: profoxtech@leafe.com Subject: Question about determining when record not showing after filter applied
VFP9SP2
After applying a filter to a grid cursor, I want to know if the current record pointer (not moved since the filter applied) is on a record that is affected by the filter? That is, if the record pointer is on a record that is no longer visible due to the filter, I want to reset the pointer to the first record in the cursor, or perhaps the previous or next record that IS showing yet even after the filter applied.
My testing shows that my current record pointer does not move after the filter applied (as expected) and EOF('myCursor') is .F. (which is technically true, since it's on a valid record, although it's being filtered out).
Ideas? tia! --Mike