Functions

sqlx.inc

Function Type Description
SQL_AffectedRows native Returns the number of affected rows by a query.
SQL_Connect native Opens a database connection.
SQL_Execute native Executes an already prepared query.
SQL_FieldNameToNum native Retrieves the number of a named column.
SQL_FieldNumToName native Retrieves the name of a column by its index.
SQL_FreeHandle native Frees an SQL handle.
SQL_GetAffinity native Retrieves which driver is this plugin currently bound to.
SQL_GetInsertId native Retrieves the instert ID of the latest INSERT query.
SQL_GetQueryString native Returns the original query string that a query handle used.
SQL_IsNull native Tells whether a specific column in the current row is NULL or not.
SQL_MakeDbTuple native Creates a connection information tuple. This tuple must be passed
into connection routines.
SQL_MoreResults native Checks whether there are more results to be read.
SQL_NextResultSet native For queries which return multiple result sets, this advances to the next
result set if one is available. Otherwise, the current result set is
destroyed and will no longer be accessible.
SQL_NextRow native Advances to the next result (row).
SQL_NumColumns native Returns the total number of columns.
SQL_NumResults native The number of retrieved rows (results) after a query.
SQL_PrepareQuery native Prepares a query.
SQL_QueryError native Gets information about a failed query error.
SQL_QuoteString native Back-quotes characters in a string for database querying.
SQL_QuoteStringFmt native Back-quotes characters in a string for database querying.
Note: The buffer's maximum size should be 2*strlen(string) to catch
all scenarios.
SQL_ReadResult native Retrieves the current result.
SQL_Rewind native Rewinds a result set to the first row.
SQL_SetAffinity native Sets driver affinity. You can use this to force a particular driver implementation.
This will automatically change all SQL natives in your plugin to be "bound" to
the module in question.
SQL_SetCharset native Sets the character set of the current connection.
Like SET NAMES .. in mysql, but stays after connection problems.
SQL_ThreadQuery native Prepares and executes a threaded query.
SQL_MakeStdTuple stock Use this for making a standard DB Tuple, using AMXX's database info cvars.
SQL_QueryAndIgnore stock Use this for executing a query and not caring about the error.
SQL_SimpleQuery stock Use this for executing a query where you don't care about the result.
SQL_SimpleQueryFmt stock Use this for executing a query where you don't care about the result.
sqlite_TableExists stock This function can be used to find out if a table in a SQLite database exists.