List of functions in dbi.inc

This will return a number equal to or below 0 on failure.
If it does fail, the error will be mirrored in dbi_error()
The return value will otherwise be a resource handle, not an
OK code or cell pointer.

This will do a simple query execution on the SQL server.
If it fails, it will return a number BELOW ZERO (0)
If zero, it succeeded with NO RETURN RESULT.
If greater than zero, make sure to call dbi_free_result() on it!
 The return is a handle to the result set

Has the same usage as dbi_query, but this native returns by
reference the number of rows affected in the query. If the
query fails rows will be equal to -1.

Returns 0 on failure or End of Results.
Advances result pointer by one row.

Gets a field by number.  Returns 0 on failure.
Although internally fields always start from 0,
This function takes fieldnum starting from 1.
No extra params: returns int
One extra param: returns Float: byref
Two extra param: Stores string with length

Gets a field by name.  Returns 0 on failure.
One extra param: returns Float: byref
Two extra param: Stores string with length

Returns the number of rows returned from a query

Frees memory used by a result handle.  Do this or get memory leaks.

Closes a database handle.  Internally, it will also
mark the handle as free, so this particular handle may
be re-used in the future to save time.

Returns an error message set.  For PGSQL and MySQL,
this is a direct error return from the database handle/API.
For MSSQL, it returns the last error message found from a
thrown exception.

Returns the type of database being used.  So far:
"mysql", "pgsql", "mssql", "sqlite"

Returns the number of fields/colums in a result set.
Unlike dbi_nextrow, you must pass a valid result handle.

Retrieves the name of a field/column in a result set.
Requires a valid result handle, and columns are numbered 1 to n.

This function can be used to find out if a table in a Sqlite database exists.