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') |
|
|
|