dlgEvent_record_AfterInsert

Function called by dialog code event before user inserts a row.

Syntax

PUBLIC FUNCTION dlgEvent_record_AfterInsert( 
   dlg ui.DIALOG, 
   uiMode SMALLINT,
   dlgCtrlInstruction libdbappEvents.DlgCtrlInstruction_Type)
  RETURNS (libdbappEvents.DlgCtrlInstruction_Type)
The function parameters are:
  1. dlg. This is a ui.DIALOG object referencing the current dialog. The dialog can implement an INPUT, INPUT ARRAY, DISPLAY ARRAY, MENU, or CONSTRUCT. For more information, see The Dialog class in Genero Business Development Language User Guide.
  2. uiMode. This is an integer value defining the current mode or state in relation to user action in the dialog, form, or application. Modes are defined as constants in the libdbappFormUI file in the libdbapp library.
    Table 1. UI modes
    Description Applies to ... Constant Value
    Display DISPLAY ARRAY C_MODE_DISPLAY 1
    Modify INPUT \ INPUT ARRAY C_MODE_MODIFY 2
    Add INPUT \ INPUT ARRAY C_MODE_ADD 3
    Search CONSTRUCT C_MODE_SEARCH 4
    Empty MENU C_MODE_EMPTY 5
    Exit form The form C_MODE_EXIT_FORM 6
    Exit app The app C_MODE_EXIT_APP 7
    Undefined All (array, form, or app) C_MODE_UNDEFINED 0
  3. dlgCtrlInstruction is a libdbappEvents.DlgCtrlInstruction_Type defining the dialog control instruction. Instructions available in the function are shown in the table.
    Table 2. Dialog control instructions
    Description Constant Value
    Accept dialog ACCEPT_DIALOG 1
    Continue dialog CONTINUE_DIALOG 2
    Exit dialog EXIT_DIALOG 3

The function returns a dialog control instruction value defined by libdbappEvents.DlgCtrlInstruction_Type.

Usage

When you select the After Insert Row property for the creation of the event, a function shell is created. Enter your code in the function.

This function is called in a dialog controlling an INPUT ARRAY when the creation of a new row is valid. Use this function, for example, to display a message to the user.
Note:

CRUD operation functions are not performed at the dialog level. The SQL to insert the new row in the database table is performed in the data functions. See Records data functions.

Example: After Insert

This example uses the After Insert Row code event for the Account form in the OfficeStore demo.

In this example the value of the current row index and the number of rows in the array are displayed to system output.

PUBLIC FUNCTION dlgEvent_recAccount_AfterInsert(dlg ui.DIALOG, uiMode SMALLINT,
      dlgCtrlInstruction libdbappEvents.DlgCtrlInstruction_Type)
    RETURNS (libdbappEvents.DlgCtrlInstruction_Type)

    CALL libdbappCore.log(C_LOG_INFO, "dlgEvent_recAccount_AfterInsert (Row scope) is raised")
    DISPLAY "uiMode is: ", uiMode
    DISPLAY "current row index: ", dlg.getCurrentRow("recAccount")
    DISPLAY  "No. of rows: ", dlg.getArrayLength("recAccount")
    CALL libdbappCore.log(C_LOG_INFO, "dlgEvent_recAccount_AfterInsert (Row scope) is exited")

    RETURN dlgCtrlInstruction
END FUNCTION

For more information on the libdbappCore.log() function, go to DBAPPDEBUG and the debug level API.