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 or Microsoft® SQL Server™ 2000 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