Unanswered: Passing parameter in pass through query..
Hello Forum - Can someone help me in guiding how to pass parameter to a Pass Through Query. Here is my pass-through query that works fine when user-inputs are hard coded:
Select FieldA, FieldB, FieldC, OraFunchtion(FieldD, FieldE, FieldF) as FunField
WHERE FieldA=[UserInputForFieldA] and
FieldD= (SELECT MAX(AP.APDATE) FROM TableA AP FROM TableA
WHERE AP.FieldA=[UserInputForFieldA] and
How do I run this query where user is able to input the data and backend Oracle server can display results that has a OraFunction too?
Please note that I am not master in Access Programming. So helping me w/ step-by-step approach would greatly be appreciated.
Pass Through Queries are essentially just a text string that is passed to the destination specified in the connection string. The string is not parsed - you c an pass whatever the heck you like, Access does not care. It is the destination server that parses and executes your string. It may then return a resultset that Access can then use.
So - your problem is that Oracle has no idea WTF [UserInputForColumnC] is. You must incorporate explicit values in your string.