Just to add to Darren's point, for anyone who wonders WHY UniVerse lowers the results
of
a TRANS, if the TRANS() key is multivalued, it means that any multivalued targets being
accessed will align with their appropriate key (imagine a mv'ed list of suppliers being
translated onto their mv'ed addresses).
Brian
On Fri, 03 Sep 2004 16:44:06 +0930
Darren Percival <[EMAIL PROTECTED]> wrote:
>>In U2 you would again use an I-desc, with attr 2 being TRANS("FILE.NAME",
>>ID.TO.USE, "ATTR.DESIRED", "X") quotes around everything but the ID that you
>>would use to translate to the file. UV must have something similiar....<?>
>
>In answer to the question yes I would use an I-Type to TRANSlate the appropriate field
>from the second file but beware in UniVerse the TRANS does a LOWER on the returned
>field.
>
>This will result in the "multivalue" coming back with the delimiters at one level
>lower
>that expected. Depending on what you expect to use the field for this may or may not
>be
>a problem.
>
>The fix is easy enough just wrap the thing up in a RAISE.
>
>ie
>----:
>0001: I
>----:
>0002: RAISE(TRANS(FILE.NAME,F11,F22,'X'))
>----:
>0003:
>----:
>0004: Branch No
>----:
>0005: 10R
>----:
>0006: S
>----:
>0007:
>----:
>0008:
>
>
>Cheers,
>
>
> .....Darren.....
>=================================
>It is very hard to drink all day
>If one doesn't start first thing in the morning
>=================================
>-------
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
>
>________________________________________________________________________
>This email was checked by MessageLabs SkyScan before entering Microgen.
________________________________________________________________________
This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.
DISCLAIMER
This email and any attachments are confidential and may also be
privileged.
If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.
In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]
Microgen Information Management Solutions
http://www.microgen.co.uk
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
