ODBC_SQLBulkOperations

4D v16


ODBC_SQLBulkOperations ( stmtID ; opération ) -> Résultat

Paramètre	Type	Description
stmtID	Entier long	Statement ID
opération	Entier long	Operation to perform
Résultat	Entier long	Returns the result of the MS ODBC API function SQLBulkOperations

Description

The ODBC_SQLBulkOperations command performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

The operation to perform are the following:

Constant	Value
SQL_ADD	4
SQL_UPDATE_BY_BOOKMARK	5
SQL_DELETE_BY_BOOKMARK	6
SQL_FETCH_BY_BOOKMARK	7

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

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NEED_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Exemple

The following method adds three rows from data in two arrays (arID and arEmployeeName) into the Employee table:

 vattrVal:=SQL_CONCUR_ROWVER

 $result:=ODBC_SQLSetStmtAttr($statementID;SQL_ATTR_CONCURRENCY;->vattrVal)

 vattrVal:=SQL_CURSOR_KEYSET_DRIVEN

 $result:=ODBC_SQLSetStmtAttr($statementID;SQL_ATTR_CURSOR_TYPE;->vattrVal)

 vattrVal:=3&NBSP;&NBSP; ` Size of the arrays that contain our values below

 $result:=ODBC_SQLSetStmtAttr($statementID;SQL_ATTR_ROW_ARRAY_SIZE;->vattrVal)

 $result:=ODBC_SQLSetStmtAttr($statementID;SQL_ATTR_ROW_STATUS_PTR;->arStatus;vIndic)

 vattrVal:=SQL_UB_VARIABLE

 $result:=ODBC_SQLSetStmtAttr($statementID;SQL_USE_BOOKMARKS;->vattrVal)

  `Use variable length bookmark

 $result:=ODBC_SQLPrepare($statementID;"SELECT * FROM Employee")&NBSP;&NBSP; `Define which table

 $result:=ODBC_SQLExecute($statementID)

 $result:=ODBC_SQLBindCol($statementID;1;->arID)&NBSP;&NBSP; `Bind the columns to arrays

 $result:=ODBC_SQLBindCol($statementID;2;->arEmployeeName)

 

 arID{1}:=1006

 arID{2}:=1007

 arID{3}:=1008

 

 arEmployeeName{1}:="John Smith"

 arEmployeeName{2}:="Betty Jones"

 arEmployeeName{3}:="Sally Peters"

 

 $result:=ODBC_SQLBulkOperations($statementID;4)&NBSP;&NBSP; `SQL_ADD

 

 $result:=ODBC_SQLRowCount($statementID;vRowCount)

Voir aussi

ODBC_SQLBindCol
ODBC_SQLRowCount
ODBC_SQLSetStmtAttr