>>>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
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst