SQL Functions

Following are functions related to SQL operations.

Miscellaneous functions

Loads and executes a Data Transformation Services package which initiates data transfer between OLE DB data sources.

Connection functions

SQLClose	Closes a SQL connection between the DB connection object and a database.
SQLConnect	Makes a connection to a database system for execution of SQL statements.
SQLCreate	Creates an internal DB connection object.
SQLDisconnect	Closes a database connection.
SQLDispose	Disposes the DB connection object.
SQLInfo	Gets information about a database connection.
SQLOpen	Opens an SQL connection between the DB connection object and the database.

Transaction functions

SQLBeginTran	Starts a database transaction.
SQLCommit	Commits a transaction to the database.
SQLRollBack	Rolls back (or cancels) the last database transaction.

Statement functions

SQLAppend	Appends a text string to the SQL buffer.
SQLCall	Executes an SQL query on a database.
SQLEnd	Terminates an SQL query.
SQLExec	Executes an SQL query on a database.
SQLGetRecordset	Executes an SQL query on a database.
SQLGetScalar	Executes an SQL query on a database.
SQLSet	Sets a statement string in the SQL buffer.

Multiple queries functions

SQLQueryCreate	Creates a new query and returns its handle.
SQLQueryDispose	Disposes a query.

Recordset functions

SQLCancel	Cancels both the current operation on the given connection and all other pending operations on the given connection.
SQLFieldInfo	Gets information about the fields or columns selected in an SQL query.
SQLGetField	Gets field or column data from a database record.
SQLIsNullField	Checks presence of null value in field from a recordset.
SQLNext	Gets the next database record from a SQL query.
SQLNoFields	Gets the number of fields or columns that were returned by the last SQL statement.
SQLNumChange	Gets the number of records that were modified in the last insert, update, or delete SQL statement.
SQLNumFields	Gets the number of fields or columns that were returned by the last SQL statement.
SQLPrev	Gets the previous database record from an SQL query.
SQLRowCount	Gets the number of rows in the recordset.

Error and tracing functions

SQLErrMsg	Returns an error message from the SQL system.
SQLTraceOff	Turns off the debug trace.
SQLTraceOn	Turns on the debug trace.

Parametized queries functions

SQLParamsClearAll	Remove all parameters associated with a particular connection object.
SQLParamsSetAsInt	Adds or replaces a parameterized query's parameter and its value in the specified connection. The value of the parameter is given as an int.
SQLParamsSetAsReal	Adds or replaces a parameterized query's parameter and its value in the specified connection. The value of the parameter is given as a real.
SQLParamsSetAsString	Adds or replaces a parameterized query's parameter and its value in the specified connection.T he value of the parameter is given as a string.