At 04:57 PM 21/11/2006, Iwan Cahyadi Sugeng wrote:

>Hi, i've tried Firebird 2 new feature to try out the improvement. It
>is a great improvement i'd said, Congratulation to all the developer
>team.
>
>But i've found some feature missing and actually don't know if someone
>else agree with me.
>
>I've tried to create a view from a select query with union, it works
>greater than before since it support union selection to create view.
>But FB2 still need to define the column name for the view if the
>select query did not select all field.
>
>What i want is:
>
>CREATE VIEW UJIVIEW2 AS
>SELECT ID,19 KODE FROM UJI
>UNION
>SELECT ID, KODE FROM UJI2;
>
>and will show view with columns:
>ID, KODE

The improvements in views do not include breaking the syntax rules
for defining views!

Just as one thing (of many) to think about: according to your secret
desire, consider what an SQL engine might do if the column names in
the contributing SELECTs in the UNION do not match...which is
perfectly valid for unions....

This message slipped through to this list by mistake (mine). It
should have been rejected. This list is *not* for technical
questions. In future, would you please direct your support questions
to the firebird-support list. Thanks.

Helen (wearing Mail Admin hat)