Prototype: bool Select(struct data)
Description: This command selects the records which match the supplied where clause. Just the text to the right of the "where" should be provided. Normal SQL rules apply to quoting text. Possible values of WhereClause are:
WhereClause=
firstName='Jane'
WhereClause=firstName like 'Wil%'
WhereClause-firstName
like 'B%' and BadgeNo > 1000
The second example returns all records where the firstName field starts with Wil. The third returns all with a firstName which begins with B and with a BadgeNo greater than 1000.
Input Data
Format:
WhereClause = <SQL where clause>