4D v13
ODBC_SQLPrimaryKeys
ODBC_SQLPrimaryKeys
| ODBC_SQLPrimaryKeys ( stmtID ; catalogName ; schemaName ; tableName ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| stmtID | Longint |
|
Statement ID | |||||
| catalogName | String |
|
Catalog name | |||||
| schemaName | String |
|
String search pattern for schema names | |||||
| tableName | String |
|
String search pattern for table names | |||||
| Function result | Longint |
|
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.
Product: 4D
Theme: ODBC_Catalog functions
Number:
16943
Created: 4D ODBC Pro 2004
