Advantage TDataSet Descendant
Deactivates the AOF and releases all resources associated with it.
procedure AdsClearAOF ;
The AdsClearAOF function deactivates the AOF and releases all resources associated with it on both the client and the server. Note that when a table is closed, any AOF associated with it is automatically cleared as well.
For more information, see Advantage Optimized Filters.
AdsTable1.Active := TRUE;
AdsTable1.AdsSetAOF( 'LastName = "S" .AND. EMPID > 50' );
AdsTable1.First;
{ All rows are filtered where LastName does not begin with S or if EMPID not greater than 50 }
{. . . your code here . . .}
AdsTable1.AdsClearAOF;