| SE_stream_update_table | |
Prepares to update rows in a table
LONG SE_stream_update_table
(SE_STREAM stream,
const CHAR *table,
SHORT num_columns,
const CHAR **columns,
const CHAR *where);
| stream | The stream handle |
| table | The table name |
| num_columns | The number of columns to update |
| columns | The array of column names to update |
| where | SQL WHERE clause |
SE_stream_update_table sets up the constraints for updating existing records in any DBMS table including spatially enabled tables. The WHERE parameter specifies which rows to update. The SE_stream_execute function performs the actual update.
Note: If the WHERE argument is NULL or an empty string, every row in the table is updated to the specified values.
After calling SE_stream_update_table to initialize a stream, the application must set a value for each named column using SE_stream_bind_input_column or one of the SE_stream_set_* functions. Each named column must have a value (which is NULL by default) before the application can call SE_stream_execute.
SE_SUCCESS
SE_CONNECTION_IN_USE
SE_CONNECTION_LOCKED
SE_DB_IO_ERROR
SE_FAILURE
SE_INVALID_PARAM_VALUE
SE_INVALID_POINTER
SE_INVALID_STREAM
SE_NET_FAILURE
SE_OUT_OF_CLMEM
SE_OUT_OF_SVMEM
SE_SDE_NOT_STARTED
SE_STREAM_IN_PROGRESS
SE_TABLE_NOEXIST