OraFormsLovSelect Function

Action

OraFormsLovSelect allows you to select an entry of the search result in the List Of Values dialog. The value will be used in the control that has the List of Values assigned to it. The entry can either be defined by its value or by the index in the current search result.

Include file

OraForms.bdh

Syntax

OraFormsLovSelect(  in sName  :   string,
                    in sValue :  string,
                    in nIndex :  number optional ) : boolean;

Return value

  • true if successful
  • false otherwise
Parameter Description
sName Unique name of the control where the List Of Values dialog is opened.
sValue The value that should be selected from the current LOV result. If NULL, the nIndex parameter can be used to define the index that should be selected.
nIndex (optional) If sValue is NULL, this parameter can be used to define the index of the entry that should be selected.

Example

transaction TMain 
  var 
    sValue :  string; 
    nFetched :  number; 
  begin 
    OraFormsSetConnectMode(ORA_SOCKET_CONNECTION); 
    // Connect - with connection properties 
    OraFormsSetInt( "INITIAL_VERSION", 608); 
    OraFormsSetPoint( "INITIAL_RESOLUTION",96,  96); 
    OraFormsSetPoint( "INITIAL_DISP_SIZE", 1024,  768); 
    OraFormsSetInt( "INITIAL_COLOR_DEPTH", 256); 
    OraFormsSetString( "FONT_NAME" , "Dialog" ); 
    OraFormsSetPoint( "INITIAL_SCALE_INFO", 8,  18); 
    OraFormsSetBoolean( "WINSYS_REQUIREDVA_LIST",  false); 
    OraFormsConnect( "server module=Person3.fmx userid= useSDI=yes record=names"); 
    // New window activated: Logon 
    OraFormsSetWindow( "Logon"); 
    OraFormsLogon( "user",  "password",  "orcl_server"); 
    // --- 
    // New window activated: WINDOW1 
    OraFormsSetWindow( "WINDOW1"); 
    OraFormsMenuItem( "FENSTER1",  "Edit::Display List..."); 

    OraFormsSetWindow( "lovjob"); 
    OraFormsLovOpen( "lovjob", nFetched); 
    OraFormsLovFind( "lovjob",  "%S%"); 
    OraFormsLovSelect( "lovjob",  "SUPER-MAN"); 
    // --- 
    // New window activated: WINDOW1 
    OraFormsSetWindow( "WINDOW1"); 
    OraFormsMenuItem( "WINDOW1",  "Action::Exit"); 
  end  TMain;