Inherits object.

Public Member Functions
	sqlrcursor (sqlrconnection *sqlrc)

	~sqlrcursor ()

void	setResultSetBufferSize (uint64_t rows)

uint64_t	getResultSetBufferSize ()

void	dontGetColumnInfo ()

void	getColumnInfo ()

void	mixedCaseColumnNames ()

void	upperCaseColumnNames ()

void	lowerCaseColumnNames ()

void	cacheToFile (const char *filename)

void	setCacheTtl (uint32_t ttl)

const char *	getCacheFileName ()

void	cacheOff ()

bool	getDatabaseList (const char *wild)

bool	getTableList (const char *wild)

bool	getColumnList (const char table, const char wild)

bool	sendQuery (const char *query)

bool	sendQuery (const char *query, uint32_t length)

bool	sendFileQuery (const char path, const char filename)

void	prepareQuery (const char *query)

void	prepareQuery (const char *query, uint32_t length)

bool	prepareFileQuery (const char path, const char filename)

void	substitution (const char variable, const char value)

void	substitution (const char *variable, int64_t value)

void	substitution (const char *variable, double value, uint32_t precision, uint32_t scale)

void	substitutions (const char variables, const char values)

void	substitutions (const char *variables, const int64_t values)

void	substitutions (const char *variables, const double values, const uint32_t precisions, const uint32_t scales)

void	inputBind (const char variable, const char value)

void	inputBind (const char variable, const char value, uint32_t valuelength)

void	inputBind (const char *variable, int64_t value)

void	inputBind (const char *variable, double value, uint32_t precision, uint32_t scale)

void	inputBind (const char variable, int16_t year, int16_t month, int16_t day, int16_t hour, int16_t minute, int16_t second, int32_t microsecond, const char tz, bool isnegative)

void	inputBindBlob (const char variable, const char value, uint32_t size)

void	inputBindClob (const char variable, const char value, uint32_t size)

void	inputBinds (const char variables, const char values)

void	inputBinds (const char *variables, const int64_t values)

void	inputBinds (const char *variables, const double values, const uint32_t precisions, const uint32_t scales)

void	defineOutputBindString (const char *variable, uint32_t bufferlength)

void	defineOutputBindInteger (const char *variable)

void	defineOutputBindDouble (const char *variable)

void	defineOutputBindDate (const char *variable)

void	defineOutputBindBlob (const char *variable)

void	defineOutputBindClob (const char *variable)

void	defineOutputBindCursor (const char *variable)

void	clearBinds ()

uint16_t	countBindVariables ()

void	validateBinds ()

bool	validBind (const char *variable)

bool	executeQuery ()

bool	fetchFromBindCursor ()

const char *	getOutputBindString (const char *variable)

int64_t	getOutputBindInteger (const char *variable)

double	getOutputBindDouble (const char *variable)

bool	getOutputBindDate (const char variable, int16_t year, int16_t month, int16_t day, int16_t hour, int16_t minute, int16_t second, int32_t microsecond, const char *tz, bool isnegative)

const char *	getOutputBindBlob (const char *variable)

const char *	getOutputBindClob (const char *variable)

uint32_t	getOutputBindLength (const char *variable)

sqlrcursor *	getOutputBindCursor (const char *variable)

bool	openCachedResultSet (const char *filename)

uint32_t	colCount ()

uint64_t	rowCount ()

uint64_t	totalRows ()

uint64_t	affectedRows ()

uint64_t	firstRowIndex ()

bool	endOfResultSet ()

const char *	errorMessage ()

int64_t	errorNumber ()

void	getNullsAsEmptyStrings ()

void	getNullsAsNulls ()

const char *	getField (uint64_t row, uint32_t col)

const char *	getField (uint64_t row, const char *col)

int64_t	getFieldAsInteger (uint64_t row, uint32_t col)

int64_t	getFieldAsInteger (uint64_t row, const char *col)

double	getFieldAsDouble (uint64_t row, uint32_t col)

double	getFieldAsDouble (uint64_t row, const char *col)

uint32_t	getFieldLength (uint64_t row, uint32_t col)

uint32_t	getFieldLength (uint64_t row, const char *col)

const char const	getRow (uint64_t row)

uint32_t *	getRowLengths (uint64_t row)

const char const	getColumnNames ()

const char *	getColumnName (uint32_t col)

const char *	getColumnType (uint32_t col)

const char *	getColumnType (const char *col)

uint32_t	getColumnLength (uint32_t col)

