MS Access 2003/SQL Server 2005 - Query Parameters

C

cgwozdz

I am new to SQL Server and I'm trying to create a parameter query in the View
folder in SQL Server. I used @name as well as a ? mark for the parameter,
but I continue to get a message stating that "'Parameters' cannot be used in
this query type."

After I get the error, I am able to run the query - the parameter dialog
pops up and the result set is accurate. However, when I try to save the view,
a dialog pops up stating the I must declare the scalar variable "@name".

I click OK and receive the message "User canceled out of save dialog".....

What am I missing?

Thanks,
_____Casey G.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top