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;