 |
|
|
FilterTable() Returns, sets or clears a filter on a selected database table. Syntax FilterTable([<cExpression>]) --> lSuccess Arguments <cExpression> --> A filter expression to apply to the table. Returns Returns TRUE if the operation was successful, otherwise FALSE. Description This function sets, returns or clears a filter condition applied to a database table. A filter condition hides from view any records that do not match the filter condition. Skip() and Find() and GotoTop() and GotoBottom() will not 'see' filtered records. However, if the record number is know, Goto() can still position the record pointer onto a filtered record. To return the existing filter expression in use (if any), do not pass any parameters. e.g., Echo(FilterTable()) To clear a filter expression, pass an empty string, e.g., FilterTable("") To set a filter, pass a valid expression as a character string. Valid expressions may include a mix of CBS functions, variables, values and operators such as > and =. Example FilterTable("Price1 > 0") ____________________________ Related Topics |
