Re: Techniques for variable field types in a subfile

Reading Mark's original message, he wants to be able to input as well as
display the different values.  Most of the replies are perfectly valid for
output only, but fail to address the input needs.

Buck suggested identifying the input type based on the first column -- I
would suggest a hidden field.  Also, validating for valid date or numeric
information is relatively easy with the TEST and TESTN opcodes.

Of course, testing for numeric data if the field contains currency
formatting is tricky.  This can be worked around by writing a small routine
to strip the currency symbols and commas, or if you want to get fancier, a
little finite state machine to validate the entered value.

--
Paul

----- Original Message -----
From: david.vann <david.vann@tinyworld.co.uk>
To: <RPG400-L@midrange.com>
Sent: Thursday, August 10, 2000 9:01 AM
Subject: Re: Techniques for variable field types in a subfile


> The simple way of doing this is to use a character field and load whatever
> data in the program before you write to the subfile.  Otherwise, using a
> Single-Page subfile only, you can condition fields for display when
EXFMTing
> the subfile control.
>
>
> ----- Original Message -----
> From: Mark Drazic <Mark.Drazic@Omniumww.com>
> To: <RPG400-L@midrange.com>
> Sent: Wednesday, August 09, 2000 8:32 PM
> Subject: Techniques for variable field types in a subfile
>
>
> > We currently have a requirement to display/edit variable field types in
a
> > subfile list, for example:
> >
> > Description             Value
> > Payment Amount          $99,999.99 <------- Numeric field
> > Payment Date            01/01/2000 <------- Date Field
> > Payment Status              ACTIVE <------- Text Field
> >
> > Obviously, one can Display/Hide/Protect different columns in a subfile
> list,
> > but this has its technical restrictions and also objections from the
user
> > community.  The intent here, is to use ONE column in the subfile for
> fields
> > defined with different types.  We know this must be possible, because
> > applications such as DBU & PFE use a similiar technique when displaying
> > fields from database files.  Any suggestions would be greatly
appreciated.
> >
> > Thank you.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---