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 ?


At 11:03 PM 3/1/2004, you wrote:

>At 06:00 PM 1/03/2004 +0200, you wrote:
> >Sorry, Helen my mistake I meant View when I said Query.
> >
> >At 03:47 PM 3/1/2004, you wrote:
> > >At 01:28 PM 1/03/2004 +0200, you wrote:
> > > >The database is readonly and distributed on a CD and the search criteria
> > > >varie according to what my customers want to search for. So I can't
> create
> > > >a query.
> > >
> > >Why not?
> > >
> > > >Is there a way to order the results without an query ?
> > >
> > >There's no way to get any results without a query.
> > >
>
>Well, still - why do you think you can't have a VIEW in a read-only database?
>
>/heLen
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>