|
Returns a STRING representing the built query based upon passed parameters. This function
is handy for creating database queries that will use boolean operations and brackets to do
keyword searching.
|
| |
| Syntax |
BuildQuery( columns, criteria, separator )
|
| columns |
Columns to be included in the query.
Special character sequences can be included in '{}' brackets. This allows the developer
to specify a prefix and suffix for the column value.
(ie. {'%}col1{%'} ==> '%data%')
|
| criteria |
Supplied criteria (ie. the words and boolean operators). |
| separator |
A separator used between criteria sub-expressions. (default is '=', another choice may be 'LIKE') |
| |
| |
|
|
