Send variables to a passthrough query

  • Thread starter Thread starter Steven K
  • Start date Start date
S

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?
 
You can use an ADO Command object to do that. Look up help for the Command
object.

Ragnar
 
Back
Top