uint32_t	getColumnLength (const char *col)

uint32_t	getColumnPrecision (uint32_t col)

uint32_t	getColumnPrecision (const char *col)

uint32_t	getColumnScale (uint32_t col)

uint32_t	getColumnScale (const char *col)

bool	getColumnIsNullable (uint32_t col)

bool	getColumnIsNullable (const char *col)

bool	getColumnIsPrimaryKey (uint32_t col)

bool	getColumnIsPrimaryKey (const char *col)

bool	getColumnIsUnique (uint32_t col)

bool	getColumnIsUnique (const char *col)

bool	getColumnIsPartOfKey (uint32_t col)

bool	getColumnIsPartOfKey (const char *col)

bool	getColumnIsUnsigned (uint32_t col)

bool	getColumnIsUnsigned (const char *col)

bool	getColumnIsZeroFilled (uint32_t col)

bool	getColumnIsZeroFilled (const char *col)

bool	getColumnIsBinary (uint32_t col)

bool	getColumnIsBinary (const char *col)

bool	getColumnIsAutoIncrement (uint32_t col)

bool	getColumnIsAutoIncrement (const char *col)

uint32_t	getLongest (uint32_t col)

uint32_t	getLongest (const char *col)

void	suspendResultSet ()

uint16_t	getResultSetId ()

bool	resumeResultSet (uint16_t id)

bool	resumeCachedResultSet (uint16_t id, const char *filename)

bool	nextResultSet ()

void	closeResultSet ()

Constructor & Destructor Documentation

◆ sqlrcursor()

sqlrcursor::sqlrcursor ( sqlrconnection * sqlrc )

Creates a cursor to run queries and fetch result sets using connecton "sqlrc".

◆ ~sqlrcursor()

sqlrcursor::~sqlrcursor ( )

Destroys the cursor and cleans up all associated result set data.

Member Function Documentation

◆ affectedRows()

uint64_t sqlrcursor::affectedRows ( )

Returns the number of rows that were updated, inserted or deleted by the query. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. 0 is returned by databases which don't support this option.

◆ cacheOff()

void sqlrcursor::cacheOff ( )

Sets query caching off.

◆ cacheToFile()

void sqlrcursor::cacheToFile ( const char * filename )

Sets query caching on. Future queries will be cached to the file "filename".

A default time-to-live of 10 minutes is also set.

Note that once cacheToFile() is called, the result sets of all future queries will be cached to that file until another call to cacheToFile() changes which file to cache to or a call to cacheOff() turns off caching.

◆ clearBinds()

void sqlrcursor::clearBinds ( )

Clears all bind variables.

◆ closeResultSet()

void sqlrcursor::closeResultSet ( )

Closes the current result set, if one is open. Data that has been fetched already is still available but no more data may be fetched. Server side resources for the result set are freed as well.

◆ colCount()

uint32_t sqlrcursor::colCount ( )

Returns the number of columns in the current result set.

◆ countBindVariables()

uint16_t sqlrcursor::countBindVariables ( )

Parses the previously prepared query, counts the number of bind variables defined in it and returns that number.

◆ defineOutputBindBlob()

void sqlrcursor::defineOutputBindBlob ( const char * variable )

Defines a binary lob output bind variable.

◆ defineOutputBindClob()

void sqlrcursor::defineOutputBindClob ( const char * variable )

Defines a character lob output bind variable.

◆ defineOutputBindCursor()

void sqlrcursor::defineOutputBindCursor ( const char * variable )

Defines a cursor output bind variable.

◆ defineOutputBindDate()

void sqlrcursor::defineOutputBindDate ( const char * variable )

Defines a date output bind variable.

◆ defineOutputBindDouble()

void sqlrcursor::defineOutputBindDouble ( const char * variable )

Defines a decimal output bind variable.

◆ defineOutputBindInteger()

void sqlrcursor::defineOutputBindInteger ( const char * variable )

Defines an integer output bind variable.

◆ defineOutputBindString()

void sqlrcursor::defineOutputBindString	(	const char *	variable,
		uint32_t	bufferlength
	)

Defines an output bind variable. "bufferlength" bytes will be reserved to store the value.

◆ dontGetColumnInfo()

void sqlrcursor::dontGetColumnInfo ( )

Tells the server not to send any column info (names, types, sizes). If you don't need that info, you should call this method to improve performance.

◆ endOfResultSet()

bool sqlrcursor::endOfResultSet ( )

