VistaDB 5






Filter expression
Try to optimize filter using and existing indexes
SetFilter Method (IVistaDBTable)
Set filter expression and try to optimize it if the optimize parameter is true
Syntax
'Declaration
 
Sub SetFilter( _
   ByVal expression As System.String, _
   ByVal optimize As System.Boolean _
) 
'Usage
 
Dim instance As IVistaDBTable
Dim expression As System.String
Dim optimize As System.Boolean
 
instance.SetFilter(expression, optimize)
void SetFilter( 
   System.string expression,
   System.bool optimize
)
procedure SetFilter( 
    expression: System.String;
    optimize: System.Boolean
); 
function SetFilter( 
   expression : System.String,
   optimize : System.boolean
);
void SetFilter( 
   System.string* expression,
   System.bool optimize
) 
void SetFilter( 
   System.String^ expression,
   System.bool optimize
) 

Parameters

expression
Filter expression
optimize
Try to optimize filter using and existing indexes
Remarks
Optimization is enabled by default. If you are getting unexpected results from a query, try to turn optimization off and see if the query works correctly.
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