API Reference | developer.brewmp.com API Reference | developer.brewmp.com

Developer

API Reference

IGALLERY_QUERY()

Brew Release
Brew MP 1.0.2
Description
Do a query on gallery db.
Params
pif
[in]:
Pointer to IGallery interface
pwszResultCols
[in]:
Result columns, separated by ','
pwszWhereClause
[in]:
WHERE clause of the SELECT statement
pwszGroupByClause
[in]:
GROUP BY clause of the SELECT statement
pwszHavingClause
[in]:
HAVING clause of the SELECT statement
pwszOrderByClause
[in]:
ORDER BY clause of the SELECT statement
pwszLimit
[in]:
The limit on num of rows returned in the results
nOffpwszOffset
[in]:
Number of rows to skip at the beginning of the result set
piSQLStmt
[out]:
SQL statement object to be returned to caller
Interface
Prototype
  •    int IGallery_Query(IGallery *pif,
                          const AECHAR *pwszResultCols,
                          const AECHAR *pwszWhereClause,
                          const AECHAR *pwszGroupByClause,
                          const AECHAR *pwszHavingClause,
                          const AECHAR *pwszOrderByClause,
                          const AECHAR *pwszLimit,
                          const AECHAR *pwszOffset,
                          ISQLStmt **ppiSQLStmt);
    
Return
  • int: Error code
Comments
Refer to http://sqlite.org/lang_select.html for more help on constructing a SELECT statement. A negative limit indicates no upper bound on the query (same as not providing a LIMIT clause in a SELECT statement. Offset will be ignored for negative limit. Negative offset will be considered the same as 0. Sub-queries are supported by the @TABLE@ keyword. If this keyword appears anywhere in the query clauses, it will be replaced with the correct table source, correctly handling multi-databases.