Returns false if part of the result set is still pending on the server and true if not. This method can only return false if setResultSetBufferSize() has been called with a parameter other than 0.

◆ errorMessage()

const char* sqlrcursor::errorMessage ( )

If a query failed and generated an error, the error message is available here. If the query succeeded then this method returns NULL.

◆ errorNumber()

int64_t sqlrcursor::errorNumber ( )

If a query failed and generated an error, the error number is available here. If there is no error then this method returns 0.

◆ executeQuery()

bool sqlrcursor::executeQuery ( )

Execute the query that was previously prepared and bound.

◆ fetchFromBindCursor()

bool sqlrcursor::fetchFromBindCursor ( )

Fetch from a cursor that was returned as an output bind variable.

◆ firstRowIndex()

uint64_t sqlrcursor::firstRowIndex ( )

Returns the index of the first buffered row. This is useful when buffering only part of the result set at a time.

◆ getCacheFileName()

const char* sqlrcursor::getCacheFileName ( )

Returns the name of the file containing the cached result set.

◆ getColumnInfo()

void sqlrcursor::getColumnInfo ( )

Tells the server to send column info.

◆ getColumnIsAutoIncrement() [1/2]

bool sqlrcursor::getColumnIsAutoIncrement ( const char * col )

Returns true if the specified column auto-increments and false otherwise.

◆ getColumnIsAutoIncrement() [2/2]

bool sqlrcursor::getColumnIsAutoIncrement ( uint32_t col )

Returns true if the specified column auto-increments and false otherwise.

◆ getColumnIsBinary() [1/2]

bool sqlrcursor::getColumnIsBinary ( const char * col )

Returns true if the specified column contains binary data and false otherwise.

◆ getColumnIsBinary() [2/2]

bool sqlrcursor::getColumnIsBinary ( uint32_t col )

Returns true if the specified column contains binary data and false otherwise.

◆ getColumnIsNullable() [1/2]

bool sqlrcursor::getColumnIsNullable ( const char * col )

Returns true if the specified column can contain nulls and false otherwise.

◆ getColumnIsNullable() [2/2]

bool sqlrcursor::getColumnIsNullable ( uint32_t col )

Returns true if the specified column can contain nulls and false otherwise.

◆ getColumnIsPartOfKey() [1/2]

bool sqlrcursor::getColumnIsPartOfKey ( const char * col )

Returns true if the specified column is part of a composite key and false otherwise.

◆ getColumnIsPartOfKey() [2/2]

bool sqlrcursor::getColumnIsPartOfKey ( uint32_t col )

Returns true if the specified column is part of a composite key and false otherwise.

◆ getColumnIsPrimaryKey() [1/2]

bool sqlrcursor::getColumnIsPrimaryKey ( const char * col )

Returns true if the specified column is a primary key and false otherwise.

◆ getColumnIsPrimaryKey() [2/2]

bool sqlrcursor::getColumnIsPrimaryKey ( uint32_t col )

Returns true if the specified column is a primary key and false otherwise.

◆ getColumnIsUnique() [1/2]

bool sqlrcursor::getColumnIsUnique ( const char * col )

Returns true if the specified column is unique and false otherwise.

◆ getColumnIsUnique() [2/2]

bool sqlrcursor::getColumnIsUnique ( uint32_t col )

Returns true if the specified column is unique and false otherwise.

◆ getColumnIsUnsigned() [1/2]

bool sqlrcursor::getColumnIsUnsigned ( const char * col )

Returns true if the specified column is an unsigned number and false otherwise.

◆ getColumnIsUnsigned() [2/2]

bool sqlrcursor::getColumnIsUnsigned ( uint32_t col )

Returns true if the specified column is an unsigned number and false otherwise.

◆ getColumnIsZeroFilled() [1/2]

bool sqlrcursor::getColumnIsZeroFilled ( const char * col )

Returns true if the specified column was created with the zero-fill flag and false otherwise.

◆ getColumnIsZeroFilled() [2/2]

bool sqlrcursor::getColumnIsZeroFilled ( uint32_t col )

Returns true if the specified column was created with the zero-fill flag and false otherwise.

◆ getColumnLength() [1/2]

uint32_t sqlrcursor::getColumnLength ( const char * col )

Returns the number of bytes required on the server to store the data for the specified column

◆ getColumnLength() [2/2]

uint32_t sqlrcursor::getColumnLength ( uint32_t col )

Returns the number of bytes required on the server to store the data for the specified column

◆ getColumnList()

