****Kim Wrote:
>Did a query multifind search last nite, and wanted to update
>one of the fields. The query update told me "record has not
>yet been found". When I had obviously found 200+. Yes I did
>a join first, and I could report on the field/records. Any thoughts?
Several Query commands only work after a FIND. One method that would
work is to build a report that you could then execute to to the update.
Most of the time the the MUltifind will return records with unique key
values. These values can be used to FIND the desired records individually
and update the desired field or fields. Below is an example of a REPORT
that generates a QUERY command script. Note the use of of triple " to
get a single " into the generated command line.
Cordially,
Mike Hornsby
CoFounder
Beechglen Development Inc. (beechglen.com)
513-922-0509
[log in to unmask]
JOIN set1.item3 TO set2.item3
MU xyz is 12345
:purge xeqfile
:build xeqfile;rec=-80,,f,ascii
:file qslist=xeqfile,old;dev=disc
out=lp
report nopage
d1,"f key-item14 = """,16
d1,key-item14,24,e1
e1,"xxxxxxxx"
d1,"""",25
d2,"replace abc =""",14
d2,"98765""",20
d2,";end",24
end
out=term
xeq xeqfile
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|