Re: parameterised SQL views

>> I'm having difficulty implementing my design (for a client-server
application) in (MS Jet) SQL, and beginning to wonder whether I'm facing a limitation of SQL generally. I need to pass parameters into some stored SQL views ("queries" in Jet jargon), for use in place of constants in WHERE conditions. <<

VIEWS do not have parameters in SQL; never have, never will. Jet is nowhere near SQL, by the way and you are going to spend almost a year un-learning it when you move to SQL. A VIEW is a virtual table and the SQL-92 Standard says that they are to be treated as if they were a materalized table. Would you like to play with the idea of two or more copies of the same VIEW with different parmeters? The whole conceptual model falls apart.

Stored Procedures have parameters. Each call to a procedure is not done inside a query where you would have those scoping problems.

--CELKO--
Joe Celko, SQL and Database Consultant
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be cut and pasted into Query Analyzer is appreciated.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 11 2000 - 17:36:40 CEST