Ir al contenido principal

Entradas

Mostrando entradas de octubre, 2020

Contar registros de una tabla

https://www.pannimanagement.com/?blog=how-to-check-numberof-records-in-the-table-in-sage-enterprise-management-formerly-sage-x3   To check number of records in the table in Sage X3. Nbrecord – Sage X3 Following Syntax is used for this purpose. Syntax: nbrecord(class) Example: Following example is shown here. A notification will pop up showing the number of records in service request table. In this example there are 25 records in service request table.

4GL will make a SOAP call directly into Syracuse classic SOAP web services

 Origen: https://github.com/Delamater/X3/blob/master/4GL/ZEXEC_HTTP #* Author: Bob Delamater #* Desc: Inject a sales order document with a variable number of lines using #* the developer.sage.com method. #* Leverage EXEC_HTTP to perform this. 4GL will make a SOAP call directly #* into Syracuse classic SOAP web services. #* #* If the result is good, return success. #* #*****************************************************************************! #*! Local Integer ASTATUS, CREATION_STATUS, TIMING_STATUS, RET_OPENLOG Local Clbfile RESHEAD, RESBODY Local Char SOMELOG # Build the arguments for the call Gosub BUILD_ARGUMENTS # Optionally proile the code #TIMING_STATUS = func ASYRTIMING.START("", 1) RET_OPENLOG = openLog('TRA',12) # Call EXEC_HTTP passing in the header, authorization and retrieve the result header and body ASTATUS = func ASYRWEBSER.EXEC_HTTP(HEADERCOD, HEADERVAL, BODY, RESHEAD, RESBODY) RET_OPENLOG = CloseLog() #TIMING_STATUS = func ASYRTIMING.STOP(