bcp_colptr (ODBC)

Sets the program variable data address for the current copy into Microsoft® SQL Server™.

Syntax

RETCODE bcp_colptr (
HDBC
hdbc,
LPCBYTE
pData,
INT
idxServerCol );

Arguments
hdbc
Is the bulk copy-enabled ODBC connection handle.
pData
Is a pointer to the data to copy. If the bound data type is SQLTEXT, SQLNTEXT, or SQLIMAGE, pData can be NULL. A NULL pData indicates long data values will be sent to SQL Server in chunks using bcp_moretext.
idxServerCol
Is the ordinal position of the column in the database table to which the data is copied. The first column in a table is column 1. The ordinal position of a column is reported by SQLColumns.
Returns

SUCCEED or FAIL.

Remarks

The bcp_colptr function allows you to change the address of source data for a particular column when copying data to SQL Server with bcp_sendrow.

Initially, the pointer to user data is set by a call to bcp_bind. If the program variable data address changes between calls to bcp_sendrow, you can call bcp_colptr to reset the pointer to the data. The next call to bcp_sendrow sends the data addressed by the call to bcp_colptr.

There must be a separate bcp_colptr call for every column in the table whose data address you want to modify.

See Also
bcp_bind bcp_sendrow
bcp_collen SQLColumns
bcp_moretext  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.