MySQL Forums
Forum List  »  InnoDB

pass a parameter to query from access
Posted by: Patrick Locke
Date: August 11, 2008 11:13AM

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.

Options: ReplyQuote


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.