Re: SQL Update

[Pete Hall <pbhall@xxxxxxxxxx>]

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