Developer

API Reference

IGallery_Query()

Brew Release
Brew MP 1.0.2
Description
Do a query on gallery db.
Parameters
  • 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
Comment
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.
  • Follow