qdb_setoption()

Set an option for a database connection

Synopsis:

#include <qdb/qdb.h>

int qdb_setoption( qdb_hdt_t *hdl,
                   int option,
                   int value );

Arguments:

hdl

A pointer to the database handle to set the option for.

option

The option to set. It can be one of:

• QDB_OPTION_LAST_INSERT_ROWID — automatically put the last inserted ROWID into any result you fetch. If this option isn't set, that data isn't included in the result structure, and calling qdb_last_insert_rowid() will query the database connection for this information instead.

  By default, this option is on.

• QDB_OPTION_ROW_CHANGES — put the number of rows affected by a statement into any result you fetch. If this option isn't set, that data isn't included in the result structure, and calling qdb_rowchanges() will query the database connection for this information instead.

  By default, this option is on.

• QDB_OPTION_COLUMN_NAMES — populate the column names into the qdb_result_t that is returned from qdb_getresult(). If this option isn't set, that data isn't provided, and calling qdb_column_index() won't work.

  By default, this option is on.

• QDB_OPTION_COLUMN_DECLTYPES — populate the declared column types in the qdb_result_t that is returned from qdb_getresult(). If this option isn't set, that data isn't provided, and calling qdb_column_decltype() won't work.

  By default, this option is off.

value

The value to set the option to: either 0 ("off") or 1 ("on").

Library:

qdb

Description:

This function sets options for the database connection hdl. By default, all of these options are on.

Returns:

≥0

Success. The previous value for option is returned.

-1

The option specified isn't supported (errno is set).

Classification:

QNX Neutrino

See also:

qdb_column_index(), qdb_getresult(), qdb_last_insert_rowid(), qdb_rowchanges()