Peter, Michael has hit upon a problem that I reported in VFP just before SP1 came out. Also it affects the grids in that phantom records may start appearing.
The problem is a known one and you will probably find that instantiating the cursor manually in the Load as opposed to the DE may well solve the problem, so Mike, don't feel that you are all alone. it is difficult to re-create the problem in a test environment as if you use say one test table the problem disappears. What I ended up doing and the program around solution from Microsoft was to add a blank first physical record into the table that was never deleted and so it has stayed. I Posted a blog about this and the associated problem where records in grids that contain children of this phantom record also go completely out of phase. As I say, the problem isn't consistent but the answer is definitely a "work around" as opposed to a cure. Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Cushing Sent: 07 December 2011 16:52 To: [email protected] Subject: Re: Problem with set filter Michael Savage wrote: > sorry about the confusion... i know firstrecord is an active one... > yet the list still appears to be set to inactive. > mike > > Have you tried just browsing the table, then setting filters, then go top and check which record it goes it? If that works fine you could put a wait window on the form just after it goes top with: wait wind 'on Record ' + str(recn()) and see what results you get. Peter ---------------------------------------------------------------- Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at www.whisperingsmith.com Please update your address book with my new email address: [email protected] . This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