bool sqlrcursor::getColumnList	(	const char *	table,
		const char *	wild
	)

Sends a query that returns a list of columns in the table specified by the "table" parameter matching "wild". If wild is empty or NULL then a list of all columns will be returned.

◆ getColumnName()

const char* sqlrcursor::getColumnName ( uint32_t col )

Returns the name of the specified column.

◆ getColumnNames()

const char* const* sqlrcursor::getColumnNames ( )

Returns a null terminated array of the column names of the current result set.

◆ getColumnPrecision() [1/2]

uint32_t sqlrcursor::getColumnPrecision ( const char * col )

Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types, it's the number of characters in the string.

◆ getColumnPrecision() [2/2]

uint32_t sqlrcursor::getColumnPrecision ( uint32_t col )

Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types, it's the number of characters in the string.

◆ getColumnScale() [1/2]

uint32_t sqlrcursor::getColumnScale ( const char * col )

Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.

◆ getColumnScale() [2/2]

uint32_t sqlrcursor::getColumnScale ( uint32_t col )

Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.

◆ getColumnType() [1/2]

const char* sqlrcursor::getColumnType ( const char * col )

Returns the type of the specified column.

◆ getColumnType() [2/2]

const char* sqlrcursor::getColumnType ( uint32_t col )

Returns the type of the specified column.

◆ getDatabaseList()

bool sqlrcursor::getDatabaseList ( const char * wild )

Sends a query that returns a list of databases/schemas matching "wild". If wild is empty or NULL then a list of all databases/schemas will be returned.

◆ getField() [1/2]

const char* sqlrcursor::getField	(	uint64_t	row,
		const char *	col
	)

Returns the specified field as a string

◆ getField() [2/2]

const char* sqlrcursor::getField	(	uint64_t	row,
		uint32_t	col
	)

Returns the specified field as a string.

◆ getFieldAsDouble() [1/2]

double sqlrcursor::getFieldAsDouble	(	uint64_t	row,
		const char *	col
	)

Returns the specified field as a decimal.

◆ getFieldAsDouble() [2/2]

double sqlrcursor::getFieldAsDouble	(	uint64_t	row,
		uint32_t	col
	)

Returns the specified field as a decimal.

◆ getFieldAsInteger() [1/2]

int64_t sqlrcursor::getFieldAsInteger	(	uint64_t	row,
		const char *	col
	)

Returns the specified field as an integer.

◆ getFieldAsInteger() [2/2]

int64_t sqlrcursor::getFieldAsInteger	(	uint64_t	row,
		uint32_t	col
	)

Returns the specified field as an integer.

◆ getFieldLength() [1/2]

uint32_t sqlrcursor::getFieldLength	(	uint64_t	row,
		const char *	col
	)

Returns the length of the specified field.

◆ getFieldLength() [2/2]

uint32_t sqlrcursor::getFieldLength	(	uint64_t	row,
		uint32_t	col
	)

Returns the length of the specified field.

◆ getLongest() [1/2]

uint32_t sqlrcursor::getLongest ( const char * col )

Returns the length of the longest field in the specified column.

◆ getLongest() [2/2]

uint32_t sqlrcursor::getLongest ( uint32_t col )

Returns the length of the longest field in the specified column.

◆ getNullsAsEmptyStrings()

void sqlrcursor::getNullsAsEmptyStrings ( )

Tells the connection to return NULL fields and output bind variables as empty strings. This is the default.

◆ getNullsAsNulls()

void sqlrcursor::getNullsAsNulls ( )

Tells the connection to return NULL fields and output bind variables as NULL's rather than as empty strings.

◆ getOutputBindBlob()

const char* sqlrcursor::getOutputBindBlob ( const char * variable )

Get the value stored in a previously defined binary lob output bind variable.

◆ getOutputBindClob()

const char* sqlrcursor::getOutputBindClob ( const char * variable )

Get the value stored in a previously defined character lob output bind variable.

◆ getOutputBindCursor()

sqlrcursor* sqlrcursor::getOutputBindCursor ( const char * variable )

Get the cursor associated with a previously defined output bind variable.

◆ getOutputBindDate()

bool sqlrcursor::getOutputBindDate	(	const char *	variable,
		int16_t *	year,
		int16_t *	month,
		int16_t *	day,
		int16_t *	hour,
		int16_t *	minute,
		int16_t *	second,
		int32_t *	microsecond,
		const char **	tz,
		bool *	isnegative
	)

Get the value stored in a previously defined date output bind variable.

