SqlColBrowse%

Indicates whether the source of a result column can be updated with the DB-Library for Visual Basic browse-mode facilities.

Syntax

SqlColBrowse% ( sqlconn%, column% )

where

sqlconn% ( )

Is a SQL Server connection. The value of sqlconn% is returned by SqlOpen%.

column%

Is the number of the result column. The first column is number 1.

Returns

SUCCEED (1) or FAIL (0).

Remarks

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$.

Example

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

See Also

SqlColSource$, SqlQual$, SqlTabBrowse%, SqlTabCount%, SqlTabName$, SqlTabSource$, SqlTsNewLen%, SqlTsNewVal$, SqlTsPut%