MS Query: passing input prompt to ODBC ( RPC )

[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 ?

 

[Dick Kusleika]

JIMC

I can't make heads or tails of this, but it looks like you can use a ? in
place of your literal. See here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_odbcht10_7t2s.asp

 

[JIMC]

thanks but that does not work. The RPC statement is entered into th
SQL window from MS query

 

[onedaywhen]

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...