◆ getOutputBindDouble()

double sqlrcursor::getOutputBindDouble ( const char * variable )

Get the value stored in a previously defined decimal output bind variable.

◆ getOutputBindInteger()

int64_t sqlrcursor::getOutputBindInteger ( const char * variable )

Get the value stored in a previously defined integer output bind variable.

◆ getOutputBindLength()

uint32_t sqlrcursor::getOutputBindLength ( const char * variable )

Get the length of the value stored in a previously defined output bind variable.

◆ getOutputBindString()

const char* sqlrcursor::getOutputBindString ( const char * variable )

Get the value stored in a previously defined string output bind variable.

◆ getResultSetBufferSize()

uint64_t sqlrcursor::getResultSetBufferSize ( )

Returns the number of result set rows that will be buffered at a time or 0 for the entire result set.

◆ getResultSetId()

uint16_t sqlrcursor::getResultSetId ( )

Returns the internal ID of this result set. This parameter may be passed to another cursor for use in the resumeResultSet() method. Note: The value this method returns is only valid after a call to suspendResultSet().

◆ getRow()

const char* const* sqlrcursor::getRow ( uint64_t row )

Returns a null terminated array of the values of the fields in the specified row.

◆ getRowLengths()

uint32_t* sqlrcursor::getRowLengths ( uint64_t row )

Returns a null terminated array of the lengths of the fields in the specified row.

◆ getTableList()

bool sqlrcursor::getTableList ( const char * wild )

Sends a query that returns a list of tables matching "wild". If wild is empty or NULL then a list of all tables will be returned.

◆ inputBind() [1/5]

void sqlrcursor::inputBind	(	const char *	variable,
		const char *	value
	)

Defines a string input bind variable.

◆ inputBind() [2/5]

void sqlrcursor::inputBind	(	const char *	variable,
		const char *	value,
		uint32_t	valuelength
	)

Defines a string input bind variable.

◆ inputBind() [3/5]

void sqlrcursor::inputBind	(	const char *	variable,
		double	value,
		uint32_t	precision,
		uint32_t	scale
	)

