4D v16

ODBC_SQLPrimaryKeys

ホーム

 
4D v16
ODBC_SQLPrimaryKeys

ODBC_SQLPrimaryKeys 


 

ODBC_SQLPrimaryKeys ( stmtID ; catalogName ; schemaName ; tableName ) -> 戻り値 
引数   説明
stmtID  倍長整数 in Statement ID
catalogName  文字 in Catalog name
schemaName  文字 in String search pattern for schema names
tableName  文字 in String search pattern for table names
戻り値  倍長整数 in Returns the result of the MS ODBC API function SQLPrimaryKeys

説明   

The ODBC_SQLPrimaryKeys command returns column names that make up the primary key for a table. The driver returns the information as a result set. This command does not support returning primary keys from multiple tables in a single call.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the catalog name.

schemaName is the string search pattern for schema names.

tableName is the string search pattern for table names.

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.



参照 

ODBC_SQLForeignKeys

 
プロパティ 

プロダクト: 4D
テーマ: ODBC_Catalog functions
番号: 16943

 
履歴 

初出: 4D ODBC Pro 2004

 
ARTICLE USAGE

4D ODBC Pro ( 4D v16)