At 03:46 PM 12/11/2003 +0200, you wrote:

>I have created a database for my application. I want to distribute my
>database on a CD. The database is not copied onto the harddisk. The
>database must remain Read-Only. When the user uses my application he may
>search. I want to create a View when he searches for the first time , and
>then just search again on the view for the second search. Basically I want
>to subquery through View's. The views will be destroyed when the user quits
>the application. Can I however create a view , only for that session , if
>the database is read-only ?

No. The metadata for database objects are stored in database tables. You
literally can only READ a read-only database. You could have your
application query database tables into memory structures at run-time,
though. Memory tables, lists, etc.

You could anticipate the structure of queries and create views encompassing
the entire table; then at run-time have your application pass parameters.

heLen