Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Using Parametrized Views
Hi.
I have in my DBC set up a parameterised view with a variable as follows:
?lnMyVar = Myfield_PK (in the filter section)
I then want to requery the view on a form and I do the following:
Select MyView
lnMyVar= MyAlias.MYPK
Requery()
Thisform.refresh()
Now this all works fine , but the only way I can get it to work is if I declare lnMyVar as a Public Variable. (Otherwise the minute the form is run, it comes up with a message asking me for a value to put into lnMyVar)
Is there a better way of handling this, without haviong to declare the variable as public ?
Regards,
Gerard
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