DevGuru ADO DataControl::FilterValue Property

Quick References

Features

Partners



			PROPERTY: DataControl::FilterValue string = datacontrolobject.FilterValue datacontrolobject.FilterValue = string The FilterValue property sets or returns a string that specifies the value that the filter will use to evaluate the data. The FilterColumn, FilterCriteria, and FilterValue properties are used together to create a string filter that can be applied to the records in a Recordset contained in the client-side cache. To execute the filter, you need to call the Reset method. Based upon the filter, a subset of those records in the Recordset will be returned. Meanwhile, the original Recordset will remain unchanged in the client-side cache. If you change the value of the FilterValue property, you must call the Reset method to put the change into effect. If you wish to completely clear the filter that is in effect, you need to set the FilterColumn, FilterCriteria, and FilterValue properties to be the empty string and call Reset with a value of False for the parameter. Code (VBScript): Dim strFilCol, strFilCrit, strFilVal strFilCol = "Age" strFilCrit = ">" strFilVal = "99" ... objDataControl.FilterColumn = strFilCol objDataControl.FilterCriterion = strFilCrit objDataControl.FilterValue = strFilVal objDataControl.Reset