| SE_stream_query | |
Initiates a layer query
LONG SE_stream_query
(SE_STREAM stream,
SHORT num_columns,
const CHAR **columns,
const SE_SQL_CONSTRUCT
*construct);
| stream | The stream handle |
| num_columns | The number of table columns in the array |
| columns | An array of column names |
| construct | The SQL constructor |
SE_stream_query initializes a stream with a query using a selected set of columns and an SE_SQL_CONSTRUCT structure for the WHERE clause. The SE_SQL_CONSTRUCT structure is:
typedef struct {
LONG num_tables; /* Number of tables in join */
CHAR **tables; /* Table names */
CHAR *where; /* Where clause */
} SE_SQL_CONSTRUCT;
The WHERE clause cannot contain any ORDER BY or GROUP BY clauses.
SE_SUCCESS
SE_ATTR_CONV_ERROR
SE_ATT_NOEXIST
SE_CONNECTION_IN_USE
SE_CONNECTION_LOCKED
SE_DB_IO_ERROR
SE_INVALID_PARAM_VALUE
SE_INVALID_POINTER
SE_INVALID_ROW_ID_LAYER
SE_INVALID_SQL
SE_LAYER_MISMATCH
SE_LOAD_ONLY_LAYER
SE_MULTIPLE_SPATIAL_COLS
SE_NET_FAILURE
SE_NO_PERMISSIONS
SE_OUT_OF_CLMEM
SE_OUT_OF_SVMEM
SE_SDE_NOT_STARTED
SE_STREAM_IN_PROGRESS
SE_TABLE_NOEXIST
You can use an asterisk, *, as a column name to select all columns in the table.