4D Doc Center : ODBC_SQLColumnPrivileges

Home

4D v14.1

ODBC_SQLColumnPrivileges


ODBC_SQLColumnPrivileges ( stmtID ; catalogName ; schemaName ; tableName ; columnName ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
catalogName	Text	Catalog name
schemaName	Text	Schema name
tableName	Text	Table name
columnName	Text	Column name
Function result	Longint	Returns the result of the MS ODBC API function SQLColumnPrivileges

Description

The ODBC_SQLColumnPrivileges command returns a list of columns and associated privileges for the specified table. The driver returns the information as a result set on the specified stmtID.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the catalog name.

schemaName is the schema name.

tableName is the table name.

columnName is the string search pattern for column names.

For more information, please see the SQLColumnPrivileges function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms716336(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.