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. |