Maybe someone can help me. I am trying to requery a view. This is the problem. I have created a view as below:

pcPendCds = '11'

lcWhere = "pendcds = "+pcPendCds+" and repaired = 0 AND valerror = 0"

create sql view myTable connection bmsdsn remote AS select * from tranhdr where &lcWhere

As you can see I have a variable pendcds "Which I use to store my code"
When the first view is create I get 67 records.

I now want to get a different set of records so I do the following.

Pendcds = '10' &&Reset for the code I want.
lcWhere = "pendcds = "+pcPendCds+" and repaired = 0 AND valerror = 0"
&& Reset my where condition to reflect the new codes.

=REQUERY() && Requery to get a different record set.

The problem is that my view still contains the last 67 records. The set should now contain 5 records with a code of '10'.

What is wrong should't my view have been updated?
HELP!!!