> Good day
> =\-=\=\==-\
>
> I want to know if how I understand VIEWS are correct.
>
> The view is a query stored on the server that gets run when the
> user executes it.
> if a where clause is added to the VIEW from a query as in :
>
> select * from myVIEW where ref_no >= 4599
>
> the Server will FIRST execute the View then implement the where
> clause on the views result.
>
> Otherwise only views that is on ONE table can be updated.
>
> Thanks in Advance for any responses.
>
> Yours Sincerely
>
> Johannes Pretorius
>

yes to all but you can update any field in a view as long as you construct
the update SQL yourself. You are actually updating the source table/column.
IBO components make this quite easy if you use them.
Alan