Filter property

See Also Properties Methods Events Example

Unit

MySQLDataset

Applies to

TMySQLDataset TMySQLTable and TMySQLQuery components

Declaration

property Filter: string;

Description

This is similar to your standard Filter in Borland.  Set this property to any valid MySQL WHERE clause condition, ex. AccountName like "J%", etc. 

NOTE: This value will automatically be included into the $WHERE macros if Filtered is True.  Also note that this property may also contain any macros, user defined or special macros, you wish to use.