Data commands and errors on a cluster line

[Joe Boyle]

you would normally exclude the problem by the use of lookups on the field
statements as in the twin segment key fields below. This ensures that all
entries are unique prior to the update command. 


field order_no of order_detail required nochange &
lookup on orders

field order_line_no of order_lines required nochange &
lookup noton order_lines &
via order_no, order_line_no &
using order_no of order_detail, order_line_no of order_detail


Unfortunately, this won't exclude the possibility that two users are
independently using the same key values; which is where getnextunique key
routines come into play.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
roger32909 at bellsouth.net
Sent: 22 December 2005 01:20
To: powerh-l at lists.sowder.com
Subject: Data commands and errors on a cluster line

OpenVMS V8.2  PH (7.10.G1)

 Have several screens with a DETAIL file cluster of records occurring 6
times.
There are nine fields on a line.  When the prompt is at the first record in
the line, if a user wishes to
return to action, the user enters // and the prompt returns nicely to the
action field.

However, when the user enters data in the subsequent fields that triggers an
error (usually a duplicate key error), there is currently no way to
gracefully exit that cluster line.  To be sure, the PF4 key will return the
prompt to Action, but there may be dozens of lines above that will be lost.

Anyone know of a command or technique to return to action from say line 6
without losing first five lines of data?

 


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.