SQLInfo

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

SQLInfo

Gets information about a database connection.

Syntax

SQLInfo(hSQL, Type)

hSQL:

The handle to the SQL connection, returned from the SQLConnect() function. The SQL connection handle identifies the table where details of the associated SQL connection are stored.

Type:

The type of information to get:

0 - The connection string

1 - The current SQL statement

2 - The current database filename (only works with SQL device)

3 - The SQL format handle

4 - The current Q+E library SQL handle. This handle can be used with functions in the Q+E library which can be called in Cicode with the DLL functions.

Return Value

The information (as a string).

Related Functions

SQLBeginTran, SQLCommit, SQLConnect, SQLDisconnect, SQLEnd, SQLErrMsg, SQLExec, SQLFieldInfo, SQLGetField, SQLNext, SQLNoFields, SQLNumChange, SQLRollBack, SQLTraceOff, SQLTraceOn

Example

SQLInfo(1,2);