Lines Matching refs:clause
52 DB_MAX_WHERE_CLAUSE_LEN Maximum supported WHERE clause length that
219 clause
2173 then you must also pass in a SQL WHERE clause in this argument. Default
2246 then you must also pass in a SQL WHERE clause in this argument. Default is "".}
2274 \docparam{typeOfWhere}{The type of where clause to generate. Can be one of
2277 column names. For use when a FROM clause has been specified with the
2281 clause utilize the LIKE comparison operator. If false, then the '='
2286 This member function allows you to see what the SQL WHERE clause looks like
2291 containing a NULL value are not included in the WHERE clause's list of
2307 Not all datasources support the "FOR UPDATE" clause, so you must use this
2313 the FOR UPDATE clause, this function will return false also.
2663 The WHERE clause is built by the ODBC class library based on all non-NULL
2665 your wxDbTable instance, without having to write the SQL WHERE clause.
2703 WHERE clause that is passed in.
2707 \docparam{pWhereClause}{SQL WHERE clause. This WHERE clause determines which
2709 instance. The WHERE clause passed in must be compliant with the SQL 92
2717 to delete records by passing a valid SQL WHERE clause. Sophisticated
2808 in the FROM clause, as it is automatically included by the wxDbTable class
2817 the from clause successfully.
3238 in. If a FROM clause has also been specified, each column name specified in
3239 the ORDER BY clause should be prefaced with the table name to which the column
3261 as they are retrieved. If the RDBMS is not capable of the FOR UPDATE clause,
3296 the event that the FROM clause has been set (is non-null) using
3424 // Order by clause; ROWID, scalar function
3454 the FOR UPDATE clause, this argument is ignored. See
3464 The SQL WHERE clause is built by the ODBC class library based on all
3467 to the column names in the event that the wxDbTable's FROM clause is non-null.
3470 columns that are 0 or NULL, as the automatically constructed WHERE clause
3513 prepended to the column names in the event that the wxDbTable's FROM clause
3520 the FOR UPDATE clause, this argument is ignored. See
3724 in the FROM clause, as it is automatically included by the wxDbTable class
3733 Do {\bf not} include the keyword "FROM" when setting the FROM clause.
3735 If using the FROM clause when performing a query, be certain to include in
3736 the corresponding WHERE clause a comparison of a column from either the base
3800 a FROM clause has also been specified, each column name specified in the
3801 ORDER BY clause should be prefaced with the table name to which the column
3806 Do {\bf not} include the keywords "ORDER BY" when setting the ORDER BY clause.
3853 \docparam{Where}{SQL "where" clause. This clause can contain any SQL language
3854 that is legal in standard where clauses. If a FROM clause has also been
3855 specified, each column name specified in the ORDER BY clause should be
3861 Do {\bf not} include the keywords "WHERE" when setting the WHERE clause.
3867 // Simple where clause
3879 // This query uses an inner join (requiring a FROM clause also)
3944 \docparam{pWhereClause}{Pointer to a valid SQL WHERE clause. Do not
3964 (the first form of this function) to return the current where clause or
3966 of this function) to set the where clause for this table instance.
3970 \docparam{Where}{A valid SQL WHERE clause. Do not include the keyword 'WHERE'.}
3978 the where clause successfully.