Subject Re: [firebird-support] Read-Only Distribution and Views
Author Helen Borrie
At 08:11 AM 13/11/2003 +0200, you wrote:
>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 ?

I'm not on this wavelength at all. :(

Firebird isn't an application development tool, its a relational database
management system. It has an application programming interface. People
write applications through this interface.

About views: if you create a view, then your query tool can select
whatever it likes from that view. For example,
select * from aview
where acolumn = avalue
and bcolumn = bvalue

and such.

Would you please trim your messages?

helen