RE: SQL Update

["Leland, David" <dleland@xxxxxxxxxx>]

That also worked.  What about where KEYFLD in FILE1 is no longer unique.
KEYFLD in FILE2 still is though.  I get the same "Null values are not
allowed in column FIELD1 in table FILE in LIBRARY" message again.

Thanks,
Dave

> ----------
> From:         Pete Hall[SMTP:pbhall@execpc.com]
> Reply To:     MIDRANGE-L@midrange.com
> Sent:         Saturday, June 12, 1999 9:14 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: SQL Update
> 
> At 12:23 06/11/1999 , David Leland wrote:
> >At version 4.3 we can now update a field in one file with the value
> of a
> >field in a different file.  I've seen examples and gone through the
> >manuals.  I can get it to work a little, but I keep ending up with
> the
> >following:
> >
> >Null values are not allowed in column FIELD1 in table FILE in
> LIBRARY.
> >
> >My SQL statement is as follows:
> >UPDATE LIBRARY/FILE A SET FIELD1 = (SELECT FIELD2 FROM LIBRARY/FILE2
> B
> >WHERE A.KEYFLD = B.KEYFLD)
> 
> Try this: 
> UPDATE LIBRARY/FILE A SET FIELD1 = 
> (SELECT FIELD2 FROM LIBRARY/FILE2 B WHERE A.KEYFLD = B.KEYFLD)
> WHERE A.KEYFLD IN (SELECT KEYFLD FROM LYBRARY/FILE2)
> 
> Pete Hall
> pbhall@execpc.com
> http://www.execpc.com/~pbhall
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---