HP3000-L Archives

October 2004, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Sender:
HP-3000 Systems Discussion <[log in to unmask]>
Subject:
Re: Query - multifind - update
From:
Alan Yeo <[log in to unmask]>
Date:
Fri, 15 Oct 2004 09:31:57 -0500
Content-type:
text/plain
Reply-To:
Alan Yeo <[log in to unmask]>
Parts/Attachments:
text/plain (31 lines) 
 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 *

ATOM RSS1 RSS2