Re: Re[2]: SQL Update Table

Christina

At 09:46 AM 11/20/97 -0500, you wrote:
> Couldn't you create a view joining the two tables together (if like
> fields exist??) and then execute an update statement? Perhaps it is
> worth trying.

-snip-

Would that it were true. But again, maybe not. The SQL Reference manual has the rules for what makes a view read-only:

>>>>

Read-only views: A view is read-only if any of the following appear in its
definition:
- The first FROM clause identifies more than one table or view.
- The first FROM clause identifies a read-only view.
- The first SELECT clause specifies the keyword DISTINCT.
- The outer subselect contains a GROUP BY clause.
- The outer subselect contains a HAVING clause.
- The first SELECT clause contains a column function.
- The subselect contains a subquery such that the base object of the outer
subselect, and of the subquery, is the same table.

<<<<

Cheers


Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480


+--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---