Subject | RE: [firebird-support] Views and where clauses |
---|---|
Author | Alan McDonald |
Post date | 2004-07-13T10:13:48Z |
> Thanks will look at that.if you want to update all fields (not just one table) then write an SP to
>
update those fields across many table e.g. the view might join several
tables.
Alan
> >>
> >> 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
> >
> >
> >
> >
> >
> >
> >Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004
>
> ----------
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>