Does firebird have any support for memory objects(tabls,views,cursors) ?
If not. If I use subqueries with exist statements , could that simulate views ?

View1
|--> View2
|--> View 3

Would that be equal to :

1st Select : Select Condition1
2nd Select : Select Condition2 If Exists (Condition1)
3rd Select : Select Condition3 If Exists( Select Condition2 If Exists
(Condition1) )

Could this be a possible workaround ?

At 02:16 AM 11/13/2003 +1100, you wrote:

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/