RFX_Long_Bulk

void RFX_Long_Bulk( CFieldExchange* pFX, LPCTSTR szName, long** prgLongVals, long** prgLengths );

Parameters

pFX

A pointer to a CFieldExchange object. This object contains information to define the context for each call of the function. For more information, see the article Record Field Exchange: How RFX Works in Visual C++ Programmer’s Guide.

szName

The name of a data column.

prgLongVals

A pointer to an array of long integers. This array will store the data to be transferred from the data source to the recordset.

prgLengths

A pointer to an array of long integers. This array will store the length in bytes of each value in the array pointed to by prgLongVals. Note that the value SQL_NULL_DATA will be stored if the corresponding data item contains a Null value. For more details, see the ODBC API function SQLBindCol in the ODBC SDK Programmer's Reference.

Remarks

The RFX_Long_Bulk function transfers multiple rows of long integer data from a column of an ODBC data source to a corresponding array in a CRecordset-derived object. The data source column must have an ODBC type of SQL_INTEGER. The recordset must define a field data member of type pointer to long.

If you initialize prgLongVals and prgLengths to NULL, then the arrays they point to will be allocated automatically, with sizes equal to the rowset size.

Note Bulk record field exchange only transfers data from the data source to the recordset object. In order to make your recordset updatable, you must use the ODBC API function SQLSetPos. For an example of how to do this, see the sample DBFETCH.

For more information, see the articles Recordset: Fetching Records in Bulk (ODBC) and Record Field Exchange (RFX) in Visual C++ Programmer’s Guide.

Example

See RFX_Text_Bulk.