Advantage TDataSet Descendant
Rebuilds the filter.
procedure AdsRefreshAOF;
AdsRefreshAOF rebuilds the filter using the original values passed to AdsSetAOF. The Advantage Database Server maintains the accuracy of all AOFs associated with a given table when updates are performed. With Advantage Local Server, however, it is possible for another client to make updates to the table. In that case, it might be useful to call AdsRefreshAOF to force the filter to be rebuilt. It may also make sense to call this function if an index that could affect the optimization level of the AOF has been opened or created since the original AOF was created.
For more information, see Advantage Optimized Filters.
AdsTable1.Active := TRUE;
AdsTable1.AdsSetAOF( 'LastName = "S" .AND. EMPID > 50' );
{. . .your code here. . .}
AdsTable1.AdsRefreshAOF;