pass a parameter to query from access
Hello I have an access database that uses to a passthru query to mysql to update its tables.
the pass thru query looks like
select * from ('someconnection'.'somedatabase') Where FacilityCode IN ( getfaccode() )
see.. the function "getfaccode()" thats a function i have in access that is not in mysql so this query wont run.
how can i pass this as a parameter from the query that calls this one?
so i would change the passthru (qryEvents_L2) query to read like:
select * from ('someconnection'.'somedatabase') Where FacilityCode IN (@faccode)
and call it like:
SELECT qryEvents_L2.* [(@facilitycodes = getuserfacility()] INTO tblEvents
FROM qryEvents_L2
I totally made that up but, you get the idea.. i want to pass the paraters when i call that query from access.
Subject
Views
Written By
Posted
pass a parameter to query from access
3803
August 11, 2008 11:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.