Re: Multiple table inserts

Yes, in the simple case, as long as the view is a "key preserved" view, this works. But, you can also create non-key-preserved views and then write instead-of triggers to do insert/update/delete processing on the underlying tables when those DML operations are performed on the view.

Steve McDaniels wrote:
>
> I'm not sure, but I seem to remember reading about updating using views
> as long as all of the relevant keys are present in the view.
>
> "Steve ." <syarbrou_at_nospam.enteract.com> wrote in message
> news:3os6usg19tk1a386p7etok6jsdjqo5d1lh_at_4ax.com...
> > In classes and in use, I've never seen an insert statement that
> > inserted into multiple tables. I can select from multiple tables, but
> > have never seen a multiple table insert. Do you need to insert data
> > into each table one at a time, or is there a way to do it like a
> > select on multiple tables? Thanks.
> >
> > Steve
> >
> > Newsgroup replies preferred. Remove nospam when replying thru email.
Received on Wed Oct 11 2000 - 12:39:17 CDT