VistaDB 5






VistaDB.DDA Namespace > IVistaDBTable Interface > Find Method : Find(String,String,Boolean,Boolean) Method
The expression to evaluate for the target row(s). This expression should follow the Find Expression Syntax (see help file).
Index to use for the operation (must already exist)
Try to find using partial matching if exact match is not found
Try to position the current row pointer to the row after a non found key. This is where the row would have if it had existed.
Find(String,String,Boolean,Boolean) Method
Find an expression in an index. This is for searching for exact and partial matching records.
Syntax
'Declaration
 
Overloads Function Find( _
   ByVal keyEvaluationExpression As System.String, _
   ByVal indexName As System.String, _
   ByVal partialMatching As System.Boolean, _
   ByVal softPosition As System.Boolean _
) As System.Boolean
'Usage
 
Dim instance As IVistaDBTable
Dim keyEvaluationExpression As System.String
Dim indexName As System.String
Dim partialMatching As System.Boolean
Dim softPosition As System.Boolean
Dim value As System.Boolean
 
value = instance.Find(keyEvaluationExpression, indexName, partialMatching, softPosition)
System.bool Find( 
   System.string keyEvaluationExpression,
   System.string indexName,
   System.bool partialMatching,
   System.bool softPosition
)
function Find( 
    keyEvaluationExpression: System.String;
    indexName: System.String;
    partialMatching: System.Boolean;
    softPosition: System.Boolean
): System.Boolean; 
function Find( 
   keyEvaluationExpression : System.String,
   indexName : System.String,
   partialMatching : System.boolean,
   softPosition : System.boolean
) : System.boolean;
System.bool Find( 
   System.string* keyEvaluationExpression,
   System.string* indexName,
   System.bool partialMatching,
   System.bool softPosition
) 
System.bool Find( 
   System.String^ keyEvaluationExpression,
   System.String^ indexName,
   System.bool partialMatching,
   System.bool softPosition
) 

Parameters

keyEvaluationExpression
The expression to evaluate for the target row(s). This expression should follow the Find Expression Syntax (see help file).
indexName
Index to use for the operation (must already exist)
partialMatching
Try to find using partial matching if exact match is not found
softPosition
Try to position the current row pointer to the row after a non found key. This is where the row would have if it had existed.

Return Value

Operation status. If the key is not found, the current row position is set to the bottom of the table and EndOfTable flag is set. True will set current row to the first found entry.
Remarks
Find may not be used on FTS indexes
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also