SE_queryinfo_set_where_clause

Sets the WHERE clause for a query

Usage syntax

LONG SE_queryinfo_set_where_clause
(SE_QUERYINFO query_info,
const CHAR *where_clause);

Parameters
query_info The SE_QUERYINFO handle
where_clause A pointer to a WHERE clause
Description

SE_queryinfo_set_where_clause sets the WHERE clause for a query. The where_clause parameter must contain valid SQL expressions supported by the underlying DBMS. The function does not parse or rewrite the WHERE clause. You can include or omit the where parameter. A WHERE clause for a multitable join must use the same table alias names in the aliases parameter of the SE_QUERYINFO structure and defined with SE_queryinfo_set_tables.

Returns

SE_SUCCESS
SE_FAILURE

SE_INVALID_PARAM_VALUE

SE_INVALID_POINTER

SE_INVALID_QUERYINFO_OBJECT

SE_NET_FAILURE

SE_OUT_OF_CLMEM

SE_SDE_NOT_STARTED