Unlike the base tdataset behavior, setting Filter or Filtered on a tsqlquery inserts Filter into the "where" part of the SQL statement and re-executes the query against the database
Source position: msesqlquery.pas line 294
published property tsqlquery.Filter; |
Unlike the base tdataset behavior, setting Filter or Filtered on a tsqlquery inserts Filter into the "where" part of the SQL statement and re-executes the query against the database — it is not a local, in-memory filter of already fetched records. ParseSQL must be True. For a purely local filter of the fetched records use OnFilterRecord instead.