T24: To fetch a value in a File Enquiry

[Sridhar]

Hello,
          How to fetch value from another file in a File enquiry? For eg, I need a header value to be obtained from PD record but
it is a file enquiry fetching values from LD record.

Is there any conversion routine that is needed? If so, can anyone tell me where it has to be attached to?


Thanks in advance,
Raadha

[Ram]

Hi,

 Add a field in enquiry for header . use conversion routine to fetch PD value and display as header using arrtibs --> header property

Regards,

Ram

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[Mohankumar Balasubramaniam]

You can achive it in setup itself. no need to go for conversion routines.
append string PD with LD id, and use LINK(L) operation in conversion to get the value of field from PD.

suntax : LINK XXX,YYY
desc    :  Read file XXX using the current data as the key and return
              field name YYY as defined in the STANDARD.SELECTION record
              for XXX.

Regards,
Mohan

[Sridhar]

Hi,

         Can you tell how the conversion will exactly happen? I have the LD id as CONTRACT.ID and is available in the standard selection.
So, I gave ( S CONTRACT.ID )in Operation field and gave PD O/S AMOUNT: in the FIELD.NAME field.
Also, attached a conversion routine to pick up the Total outstanding amount field from the PD record.
What actually happended, is that the outstanding amount value got displayed in the header and the label did not get displayed.

How to get this done without conversion routine attached.?? I mean, how to achieve it through the setup?

In conversion field what are the manipulations to be made for reading PD record by appending “PD” with LD id and then reading the PD record with the outstanding amount field?

Thanks in advance,
Sridhar

On Tue, Jul 20, 2010 at 12:32 AM, Ram <ram.c...@gmail.com> wrote:

[JOSE L MARTINEZ-AVIAL]

You need to get create a field with the PD id, and then do a conversion like this:

L PD.PAYMENT.DUE,PAYMENT.AMOUNT

Hope it helps
JL

2010/7/21 Sridhar <chubb...@gmail.com>

[Sridhar]

Hi,
       Thanks for your reply and its working fine now. But, is any routine required for displaying the field value in decimals. For eg, my output is fetched as 55000.000. I need it to be displyed as 55,000.00. How to achieve this??
 

Thanks and Regards,
Sridhar

[JOSE L MARTINEZ-AVIAL]

You can use the following mask
R2,

That will write the value with two decimals, and using a comma as a thousands separator.

2010/7/22 JOSE L MARTINEZ-AVIAL <jlm...@gmail.com>

You can setup a format string.

2010/7/22 Sridhar <chubb...@gmail.com>

[JOSE L MARTINEZ-AVIAL]

You can setup a format string.

2010/7/22 Sridhar <chubb...@gmail.com>

Hi,

[Mohankumar Balasubramaniam]

attach another conversion routine and use FMT function of jbase to format it.
 eg., FMT(AMOUNT,"R%2")
Regards,
Mohan