1. Forum
  3. T24 Technical Discussions
  5. T24 Development & Customization
  7. Enquiry to list the SEC TRADE &SECURITY TRANSFERS
× 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...

Enquiry to list the SEC TRADE &SECURITY TRANSFERS

More
16 years 9 months ago #594 by Ramya
Enquiry to list the SEC TRADE &SECURITY TRANSFERS was created by Ramya
Hi all,



I need to write an Enquiry to list all the SEC.TRADE & SECURITY TRANSFER transactions...



Selection Fields:



STATUS - This field is a calculated based on values in 2 local tables.



Soring based on Accoun officer from SEC.ACC.MASTER, portfolio id & trade date



As of now, i have written a No file enuiry selecting the transactions from SECURITY TRANS table.



But its taking a very long time to give the output...



can anyone help me on this?




Regards,

Ramya

If you don?t have a smile, I will give you one of mine | www.smile.org.in

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

More
16 years 9 months ago #595 by Darcy
Replied by Darcy on topic FBNK.TRN.CON.TRADE.DATE


I would suggest to use the concat file FBNK.TRN.CON.TRADE.DATE to access the SECURITY.TRANS records.

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

  1. Forum
  3. T24 Technical Discussions
  5. T24 Development & Customization
  7. Enquiry to list the SEC TRADE &SECURITY TRANSFERS
Time to create page: 0.096 seconds