- Forum
- T24 Technical Discussions
- T24 Administration
- OPERATION Field in Enquiry - Get Field Value from another Table
×
Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…
OPERATION Field in Enquiry - Get Field Value from another Table
- McLanJohn
- Topic Author
- Offline
- New Member
Less
More
- Posts: 11
- Thank you received: 0
3 years 8 hours ago #23566
by McLanJohn
OPERATION Field in Enquiry - Get Field Value from another Table was created by McLanJohn
Hello all,
In a NOFILE enquiry I extracted the value of a field called STATUS from X local table, however I do not intend to display the STATUS as is but rather its Description as specified in Y core table. How can I use the OPERATION field in ENQUIRY to fetch this value from Y core table and display it.
Thank you for taking time to answer.
In a NOFILE enquiry I extracted the value of a field called STATUS from X local table, however I do not intend to display the STATUS as is but rather its Description as specified in Y core table. How can I use the OPERATION field in ENQUIRY to fetch this value from Y core table and display it.
Thank you for taking time to answer.
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
2 years 11 months ago #23567
by VK
Cheers
VK
Replied by VK on topic OPERATION Field in Enquiry - Get Field Value from another Table
Hi
see field CONVERSION:
LINK XXX,YYY
Read file XXX using the current data as the key and return field name YYY as defined in the STANDARD.SELECTION record for XXX. Do not specify F. or company mnemonic in file name. Field Name YYY may be a data field or an I or J descriptor defined in the Standard Selection record of file XXX Note that if a multi or sub valued item is returned from a LINK conversion, the multi and sub values are converted to spaces, so the result cannot be displayed in separate lines.
see field CONVERSION:
LINK XXX,YYY
Read file XXX using the current data as the key and return field name YYY as defined in the STANDARD.SELECTION record for XXX. Do not specify F. or company mnemonic in file name. Field Name YYY may be a data field or an I or J descriptor defined in the Standard Selection record of file XXX Note that if a multi or sub valued item is returned from a LINK conversion, the multi and sub values are converted to spaces, so the result cannot be displayed in separate lines.
Cheers
VK
Please Log in or Create an account to join the conversation.
- Forum
- T24 Technical Discussions
- T24 Administration
- OPERATION Field in Enquiry - Get Field Value from another Table
Time to create page: 0.073 seconds