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!!!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement