bcp_colptr

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

Syntax

RETCODE bcp_colptr (
PDBPROCESS dbproc,
LPCBYTE colptr,
INT table_column );

where

dbproc

Is the DBPROCESS structure that is the handle for a particular workstation/ SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

colptr

Is the address of the program variable.

table_column

Is the column in the SQL Server table to which the data is copied. Column numbers start at 1.

Returns

SUCCEED or FAIL.

Remarks

The bcp_colptr function allows you to change the program variable data address for a particular column while running a copy IN through calls to bcp_bind.

Initially, the program variable data address is determined when bcp_bind is called. If the program variable data address changes between calls to bcp_sendrow, you can call bcp_colptr to reset the address of the data. The next call to bcp_sendrow uses the data at the address you just set.

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_collen, bcp_sendrow