Defines a decimal input bind variable. (If you don't have the precision and scale then set them both 0. However in that case you may get unexpected rounding behavior if the server is faking binds.)

◆ inputBind() [4/5]

void sqlrcursor::inputBind	(	const char *	variable,
		int16_t	year,
		int16_t	month,
		int16_t	day,
		int16_t	hour,
		int16_t	minute,
		int16_t	second,
		int32_t	microsecond,
		const char *	tz,
		bool	isnegative
	)

Defines a date input bind variable. "day" and "month" are 1-based.

Some databases distinguish between date, time, and datetime types. For those databases...

The input bind variable will be interpreted as a time type if year and/or month are negative.
The input bind variable will be interpreted as a date type if hour, minute, second, and/or microsecond are negative.
The input bind variable will be interpreted as a datetime type if all parts are positive.

"tz" is the timezone abbreviation, and may be left NULL. Most databases ignore "tz".

Set "isnegative" may be set to true to represent a negative time interval. However, few databases support negative time intervals and ignore "isnegative".

◆ inputBind() [5/5]

void sqlrcursor::inputBind	(	const char *	variable,
		int64_t	value
	)

Defines a integer input bind variable.

◆ inputBindBlob()

void sqlrcursor::inputBindBlob	(	const char *	variable,
		const char *	value,
		uint32_t	size
	)

Defines a binary lob input bind variable.

◆ inputBindClob()

void sqlrcursor::inputBindClob	(	const char *	variable,
		const char *	value,
		uint32_t	size
	)

Defines a character lob input bind variable.

◆ inputBinds() [1/3]

void sqlrcursor::inputBinds	(	const char **	variables,
		const char **	values
	)

Defines an array of string input bind variables.

◆ inputBinds() [2/3]

void sqlrcursor::inputBinds	(	const char **	variables,
		const double *	values,
		const uint32_t *	precisions,
		const uint32_t *	scales
	)

Defines an array of decimal input bind variables.

◆ inputBinds() [3/3]

void sqlrcursor::inputBinds	(	const char **	variables,
		const int64_t *	values
	)

Defines an array of integer input bind variables.

◆ lowerCaseColumnNames()

void sqlrcursor::lowerCaseColumnNames ( )

Columns names are converted to lower case.

◆ mixedCaseColumnNames()

void sqlrcursor::mixedCaseColumnNames ( )

Columns names are returned in the same case as they are defined in the database. This is the default.

◆ nextResultSet()

bool sqlrcursor::nextResultSet ( )

Returns true and acts like executeQuery() when there is another result set available from the server.

◆ openCachedResultSet()

bool sqlrcursor::openCachedResultSet ( const char * filename )

Opens a cached result set. Returns true on success and false on failure.

◆ prepareFileQuery()

bool sqlrcursor::prepareFileQuery	(	const char *	path,
		const char *	filename
	)

Prepare to execute the contents of "path"/"filename". Returns false if the // file couldn't be opened.

◆ prepareQuery() [1/2]

void sqlrcursor::prepareQuery ( const char * query )

Prepare to execute "query".

◆ prepareQuery() [2/2]

void sqlrcursor::prepareQuery	(	const char *	query,
		uint32_t	length
	)

Prepare to execute "query" with length "length". This method must be used if the query contains binary data.

◆ resumeCachedResultSet()

bool sqlrcursor::resumeCachedResultSet	(	uint16_t	id,
		const char *	filename
	)

Resumes a result set previously left open using suspendSession() and continues caching the result set to "filename". Returns true on success and false on failure.

◆ resumeResultSet()

bool sqlrcursor::resumeResultSet ( uint16_t id )

Resumes a result set previously left open using suspendSession(). Returns true on success and false on failure.

◆ rowCount()

uint64_t sqlrcursor::rowCount ( )

Returns the number of rows in the current result set (if the result set is being stepped through, this returns the number of rows processed so far).

◆ sendFileQuery()

bool sqlrcursor::sendFileQuery	(	const char *	path,
		const char *	filename
	)

Sends the query in file "path"/"filename" directly and gets a result set.

◆ sendQuery() [1/2]

bool sqlrcursor::sendQuery ( const char * query )

Sends "query" directly and gets a result set.

◆ sendQuery() [2/2]

bool sqlrcursor::sendQuery	(	const char *	query,
		uint32_t	length
	)

Sends "query" with length "length" directly and gets a result set. This method must be used if the query contains binary data.

◆ setCacheTtl()

void sqlrcursor::setCacheTtl ( uint32_t ttl )

Sets the time-to-live for cached result sets. The sqlr-cachemanger will remove each cached result set "ttl" seconds after it's created, provided it's scanning the directory containing the cache files.

◆ setResultSetBufferSize()

void sqlrcursor::setResultSetBufferSize ( uint64_t rows )

Sets the number of rows of the result set to buffer at a time. 0 (the default) means buffer the entire result set.

◆ substitution() [1/3]

void sqlrcursor::substitution	(	const char *	variable,
		const char *	value
	)

Defines a string substitution variable.

◆ substitution() [2/3]

void sqlrcursor::substitution	(	const char *	variable,
		double	value,
		uint32_t	precision,
		uint32_t	scale
	)

Defines a decimal substitution variable.

◆ substitution() [3/3]

void sqlrcursor::substitution	(	const char *	variable,
		int64_t	value
	)

Defines an integer substitution variable.

◆ substitutions() [1/3]

void sqlrcursor::substitutions	(	const char **	variables,
		const char **	values
	)

Defines an array of string substitution variables.

◆ substitutions() [2/3]

void sqlrcursor::substitutions	(	const char **	variables,
		const double *	values,
		const uint32_t *	precisions,
		const uint32_t *	scales
	)

Defines an array of decimal substitution variables.

◆ substitutions() [3/3]

void sqlrcursor::substitutions	(	const char **	variables,
		const int64_t *	values
	)

Defines an array of integer substitution variables.

◆ suspendResultSet()

void sqlrcursor::suspendResultSet ( )

Tells the server to leave this result set open when the connection calls suspendSession() so that another connection can connect to it using resumeResultSet() after it calls resumeSession().

◆ totalRows()

uint64_t sqlrcursor::totalRows ( )

Returns the total number of rows that will be returned in the result set. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. 0 is returned by databases which don't support this option.

◆ upperCaseColumnNames()

void sqlrcursor::upperCaseColumnNames ( )

Columns names are converted to upper case.

◆ validateBinds()

void sqlrcursor::validateBinds ( )

If you are binding to any variables that might not actually be in your query, call this to ensure that the database won't try to bind them unless they really are in the query. There is a performance penalty for calling this method.

◆ validBind()

bool sqlrcursor::validBind ( const char * variable )

Returns true if "variable" was a valid bind variable of the query.

Public Member Functions