Hi!


I got several question on views

Let's say I have defined my view like this:

create sql view myview as select * from DB!Father ;
where id<=?cid;
union all;
select * from DB!sons where id=?cId

it works, but I want to show the records ordered by the field Id.
How can I do that?

How can I modify or establish certain settings or features for
this view when I can't open the view designer?

In case I want to insert records by this view, how can I define in
what table I am inserting the data? how do you handle these cases?

Thanks in advance