Send variables to a passthrough query

[Steven K]

Hello,

I have a passthrough query that calls data from a SQL Server database:

exec sp_web_WinLoss 'RegionData', 'win', '10-01-03', '04-30-04'

Is there any way to pull the parameters from a form, like the following:

exec sp_web_WinLoss 'RegionData', 'win', @myvariable2, @myvariable2

and then open that query?

 

[Ragnar Midtskogen]

You can use an ADO Command object to do that. Look up help for the Command
object.

Ragnar