passing parameters to stored procedure

[Machiaveli]

Hello,

I've a form with a listbox where i want to pass the value of the listbox to the pass-through-query which then executes an stored procedure with an parameter.

The problem is that i can make it work. I've done the following in the pass-through-query:

exec usp_test [forms]![frmTest]![lstBox]

Is this correct?

 

[SQLBill]

Nope, SQL Server doesn't recognize that format. In SQL Server, it's:

exec usp_test param1, param2

-SQLBill

 

[Machiaveli]

so how should i do it

 

[tlbroadbent]

Check the following:

http://support.microsoft.com/?kbid=232493

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm