For this kind of thing I use Views, perhaps u should try.
HTH, E.
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
Michael Savage wrote:
snip
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
sorry about the confusion... i know firstrecord is an active one... yet
the list still appears to be set to inactive.
mike
On 07/12/2011 11:04 AM, Peter Cushing wrote:
Michael Savage wrote:
snip
When the user would like to see both sets together,
I use
set filter to.
After each 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
as opposed to a cure.
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
Peter Cushing
Sent: 07 December 2011 16:52
To: profox@leafe.com
Subject: Re: Problem with set filter
Michael Savage wrote:
sorry about the confusion... i know
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
Michael Savage wrote on 2011-12-06:
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
Unfortunately, it is not tied to a grid. just a form.
Mike
On 06/12/2011 5:10 PM, Tracy Pearson wrote:
Michael Savage wrote on 2011-12-06:
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
with set filter
Unfortunately, it is not tied to a grid. just a form.
Mike
On 06/12/2011 5:10 PM, Tracy Pearson wrote:
Michael Savage wrote on 2011-12-06:
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
. Active is apparently a keyword.
http://gorila.netlab.cz/_vfpkw_A.html
John
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Michael Savage
Sent: Tuesday, December 06, 2011 4:23 PM
To: ProFox Email List
Subject: Re: Problem with set
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
: Re: Problem with set filter
Unfortunately, it is not tied to a grid. just a form.
Mike
On 06/12/2011 5:10 PM, Tracy Pearson wrote:
Michael Savage wrote on 2011-12-06:
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
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
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
14 matches
Mail list logo