views and parameterized queries

Posts   
 
    
andieje
User
Posts: 28
Joined: 17-May-2006
# Posted on: 15-Jun-2006 16:42:32   

Hi

I am no database expert but i believe you can't run parameterised queries against views in sql server 2000/2005

How does llblgen pro handle this?

Thanks amdrea

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39928
Joined: 17-Aug-2003
# Posted on: 15-Jun-2006 17:20:44   

of course you can run parameterized queries against views in sqlserver 2000/2005. simple_smile A view is for a SELECT statement equal to a table as in: the view referenced in a SELECT statement's FROM clause is expanded in-place, at least in the final algebra statements send to the lower engine of sqlserver.

Frans Bouma | Lead developer LLBLGen Pro