F90SQL-lite: Detailed Description of Features

f90SQL-Lite offers access to most Core ODBC API (ver. 3.5) functions. With these functions you can:

	Allocate handles using f90SQLAllocHandle and f90SQLFreeHandle (also ver. 2.0 API functions f90SQLAllocEnv, f90SQLAllocConnect and f90SQLAllocStmt are supported).
	Use all forms of f90SQLFreeStmt.
	Bind result sets using f90SQLBindCol
	Manage cursors and cursor names, by calling f90SQLCloseCursor, f90SQLGetCursorName, and f90SQLSetCursorName.
	Gain access to the description (metadata) of result sets, by calling f90SQLColAttribute, f90SQLDescribeCol, f90SQLNumResultCols, and f90SQLRowCount.
	Query the data dictionary, by calling the catalog functions f90SQLColumns, f90SQLGetTypeInfo, f90SQLStatistics and f90SQLTables.
	Manage data sources and connections, by calling f90SQLConnect and f90SQLDisconnect.
	Obtain information on drivers, no matter which ODBC level they support, by calling f90SQLDrivers.
	Execute SQL statements, by calling f90SQLExecDirect.
	Fetch one row of a result set or multiple rows, in the forward direction only, by calling f90SQLFetch or by calling f90SQLFetchScroll with the FetchOrientation argument set to SQL_FETCH_NEXT.
	Obtain current values of all attributes, by calling f90SQLGetConnectAttr, f90SQLGetEnvAttr, and f90SQLGetStmtAttr; and set all attributes to their default values and set certain attributes to non-default values by calling f90SQLSetConnectAttr, f90SQLSetEnvAttr, and f90SQLSetStmtAttr.
	Obtain diagnostic information, by calling f90SQLGetDiagField and f90SQLGetDiagRec.
	Detect driver capabilities, by calling f90SQLGetFunctions and f90SQLGetInfo. Also, detect the result of any text substitutions made to an SQL statement before it is sent to the data source, by calling f90SQLNativeSql.
	Use the syntax of f90SQLEndTran to commit a transaction.
	Call f90SQLCancel to cancel the data-at-execution dialog and, in multithread environments, to cancel an ODBC function executing in another thread. (Core-level interface conformance does not mandate support for asynchronous execution of functions, nor the use of f90SQLCancel to cancel an ODBC function executing asynchronously).
	Obtain the SQL_BEST_ROWID row-identifying column of tables, by calling f90SQLSpecialColumns.