Question

Will QF 9 run a Look up on SQL views instead of tables

Updated March 26, 2014

asked on March 26, 2014

Having an issue when trying to configure a RealTime Lookup process and have it query and pull back information from a view not a table. When configuring the RTL it can see the view correctly so the ODBC is working correctly, however, when the process is ran the error message that is provided is "Invalid object name 'vwEmployee'". So I am not sure why it is not pulling anything back from the view.

We also tried to write a custom query and this does not produce an error, however, it also does not pull and populate any metadata either in the QF Session. Has anyone else had experience with querying the view instead of the table?

0 0

Replies

replied on March 26, 2014

Client just added this to the question:

Once I get the LookUp piece built (by manually writing the query), how do I assign the template field I want to use as the parameter for the LookUp? I’ve read that the only parameter I’m allowed to use is “?” (a question mark). When I test the query, it says “1 row affected”, which, I assume, means I’m connecting. So, where and how do I associate the template field the user will be looking at with the parameter I want to pass to the query to return the information?

0 0

replied on March 26, 2014

The error might indicate that your configuration is incorrect, but there is not enough information. Is the same Windows user configuring the session and running it? If you configure a user ODBC data source, it is tied to the Windows user logged into the machine at the time and will not work for a different one. You would want to use a System ODBC. Similar situation if the session is transfered between machines.

As for specifying parameters in custom queries, see the help file for step by step instructions

0 0

You are not allowed to follow up in this post.

Question

Question

Will QF 9 run a Look up on SQL views instead of tables

Replies

Sign in to reply to this post.