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


Gets information about a database connection.


SQLInfo(hSQL, Type)


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.


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



See Also

SQL Functions