dbcolbrowse

Determines whether the source of a result column can be updated with the DB-Library browse-mode facilities.

Syntax

BOOL dbcolbrowse (
PDBPROCESS dbproc,
INT colnum );

Arguments

dbproc: Is the DBPROCESS structure that is the handle for a particular workstation/ Microsoft® SQL Server™ process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.
colnum: Is the number of the result column. The first column is number 1.

Returns

TRUE or FALSE.

Remarks

The dbcolbrowse function is one of the DB-Library browse-mode functions. It determines whether the database column that is the source of a result column in a select list can be updated with the DB-Library browse-mode facilities. This function is useful for examining ad hoc queries. If the query has been hard-coded into the program, dbcolbrowse is unnecessary.

The dbcolbrowse function can be called any time after dbresults.

To determine the name of the source column given the name of the result column, use dbcolsource.

Examples

Only a column derived from a table that has a unique index and a timestamp column can be updated. It cannot be the result of a Transact-SQL expression. For example, in the following select list, result columns 1 and 2 (title and category) can be updated, but column 3 (wholesale) cannot because it is the result of an expression:

SELECT title, category=type, wholesale=(price * 0.6) FROM inventory FOR BROWSE