Indicates whether the source of a result column can be updated with the DB-Library for Visual Basic browse-mode facilities.
SqlColBrowse% ( sqlconn%, column% )
where
SUCCEED (1) or FAIL (0).
SqlColBrowse% is a DB-Library for Visual Basic browse-mode function. For a detailed discussion of browse mode, see DB-Library for Visual Basic Programming.
SqlColBrowse% determines whether the database column that is the source of a result column in a select list can be updated with the DB-Library for Visual Basic browse-mode facilities. SqlColBrowse% is useful for examining ad hoc queries. When a query has been hard-coded into the application, SqlColBrowse% is unnecessary.
You can call SqlColBrowse% any time after you call SqlResults%.
To determine the name of the source column, use SqlColSource$.
Only a column derived from a table that has a unique index and a timestamp column can be updated. The column 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
SqlColSource$, SqlQual$, SqlTabBrowse%, SqlTabCount%, SqlTabName$, SqlTabSource$, SqlTsNewLen%, SqlTsNewVal$, SqlTsPut%