ODBC_SQLBulkOperations

4D v16


ODBC_SQLBulkOperations ( stmtID ; operaçao ) -> Resultado

Parâmetro	Tipo	Descrição
stmtID	Inteiro longo	Statement ID
operaçao	Inteiro longo	Operation to perform
Resultado	Inteiro longo	Returns the result of the MS ODBC API function SQLBulkOperations

Descrição

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.

Exemplo

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)

Ver também

ODBC_SQLBindCol
ODBC_SQLRowCount
ODBC_SQLSetStmtAttr