MS Query: passing input prompt to ODBC ( RPC )

  • Thread starter Thread starter JIMC
  • Start date Start date
J

JIMC

Using MS Query I am calling an RPC using an ODBC datasource. This is
working fine.

In MS Query the syntax for calling the RPC is:

{CALL REMOTERPC (3,GETINFO,AAAAAA134)}

In this example I have hardcode the input parameter AAAAAA134.

I would like to have the user prompt for the input and pass this value
dynamically to the RPC.

Can anybody help me on this ?
 
thanks but that does not work. The RPC statement is entered into th
SQL window from MS query
 
Use the macro recorder to record some code while you manually edit the
contents of the SQL window to use a different fixed value. Then
examine the code and work out how to put a dynamic value into the SQL.
Getting user input if beyond the scope of this thread...
 
Back
Top