>>>Hi All,
>>>
>>>What do I need to put in the 'SelectCmd' property of a CursorAdapter to use a SQL View?
>>>
>>>Aloha,
>>>
>>>James
>>
>>James put by Example:
>>

>>select customer.id, customer.name from customers
>>

.
>
>Hey Vladimir,
>
>Sorry I should have been more specific. I am looking for what the syntax is to call a SQL view stored in a SQL Server database.
>
>I know that to call a stored procedure you store the following in the CursorAdapter's SelectCmd:
>

>Exec <StoredProcName>
>

>
>How do I call a view stored in my SQL database?
>
>Aloha,
>
>James


Jemes,
I never need to call View stored in my SQL.

Now I examine this in Home.

With SQL Query Analyzer this is:

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER   VIEW dbo.VIEW1 AS SELECT     dbo.Distributori.* FROM         dbo.Distributori
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO