× 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...

Fetching Data from a file to T24

  • Pontien Misago
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 10 months ago #23700 by Pontien Misago
Fetching Data from a file to T24 was created by Pontien Misago
Hi everyone: I just need a quick help on the followin:

Suppose that i have the following array: R.REC = PETER@FMISIDOR@FMRITA@VMKETHIA@FM@OSCAR@SMDAN@SMDAVID@FMZACHARIE
What can be a program to retrieve to my local table called RPT.ENQ, FIELD 3, FIELD 5 AND FIELD 7 and display them to the user?

Kindly assist. Thanks

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
1 year 10 months ago #23701 by VK
Replied by VK on topic Fetching Data from a file to T24
Hi
not sure why you mentioned "from file" but refer to jBC array.

All depends on the type of your local table. If it's "L" you can just WRITE to it. If it's "H" or "U" I'd suggest to use OFS.

To display fields to user use a VERSION.
 

Cheers
VK

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

  • Pontien Misago
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 10 months ago #23702 by Pontien Misago
Replied by Pontien Misago on topic Fetching Data from a file to T24
Thanks a lot for the answer. The type is H. I just needed you to assist with the codes of the program to write to the table(or any other t24 table) and i will go through them i hope i will understand how it works.

Thanks again

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
1 year 10 months ago #23703 by VK
Replied by VK on topic Fetching Data from a file to T24
Hi
"generic" code to write to a table is: OPEN table, then WRITE :))

But, again, for H type WRITE isn't a proper solution... Do you know OFS message structure? If not - refer to Temenos docs. Create OFS message instead of your array, then  use (recommended) CALL OFS.POST.MESSAGE - and the tSA service OFS.MESSAGE.SERVICE will do the rest.

Cheers
VK
The following user(s) said Thank You: Pontien Misago

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

Time to create page: 0.105 seconds