Archive for category Enquiry

Call a subroutine from an enquiry field

Call a subroutine Usage description: You can call a subroutine from an enquiry field. You have to invoke it using @ E.Subroutine.Name in the Conversion field. The argument to be processed by the enquiry must be set in the Operation field. Inside the subroutine, the argument will be transmitted in a dedicated variable named O.DATA. […]

, , , , , , , , ,

No Comments

Display the very first inputter of a record / a deal

Display very first inputter of a record 12. 7. 1 OPERATION… INPUTTER 13. 7 COLUMN……… 52 14. 7 LENGTH.MASK…. 28L 15. 7. 1 CONVERSION.. V 1 15. 7. 2 CONVERSION.. F _,2

, , , , , , , , ,

No Comments

dates formatting

Example of date formatting in Enquiry 12. 3. 1 OPERATION… DATE.TIME 13. 3 COLUMN……… 35 14. 3 LENGTH.MASK…. 10L 15. 3. 1 CONVERSION.. E 1,6 15. 3. 2 CONVERSION.. I D 15. 3. 3 CONVERSION.. O D2/E

, , , , , , , , ,

No Comments

Compute the difference between two dates

You have firstĀ  to convert the two dates to be compared to the julian format. 11.19 FIELD.NAME….. LAST.TRADE 12.19. 1 OPERATION… IDESC LAST.TRADE 14.19 LENGTH.MASK…. 12L 15.19. 1 CONVERSION.. JULIAN 11.20 FIELD.NAME….. COMPANY 12.20. 1 OPERATION… PORTFOLIO 14.20 LENGTH.MASK…. 18L 15.20. 1 CONVERSION.. L SEC.ACC.MASTER,CO.CODE 32.20 SINGLE.MULTI… S 11.21 FIELD.NAME….. TODAY 12.21. 1 OPERATION… F […]

, , , , , , , , ,

No Comments

How to deal with selection fields in an enquiry targeting a Nofile

Selection fields in an enquiry targeting a Nofile If you need to give users the ability to filter the enquiry results, you must declare selection fields in the SS and take them in consideration in the subroutine. Inside the routine, by adding the library for enquiries (I_ENQUIRY.COMMON), you will be able to process selection fields […]

, , , , , , , , ,

No Comments

Build an enquiry with a Nofile

Build an enquiry with a Nofile When you can’t use standard conversion and calculation functions to get what you need, you still have a programming solution. It occurs typically when you need data spreaded in multiple tables, because ENQUIRY tool is single-table by essence. You can use links to other tables when you have foreign […]

, , , , , , , , ,

No Comments