Required Entry

Deskin, Bob Bob.Deskin@Cognos.COM
Thu, 16 Sep 1999 06:36:00 -0400


If I understand this correctly, you'll be doing a retrieval and displaying
what you found. Some fields won't have a value. You ant to go through a
change or modify process such that the user must enter vaues in certain
fields.

This sounds like it must be done procedurally. If you want to automatically
go into the change process, I suggest using AUTOMODIFY or a PUSH MODIFY in
the POSTFIND if it has to be conditional. I wouldn't  suggest panel
processing so you may need to write your own MODIFY procedure. Within the
MODIFY you could conditionally prompt as required. To ensure the user enters
a value, you'd have to test the size of FIELDTEXT in the INPUT procedure.
The REQUIRED option only applies to entry of a new record. Since you only
want to force something if there's no value already there, you'll have to
test that as well, as in (for relational NULL columns)

IF item IS NULL and 0 = SIZE(FIELDTEXT)
  THEN ERROR "A value is required."

For nonNULL values, you could use any appropriate test such as testing for 0
or spaces. If you want to force an edit of the existing value even if the
user enters nothing, do the following

ACCEPT field
IF NOT PROMPTOK 
  THEN EDIT field

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

> ----------
> From: 	Nick Tippler[SMTP:NT204@cus.cam.ac.uk]
> Sent: 	September 16, 1999 1:07 PM
> To: 	powerh-l@lists.swau.edu
> Subject: 	Required Entry
> 
> Morning All
> 
> I have a Quick screen that reads primary and secondary records and
> displays the fields I want to populate or change.  Some fields will be
> populated, others null, depending on previous actions.
> 
> How can I make it go through all the fields and require entry for any
> missing data while still honouring the EDIT requirements?  I've tried
> PANEL, BLOCK TRANSFER and PROMPT in various combinations, but none does
> what I want.  I'm running 8.13D1 on HP-UX D10.20.
> 
> Regards
>  
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> +
> + Nick Tippler                                  nt204@cam.ac.uk
> + Registrar, Faculty of Education,          tel +44 1223 507145
> +            University of Cambridge,       fax +44 1223 507140
> +            Homerton College,
> +            Cambridge CB2 2PH
> +
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.