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:[email protected]] On Behalf Of [email protected] Sent: Monday, May 08, 2017 4:39 PM To: [email protected] 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 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb0913a271db76a1c360844904d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
