SQL-SELECT FROM a stored procedure with parameters...

[Hyko]

Hi.

I have a quite complex query which is saved as query in access. This query
already uses other queries. Now I have to add some additional conditions,
but I do not want to touch or cannot touch the saved ones. The database is
used on a webserver with .asp (VisualBasic). Now my question:

Is it possible to write an SQL-textcommand, which uses this query with
parameters as table? If so, how can I pass the parameters for the stored
procedure?

pseudocode:
SELECT supplier, transactionvolume FROM theStoredQuery (<-- This requires
params) WHERE (supplierrating="A" and suppliersize>30);

Thanks for any hints in advance.

Rgds, Hyko

 

[Michel Walsh]

Hi,


A parameter can only be used where a field value can used, so you can't
use a parameter where a query name is required, but if I read you correctly,
the query name itself is known and use, inside the query, a parameter. With
Jet, yes, just call the top most query, it sees the "embedded" parameter (or
you can add it explicitly from the menu of the query designer, under Query |
Parameter... )



Hoping it may help,
Vanderghast, Access MVP