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

Routine to grab the last item in a separate table

Start
Prev
1
Next
End

PowerGirl
Topic Author
Offline
New Member

4 years 3 months ago #22537 by PowerGirl

Routine to grab the last item in a separate table was created by PowerGirl

Hi All. I have an enquiry which accesses file AA.ACCOUNT.DETAILS
one of the items i need to get is from the AA.ARR.INTEREST table

I made a concat linking together the ARRANGEMENT ID, LAST UPDATE in the account and .1
however I have found that concat is not always correct

I am looking to see if anyone has a routine already that i could use in my enquiry to basically go from look up AA.ARR.INTEREST and automatically give me the last item in that listing - or if not a routine any other way to get this. If you think you may be able to help i can upload the actual enquiry to get a better idea of what i am looking for - Thank you in advance

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