Advantage TDataSet Descendant
Clears the current filter expression in a given table.
procedure AdsClearFilter;
AdsClearFilter will remove the current filter from the specified table, allowing records that previously had not passed the filter to become visible again.
AdsTable1.Active := TRUE;
AdsTable1.AdsSetFilter( 'LastName = "S" .AND. EMPID > 50' );
AdsTable1.First;
{ The row is filtered if LastName does not begin with S or if EMPID not greater than 50 }
{. . . your code here . . .}
AdsTable1.AdsClearFilter;