SE_stream_delete_from_table

Deletes rows from a table using an SQL WHERE clause

Usage syntax

LONG SE_stream_delete_from_table
(SE_STREAM stream,
const CHAR *table,
const CHAR *where_clause);

Parameters
stream The stream handle
table The table name from which to delete the row
where_clause The SQL WHERE clause; if NULL, delete all rows
Description

SE_stream_delete_from_table deletes rows using an SQL WHERE clause from the specified table. The rows are immediately deleted; you do not have to call SE_stream_execute. If no rows are deleted, the warning SE_NO_ROWS_DELETED is returned.

Returns

SE_SUCCESS
SE_INVALID_STREAM

SE_FAILURE

SE_NET_FAILURE

SE_ATTR_NO_EXIST

SE_NO_PERMISSIONS

SE_CONNECTION_IN_USE

SE_NO_ROWID_COLUMN

SE_CONNECTION_LOCKED

SE_NO_ROWS_DELETED

SE_DB_IO_ERROR

SE_OUT_OF_SVMEM

SE_ROW_NOEXIST

SE_SDE_NOT_STARTED

SE_INVALID_PARAM_VALUE

SE_STREAM_IN_PROGRESS

SE_INVALID_POINTER

SE_TABLE_NO_EXIST