Direct SQL Execution

Functions
int	kdbc_execute_update (kdbc_conn *conn, const char *sql)
	Execute a non-parameterized DML/DDL statement directly.
kdbc_result *	kdbc_execute_query (kdbc_conn *conn, const char *sql)
	Execute a non-parameterized SELECT directly.

Detailed Description

Execute SQL without a prepared statement (no parameters).

Function Documentation

kdbc_execute_update()

int kdbc_execute_update	(	kdbc_conn *	conn,
		const char *	sql )

Execute a non-parameterized DML/DDL statement directly.

Suitable for DDL (CREATE TABLE, DROP TABLE) or simple DML without parameters. For parameterized queries, use kdbc_prepare() instead.

Parameters

conn	An open connection.
sql	The SQL statement to execute.

Returns

Number of affected rows (0 for DDL), or KDBC_ERROR on failure.

kdbc_execute_query()

kdbc_result * kdbc_execute_query	(	kdbc_conn *	conn,
		const char *	sql )

Execute a non-parameterized SELECT directly.

The returned result set owns its resources — close it with kdbc_result_close() when done.

Parameters

conn	An open connection.
sql	The SELECT statement to execute.

Returns

A result set handle, or NULL on failure.