Fred had a good intuition. Possible scenarios when you issue "go TOP":
- no index order set then you should be on RECNO() = 1 unless it is deleted the will be = 2 unless deleted and so on - index order set, whatever is its expression, then RECNO() depends on that order The fact that your flag ACTIVE is .f. depends simply on your data. Gianni On Tue, 06 Dec 2011 19:28:20 -0500, Michael Savage <[email protected]> wrote: No I don't have an index on the field. Actually the table is indexed on surname. Mike On 06/12/2011 6:13 PM, Fred Taylor wrote: > Do you have an index on the "active" field? if you did, then a GO TOP with > no filter would always take you to the first record where active=.F. even > if it's not the first physical record. > > Fred > > > On Tue, Dec 6, 2011 at 2:30 PM, Michael Savage<[email protected]> wrote: > >> I want to set a filter to a logical field. The field name is active. >> >> If the user, wants to see active records only, >> I am using the following snippet. >> set filter to active=.t. >> >> similarly if they want to see inactive records, I use >> set filter to active =.f. >> >> When the user would like to see both sets together, >> I use >> set filter to. >> >> After each filter change I issue a >> Go top >> to move the record pointer. >> >> But what happens is this: >> When I chose, both, the filter is cleared, according to the >> set("filter") command, but issuing goes to the first record that is >> inactive. >> >> Any ideas? >> Mike >> >> [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.
