Re: 4GL 4.0 Updating Fields

You could design your 4gl program to load your flat file into a temporary table and work with that. In article <5kt9qp$kh3@cronkite.ocis.temple.edu>, david@temss2.main.temple.edu (David Tucker) wrote: >Currently, I am trying to do a "batch" update of exising records >within a table. For example if my table contains the following >records: > KEY | FIELD 1 > 1 | NO > 2 | NO > | | NO > | | NO > 100 | NO > > >I would like to read in a flat file consisting of KEY and FIELD 1 >to update FIELD 1 from NO to YES. > >i.e. > 1|YES > 2|YES > 3|YES > | > | > etc. > >Is there a utility that allows you to update? I believe that LOAD >only adds to the table. I just want to update specific fields in >existing records. > >Thank you in advance. ---------------------- Rudy Fernandes GIC, Kuwait OL 7.20, 4Gl 6.04 ----------------------