ODBCDatabase.GetInfo

From Xojo Documentation

Revision as of 15:48, 20 June 2019 by Gperlman (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Method

ODBCDatabase.GetInfo(Attribute as Integer) As Variant

Supported for all project types and targets.

Returns general information about the driver and data source associated with a connection.

Returns a Variant that contains either a String or an Integer, based on the attribute.

Notes

ODBCConstant contains integer values that you can use with this function.

References

SQLGetInfo ODBC funtion

Example

Check if the connected ODBC database supports stored procedures:

Dim db As New ODBCDatabase

If Not db.Connect Then
MsgBox("Error: " + db.ErrorMessage)
End If

MsgBox(db.GetInfo(ODBCConstant.SQL_PROCEDURES))