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

Regarding local application(templates)

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago #14039 by richard
In Templates I need to get a field values in dropdown from an T24 application I tried to do it through ID.CHECKFILE="customer" so it takes values of customer application but not displaying the customer.id in dropdown list....
So can anyone help it out

Best Regards,

Think green – keep this on the screen

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
10 years 11 months ago #14041 by jpb
Replied by jpb on topic Regarding local application(templates)
2.3.8
CHECKFILE Array
This array is a dimensioned array that defines file look-ups to be performed when data is input. The corresponding variable for the id is ID.CHECKFILE. For new applications, the API Field.setCheckFile should be used, and the information here is for reference to older applications built before the new APIs were available. As such, DO NOT use the CHECKFILE array for new applications.
The check file processing will validate the input as having an existing record on the file and will also retrieve the specified field of that record which is then displayed as enrichment next to the entered field. The elements of the check file table are a dynamic array that is set up as follows:
Field 1
The application name of the file to be checked, e.g. CUSTOMER.
Field 2
The number of the field to be returned as enrichment or to be used as the id for the next file read. This MUST be a file name defined in the corresponding file layout for the check file.
Field 3
This field is used to define 4 optional parameters. These are separated by '.' and should be assigned as follows:
Subfields 1, 2 and 3
Null. These subfields are not used.
Subfield 4
'D' The id is date associated and the record with the most recent date should be used. The date is in YYYYMMDD format.
'YM' As for 'D' but the date is in YYYYMM format.
null =No date used.
Example
To encourage re-use, check file definitions for tables should be defined in the initialise section of the .FIELDS and then referenced later.
CHK.ACCOUNT = "ACCOUNT": FM : AC.SHORT.TITLE: FM :"L"
CHECKFILE(Z) = CHK.ACCOUNT
The following user(s) said Thank You: richard

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

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago #14044 by richard
Replied by richard on topic Regarding local application(templates)
Thanks for ur reply
But my requirment is the new application should accept an another specified t24 applications ID
as its ID (local new application ID) and
all ID's of specified t24 applications ID should come in drop down so that user can select from it.

ex:local application is FT.count Specified application is FT
local application ID is should be ID of FT & a list should com in dropdown....

Best Regards,

Think green – keep this on the screen

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
10 years 11 months ago - 10 years 11 months ago #14045 by jpb
Replied by jpb on topic Regarding local application(templates)
This is what it does :

Z += 1 ; F(Z) = "XX.SOURCE" ; N(Z) = "35.." ; T(Z) = "A" ; CHECKFILE(Z) = "CGIX.SOURCE":FM:1

results in :





For ID.CHECKFILE there can't be a drilldown as the ... will show existing records in the application, here the checkfile is only for validation.
Attachments:
Last edit: 10 years 11 months ago by jpb.

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

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 11 months ago - 10 years 11 months ago #14047 by richard
Replied by richard on topic Regarding local application(templates)
I got that one but I need the @ID of local application should be the main T24 application and a list to come in dropdown list as shown in attachments

Best Regards,

Think green – keep this on the screen
Last edit: 10 years 11 months ago by richard.

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
10 years 11 months ago #14054 by jpb
Replied by jpb on topic Regarding local application(templates)
As mentioned it won't work for ID.
But maybe you can use an ENQUIRY to list the FTs and then have a drilldown to create the record in your local app?

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

More
8 months 4 days ago #24275 by Mandiebon
Replied by Mandiebon on topic Regarding local application(templates)
Hello,

Can you please share an example of how to use the API Field.setCheckFile for new applications when you want to define lookups for the ID of the local table being created?

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
8 months 1 day ago #24276 by VK
Hi
just set ID.CHECKFILE.
 

Cheers
VK

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

Time to create page: 0.131 seconds