Re-applying filter ..

I have come across a particular problem may be someone else here as also
encountered it.

I have applied a FILTER condition on a table & then changed the value of a
field - which is part of the Filter Expression - which causes some more
records to meet the filter condition and hence are desired to be filtered
out.

But I am surprised that when all the records meet the Criteria as set in the
FILTER Expression it works fine but when some records are already being left
out - coz of the FILTER Expression - and some more are added to the list the
records don't respect the filter condition.

I am moving the Record Pointer in both the cases. After applying and/or
changing the Data.

Is there any method other than to
1: save the Filter,
2: setting Filter Off and then
3: Reapplying the Filter Condition.

which forces the Foxpro to refresh/reapply the filter to the table.

TIA
Tanveer

Sietse
Mon Aug 09 07:44:06 CDT 2004

Hi Tanveer,
If you're using a grid, you can just call the grid's refresh method.
If you're using a browse, you can use the name-clause in the BROWSE command
to get an object reference to the browse (essentially a grid object) and the
call its refresh-method.

HTH,
Sietse Wijnker

"Tanveer H. Malik" <tanmalik@hotmail.com> wrote in message
news:%23bZN4KefEHA.3888@TK2MSFTNGP09.phx.gbl...
> I have come across a particular problem may be someone else here as also
> encountered it.
>
> I have applied a FILTER condition on a table & then changed the value of a
> field - which is part of the Filter Expression - which causes some more
> records to meet the filter condition and hence are desired to be filtered
> out.
>
> But I am surprised that when all the records meet the Criteria as set in
the
> FILTER Expression it works fine but when some records are already being
left
> out - coz of the FILTER Expression - and some more are added to the list
the
> records don't respect the filter condition.
>
> I am moving the Record Pointer in both the cases. After applying and/or
> changing the Data.
>
> Is there any method other than to
> 1: save the Filter,
> 2: setting Filter Off and then
> 3: Reapplying the Filter Condition.
>
> which forces the Foxpro to refresh/reapply the filter to the table.
>
> TIA
> Tanveer
>
>

Tanveer
Tue Aug 10 02:52:59 CDT 2004

I am using none of them instead I am using a scan while .. loop to iterate
through the table after setting the pointer to BOF


"Sietse Wijnker" <sietse.wijnker@ATsw-software.nl> wrote in message
news:ewiFc6gfEHA.1972@TK2MSFTNGP09.phx.gbl...
> Hi Tanveer,
> If you're using a grid, you can just call the grid's refresh method.
> If you're using a browse, you can use the name-clause in the BROWSE
command
> to get an object reference to the browse (essentially a grid object) and
the
> call its refresh-method.
>
> HTH,
> Sietse Wijnker
>
> "Tanveer H. Malik" <tanmalik@hotmail.com> wrote in message
> news:%23bZN4KefEHA.3888@TK2MSFTNGP09.phx.gbl...
> > I have come across a particular problem may be someone else here as also
> > encountered it.
> >
> > I have applied a FILTER condition on a table & then changed the value of
a
> > field - which is part of the Filter Expression - which causes some more
> > records to meet the filter condition and hence are desired to be
filtered
> > out.
> >
> > But I am surprised that when all the records meet the Criteria as set in
> the
> > FILTER Expression it works fine but when some records are already being
> left
> > out - coz of the FILTER Expression - and some more are added to the list
> the
> > records don't respect the filter condition.
> >
> > I am moving the Record Pointer in both the cases. After applying and/or
> > changing the Data.
> >
> > Is there any method other than to
> > 1: save the Filter,
> > 2: setting Filter Off and then
> > 3: Reapplying the Filter Condition.
> >
> > which forces the Foxpro to refresh/reapply the filter to the table.
> >
> > TIA
> > Tanveer
> >
> >
>
>

Sietse
Tue Aug 10 03:21:56 CDT 2004

Ah, So you're scanning through the filtered cursor, and you're finding
records in your cursor that don't apply to the filter because either their
value get's changed or the record is added during the process. Can't you
first create a filtered subset using a SQL-Select and use that cursor for
scanning through?

Sietse

"Tanveer H. Malik" <tanmalik@hotmail.com> wrote in message
news:uPFN9ErfEHA.2604@TK2MSFTNGP10.phx.gbl...
> I am using none of them instead I am using a scan while .. loop to iterate
> through the table after setting the pointer to BOF
>
>
> "Sietse Wijnker" <sietse.wijnker@ATsw-software.nl> wrote in message
> news:ewiFc6gfEHA.1972@TK2MSFTNGP09.phx.gbl...
> > Hi Tanveer,
> > If you're using a grid, you can just call the grid's refresh method.
> > If you're using a browse, you can use the name-clause in the BROWSE
> command
> > to get an object reference to the browse (essentially a grid object) and
> the
> > call its refresh-method.
> >
> > HTH,
> > Sietse Wijnker
> >
> > "Tanveer H. Malik" <tanmalik@hotmail.com> wrote in message
> > news:%23bZN4KefEHA.3888@TK2MSFTNGP09.phx.gbl...
> > > I have come across a particular problem may be someone else here as
also
> > > encountered it.
> > >
> > > I have applied a FILTER condition on a table & then changed the value
of
> a
> > > field - which is part of the Filter Expression - which causes some
more
> > > records to meet the filter condition and hence are desired to be
> filtered
> > > out.
> > >
> > > But I am surprised that when all the records meet the Criteria as set
in
> > the
> > > FILTER Expression it works fine but when some records are already
being
> > left
> > > out - coz of the FILTER Expression - and some more are added to the
list
> > the
> > > records don't respect the filter condition.
> > >
> > > I am moving the Record Pointer in both the cases. After applying
and/or
> > > changing the Data.
> > >
> > > Is there any method other than to
> > > 1: save the Filter,
> > > 2: setting Filter Off and then
> > > 3: Reapplying the Filter Condition.
> > >
> > > which forces the Foxpro to refresh/reapply the filter to the table.
> > >
> > > TIA
> > > Tanveer
> > >
> > >
> >
> >
>
>