In article <[log in to unmask]>, Kim Borgman
<[log in to unmask]> writes
>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 ? Yes I had opened the DB in mode1...
>
From memory I'm fairly certain you cant do an update in query after a
join, as after a join what you are working with is an internal query
table, rather than with pointers to the actual records.
However I suspect someone may prove me wrong :-)
Alan
--
Alan Yeo
[log in to unmask] Just because you're paranoid
Phone +44 1684 291710 it doesn't mean someone isn't!.
Fax +44 1684 291712
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *