Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameterized SQL Statements
I wanted to create a parameter in OLE DB Query. My current command text is:
SELECT Orders.OrderID FROM Northwind.dbo.Orders WHERE Orders.OrderID = ? However this brings up the error "No value given for one or more required parameters." Which is very true, but I thought it should prompt for that value (according to http://msdn.microsoft.com/en-us/library/ms141696.aspx). If I replace the "?" with an actual number, the query executes fine and I get back the results. Can anyone help on what I'm doing wrong with the syntax to get the paramater query to work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If statements | Excel Discussion (Misc queries) | |||
Parameterized SQL Query | Excel Discussion (Misc queries) | |||
Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) |