Re: Re[2]: SQL Update Table

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

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 +---