No... I think you mean this?
TRANS('PRODUCT', PRD.ID.90, '12', 'V'); @1<1.1>
I also tried with 1,1 and no cigar...
On Mon, Sep 12, 2011 at 4:24 PM, Caryl Lange <cla...@hme.com> wrote:
> 1.1 instead?
>
> Avante 9.1.7a/SB+ on Windows, tasty GUI flavored
>
> Best Regards,
> Caryl Lange
> Applications Development Manager
> HME
> 14110 Stowe Drive
> Poway, California 92064
> phone: (858) 646-8806
> cla...@hme.com
> Visit our website: www.hme.com
>
> Please consider the environment before printing this email
>
> CONFIDENTIALITY NOTICE: E-mail may contain proprietary confidential
> information that is legally privileged. Do not read this e-mail if you are
> not the intended recipient.
> This e-mail transmission, and any documents, files or previous e-mail
> messages attached to it may contain proprietary information, trade secrets,
> and/or other confidential information that is legally privileged. If you are
> not the intended recipient, or a person responsible for delivering it to the
> intended recipient, you are hereby notified that any disclosure, copying,
> distribution or use of any of the information contained in or attached to
> this transmission is STRICTLY PROHIBITED. If you have received this
> transmission in error, please immediately notify the original sender by
> return E-mail, and destroy the original transmission and its attachments
> without reading or saving in any manner. Thank you.
>
>
> -----Original Message-----
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
> Sent: Monday, September 12, 2011 1:23 PM
> To: U2 Users List
> Subject: Re: [U2] I-type Subvalue question
>
> I get this still...
>
> DOR 610-434 0.78
> 0.00
> 0.00
> 0.00
> 0.53
>
> That is a number 1 in the @1 right?
>
> On Mon, Sep 12, 2011 at 4:18 PM, George Gallen <ggal...@wyanokegroup.com
> >wrote:
>
> > What happens if you do:
> >
> > TRANS('PRODUCT',PRD.ID.90,'12','V') ; @1<1,1>
> > Mr2
> > Cost
> > 10R
> > S
> >
> >
> >
> > -----Original Message-----
> > From: u2-users-boun...@listserver.u2ug.org [mailto:
> > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
> > Sent: Monday, September 12, 2011 4:11 PM
> > To: U2 Users List
> > Subject: [U2] I-type Subvalue question
> >
> > Lets say I need to translate over to a file and get the cost of a
> product.
> >
> > However, the cost of the product is multivalued.
> >
> > How can I do this with an I-type and NOT grab all of the multi values?
> >
> > I
> > TRANS('PRODUCT', PRD.ID.90, '12', 'V')
> > MR2
> > Cost
> > 10R
> > S
> >
> > So in attribute 12 of the PRODUCT file, I just need <12,1>.
> >
> > Do I need two I-types, or will TRANS() let me do this?
> >
> > The friendly manual seems to be failing me...
> >
> > --
> > John Thompson
> > _______________________________________________
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > _______________________________________________
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
>
>
>
> --
> John Thompson
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
--
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
