View Single Post
Old November 27th, 2008, 11:49 PM
chobo2 chobo2 is offline
Friend of Wrox
Join Date: Sep 2007
Location: , , .
Posts: 169
Thanks: 7
Thanked 2 Times in 2 Posts
Default How do I make a placeholder parameter for


I usually use Sql server 2005 but I have to right now have to use access 2007 and I am wondering how do I make a parameter placeholder?

Like if this was sql server 2005 I would do something like this

SELECT StudentID, FirstName, LastName
FROM Students
WHERE (StudentID = '@StudentID')

* I am making this with a typed dataset(dataset.xsd file). So I usually would type that into the design builder and then execute it. Once I hit the execute the button it would then popup and ask to put some data in as the parameter.

When I try the exact same statement with an access 2007 db it just runs the statement and seems to ignore that it's a placeholder parameter and tries to use it as part of the where clause so I always get no results.