VistaDB 6
VistaDB.DDA Namespace / IVistaDBTable Interface / SetFilter Method
Filter expression
Try to optimize filter using and existing indexes


In This Topic
    SetFilter Method (IVistaDBTable)
    In This Topic
    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
    )

    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