Cicode Programming Reference > Cicode Function Categories > SQL Functions Introduction > SQL Functions

SQL Functions

Following are functions related to SQL operations:

ExecuteDTSPkg

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

SQLAppend

Appends a text string to the SQL buffer.

SQLBeginTran

Starts a database transaction.

SQLCommit

Commits a transaction to the database.

SQLConnect

Makes a connection to a database system for execution of SQL statements.

SQLDisconnect

Closes a database connection.

SQLEnd

Terminates an SQL query.

SQLErrMsg

Returns an error message from the SQL system.

SQLExec

Executes an SQL query on a database.

SQLFieldInfo

Gets information about the fields or columns selected in an SQL query.

SQLGetField

Gets field or column data from a database record.

SQLInfo

Gets information about a database connection.

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.

SQLRollBack

Rolls back (or cancels) the last database transaction.

SQLSet

Sets a statement string in the SQL buffer.

SQLTraceOff

Turns off the debug trace.

SQLTraceOn

Turns on the debug trace.

See Also

Cicode Functions