OraFormsLovFind Function

Action

OraFormsLovFind allows you to define a new search pattern for the List Of Values dialog.

Include file

OraForms.bdh

Syntax

OraFormsLovFind( in sName       : string, 
                 in sPattern    : string) : boolean

Return value

  • true if successful
  • false otherwise
Parameter Description
sName Unique name of the control where the List Of Values dialog is opened.
sPattern The new search pattern for the List Of Values dialog.

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;