Parameter view

[Danilo Popoviæ]

Hi everybody,

this view runs just fine but when I try to save it I have an error message:
ODBC error: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect of
syntax error. Where is the problem? I use questionmark because I need
unnamed parameter veiw.

select ProductID, NameOfProduct from dbo.Products where ProductID < ?

Thank you in advance,

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
Croatia

[Simon Hayes]

"Danilo Popoviæ" <da************@trgostil.hr> wrote in message
news:bj**********@sunce.iskon.hr...

Hi everybody,

this view runs just fine but when I try to save it I have an error message: ODBC error: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect of
syntax error. Where is the problem? I use questionmark because I need
unnamed parameter veiw.

select ProductID, NameOfProduct from dbo.Products where ProductID < ?

Thank you in advance,

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
Croatia

You can't use parameters with a view. If you have MSSQL2000, then you could
use a table-valued function:

create function dbo.GetProducts (@ProductID int)
returns table
as
return (select ProductID, NameOfProduct from dbo.Products where ProductID <
@ProductID)

select * from dbo.GetProducts(5)

Otherwise, you can use a stored procedure.

Simon

[Danilo Popoviæ]

Thank you. ;-)

Reagards,

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
"Simon Hayes" <sq*@hayes.ch> je napisao u poruci interesnoj
grupi:3f********@news.bluewin.ch...

"Danilo Popoviæ" <da************@trgostil.hr> wrote in message
news:bj**********@sunce.iskon.hr...

Hi everybody,

this view runs just fine but when I try to save it I have an error message:

ODBC error: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect of
syntax error. Where is the problem? I use questionmark because I need
unnamed parameter veiw.

select ProductID, NameOfProduct from dbo.Products where ProductID < ?

Thank you in advance,

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
Croatia

You can't use parameters with a view. If you have MSSQL2000, then you

could use a table-valued function:

create function dbo.GetProducts (@ProductID int)
returns table
as
return (select ProductID, NameOfProduct from dbo.Products where ProductID < @ProductID)

select * from dbo.GetProducts(5)

Otherwise, you can use a stored procedure.

Simon

[Arun Marathe [MSFT]]

And what Simon showed you is known as
"inline user-defined function". They give
you a functionality similar to parameterized
views. (Parameterized views are not
allowed in SQL Server 2000.)
--
Arun Marathe
Program Manager
SQL Server Query Processor
Microsoft Corporation

Disclaimers:
(1) This posting is provided "AS IS" with no warranties, and confers no
rights.
(2) Use of included script samples are subject to the terms specified at:
http://www.microsoft.com/info/cpyright.htm

"Danilo Popoviæ" <da************@trgostil.hr> wrote in message
news:bj**********@sunce.iskon.hr...

Thank you. ;-)

Reagards,

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
"Simon Hayes" <sq*@hayes.ch> je napisao u poruci interesnoj
grupi:3f********@news.bluewin.ch...

"Danilo Popoviæ" <da************@trgostil.hr> wrote in message
news:bj**********@sunce.iskon.hr...

Hi everybody,

this view runs just fine but when I try to save it I have an error message:

ODBC error: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect of syntax error. Where is the problem? I use questionmark because I need
unnamed parameter veiw.

select ProductID, NameOfProduct from dbo.Products where ProductID < ?

Thank you in advance,

Danilo Popoviæ, B. Sc.
Trgostil d.d. - IC
Toplièka 16
49240 Donja Stubica
Croatia

You can't use parameters with a view. If you have MSSQL2000, then you

could

use a table-valued function:

create function dbo.GetProducts (@ProductID int)
returns table
as
return (select ProductID, NameOfProduct from dbo.Products where

ProductID <

@ProductID)

select * from dbo.GetProducts(5)

Otherwise, you can use a stored procedure.

Simon