|
As the other person pointed out. The update of a file, from another file, was added in V4R3. oludare@ix.netcom.com on 08/02/99 12:14:09 PM Please respond to RPG400-L@midrange.com@Internet To: RPG400-L@midrange.com@Internet, MIDRANGE-L@midrange.com@Internet cc: Fax to: Subject: UPDATE IN STRSQL USING JOINED FILES How do you change value from a field with value from a field in another file using STRSQL. The two files must be join with another field for the operation.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type><BASE href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\"> <STYLE>BODY { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } UL { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } OL { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } DIR { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } MENU { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } DIV { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } DT { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } DD { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } ADDRESS { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } BLOCKQUOTE { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } PRE { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } BR { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } P { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } LI { BACKGROUND-COLOR: #ffffef; BACKGROUND-POSITION: left top; BACKGROUND-REPEAT: repeat-x; COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal } H1 { COLOR: #660000; FONT-FAMILY: "Old English Text MT", "Times New Roman"; FONT-SIZE: 65pt; FONT-WEIGHT: normal } P.msoNormal { COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal; MARGIN-BOTTOM: 0em; MARGIN-TOP: 0em } LI.msoNormal { COLOR: black; FONT-FAMILY: "Perpetua MT", "Times New Roman"; FONT-SIZE: 20pt; FONT-WEIGHT: normal; MARGIN-BOTTOM: 0em; MARGIN-TOP: 0em } </STYLE> <META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD> <BODY background=cid:01bf01bedd05¤67b2d220¤3c020a0a@pulse.com bgColor=beige topMargin=150>How do you change value from a field with value from a field in another file using STRSQL. The two files must be join with another field for the operation.</BODY></HTML>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.