×
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
Less
More
- Posts: 3
- Thank you received: 0
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
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
- Offline
- Platinum Member
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
3 years 7 months ago #22959
by VK
Cheers
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.
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
Less
More
- Posts: 3
- Thank you received: 0
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
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
- Offline
- Platinum Member
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
3 years 7 months ago #22964
by VK
Cheers
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