Views and Functions in ADP query designer

[Guest]

When using Query Designer in an ADP application you are given three choices of the type of query you can create: !. Function query, 2. View query and 3. Stored Procedure. I have a good understanding of how and when to use a Stored Procedure but I have been unable to locate any discussion on when you should use a View query as opposed to when you should use a Function query.

Please tell me when to use one or the other and/or point me to some documentation that will.

 

[Tom Ellison]

Dear Ray:

There are things a View doesn't do. It cannot contain multiple
statements. It cannot use variables or cursors. It cannot update,
delete, or append. It does not accept parameters. If you need to do
any of these things, you'll need a Stored Procedure or write SQL code
dynamically.

However, it is generally true that you should use a View for anything
for which a View will suffice. They are very efficient for the things
they CAN do.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts