At 06:48 AM 2/03/2004 +0200, you wrote:

>I thought once a view was created it could not be changed when the program
>is running.
>
>CREATE VIEW View1
>AS
>SELECT *
>FROM Accounts
>WHERE AccountantName LIKE 'Andrew%' ;
>
>But in he course of the program execution AccountantName can change to
>anything that the user cn think of. eg ("me", "max" , "tomas" ...) how do I
>cater for that ?

Well, that is not what you use views for.

But you can have a view like

create view aView (blah....


as
select ....
from ...
join ..
join..
join....
group by..


then, from your application

select whatever
from a view
where...<parameters>
order by blah...

/heLen