× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Data formatting in file enquiry

  • Dharrani
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 7 months ago #22957 by Dharrani
Data formatting in file enquiry was created by Dharrani
Hi,
I have created a file enquiry . It will display SAM ID, Customer ID and Account numbers from Customer.Account application. I have attached a conversion routine which is as follows
SUBROUTINE TEST.RTN
$INSERT I_COMMON
$INSERT I_EQUATE
$INSERT I_ENQUIRY.COMMON
*OPF FUNCTIONS**
Y.ID = O.DATA
CALL F.READ(FN.CUSTOMER.ACCOUNT,Y.ID,R.CUSTOMER.ACCOUNY,F.CUSTOMER.ACCOUNT.ERR)

CONVERT FM TO VM IN R.CUSTOMER.ACCOUNT
VM.COUNT = DCOUNT (R.CUSTOMER.ACCOUNT,VM)
O.DATA = R.CUSTOMER.ACCOUNT

RETURN
END

In browser,
Field name : account
Operations : CUSTOMER.NUMBER
columns : 3
Length mask
Conversion : @ TEST.RTN
Conversion : V 1

Output :
But in output only the first account number is getting repeated.other values are not displayed. Kindly provide your suggestions

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
3 years 7 months ago #22959 by VK
Replied by VK on topic Data formatting in file enquiry
Hi

Conversion : V 1

IIRC it means "value 1"? Try to remove it and see again.

Cheers
VK

Please Log in or Create an account to join the conversation.

  • Dharrani
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 7 months ago #22961 by Dharrani
Replied by Dharrani on topic Data formatting in file enquiry
Hi VK,
If I remove that, all the values are getting displayed in the same row separated by space.
For ex: 1 2 3
But expected format is
1
2
3

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
More
3 years 7 months ago #22964 by VK
Replied by VK on topic Data formatting in file enquiry
To be honest I never succeeded to show multi-valued result of a routine in enquiry. Long time ago I decided to totally switch to NOFILE enq where all the grid is populated in the routine attached to SS and enquiry itself just shows the data.

Cheers
VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.102 seconds