| SE_table_create_view | |
Creates a DBMS view on a table.
LONG SE_table_create_view
(SE_CONNECTION connection,
const CHAR *view,
SHORT num_view_columns,
SHORT num_table_columns,
const CHAR **view_columns,
const CHAR **table_columns,
const SE_SQL_CONSTRUCT
*construct);
| connection | The connection handle |
| view | The view name |
| num_view_columns | The number of view columns |
| num_table_columns | The number of table columns |
| view_columns | The names of the columns in the view |
| table_columns | The names of the columns in the table |
| construct | The SQL constructor |
SE_table_create_view creates a DBMS view on the specified table. The view is registered after creation. 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;
SE_SUCCESS
SE_DB_IO_ERROR
SE_INVALID_CONNECTION
SE_INVALID_COLUMN_DEF
SE_NET_FAILURE
SE_NO_PERMISSIONS
SE_SDE_NOT_STARTED
SE_TABLE_NOEXIST