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<msav...@golden.net> 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: ProFox@leafe.com
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/4edeb324.6060...@golden.net
** 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.
