SqlBCPSetL%

Sets the loginrec% to enable bulk-copy operations.

Syntax

SqlBCPSetL% ( loginrec%, enable% )

where

loginrec%

Is a login record that is passed as a parameter to SqlOpen%. You get a login record by calling SqlLogin%.

enable%

Is a Boolean value, TRUE ( - 1 or 1) or FALSE (0), that specifies whether or not to enable bulk-copy operations for the resulting SQL Server connection. By default, SQL Server connections are not enabled for bulk-copy operations.

Returns

SUCCEED (1) or FAIL (0).

Remarks

SqlBCPSetL% sets a field in the login record that tells SQL Server that the sqlconn% connection can be used for bulk-copy operations. For SqlBCPSetL% to be effective, you must call it before you call SqlOpen%. SqlOpen% is the function that actually allocates the SQL Server connection.

To keep users from initiating a bulk-copy sequence with SQL statements, avoid using this function in applications that permit ad hoc queries. Once a bulk-copy sequence begins, it cannot be stopped with an ordinary SQL statement.

See Also

SqlBCPInit%, SqlLogin%, SqlOpen%