Information générale
Catégorie:
Codage, syntaxe et commandes
>I've created a parameterized view (thanks Barbara!) to grab fields from a number of tables and use the parameter to filter out selected records into my view. (I'm using v3.0)
>
>It works fine the first time. But I can't figure out how to rerun the query to come up with new view results after I've changed the value of my parameter. Requery() was suggested but I'm getting an 'unrecognized command verb' message when I try to do that. After eading about requery(), it looks like it only works with remote SQL views and all of my data is local. Make sense?
>
>If I go into the View Designer and select Run Query after I've changed the value of the parameter, 0 records are selected. It looks like it's using my latest view results to query, not my original tables. Example: first query has the parameter acode=13000 then I need to change the parameter to acode=01010. It's not finding any records so I'm assuming it's not going back to my original tables to find acodes=01010.
>
>Help! I'm sure it's a simple function I need, but I can't find it in my documentation. (btw Barbara, thought I'd give you a little break ;^)...)
>
>Many thanks,
>
>Mandy
Hi,
I use requery() to re-execute my local views. maybe the syntax is incorrect. You must issue the command like this :
SELECT myView
=REQUERY()
Hope this help
Précédent
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