> >I want to design a query but I want to pass parameters to the query to
be
> used as a filter.
> >
> >The parameters will be passed from an open form.
> >
> >How can this be done ?
> >
> >Anthony Griffith
>
> Create parameterized local view.
to do this in the designer or manually use ?parameter e.g.
CREAET SQL VIEW .. AS SELECT * ... WHERE field=?cond
when you will use the view you will be prompted for a value
to use this in a form set NoDataOnLoad for the view (in the DE)
and when you want to populate it give "cond" a value and then requery the
view
Arnon
Précédent
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