Hello,
Can anybody tell me, if there is a limit to create multitable view
making union select.
I have about 100 tables with same structure.
Every 10 of them representing one location, so I'm using view:
create view VIE1 ([Fields])
as
select [fields] from Table1
union all
select [fields] from Table2
etc...... next tables

create view VIE2 ([Fields])
as
select [fields] from Table11
union all
select [fields] from Table12
etc...... next tables


At the end I wanna make global view

create view ALLTABL ([Fields])
as
select [fields] from VIE1
union all
select [fields] from VIE2
union all
etc.....

And I see limitation, about 6 views I can connect and make one
global view. When I add next view - I can't retrieve any data.
On linux isql I see error - core dumped - isql crashes.
I am using FB 1.5.2 but on 1.5.1 problem was the same.

Is there limitation or can I do something?
How You can make one view from 100 vievs from 100 tables each? It
isn't possible?
Thanks for any answer (sorry for my english)

Wojtek