dbtabbrowse

Determines whether the specified table can be updated with the DB-Library browse-mode facilities.

Syntax

BOOL dbtabbrowse (
PDBPROCESS dbproc,
INT tabnum );

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.

tabnum

Is the number of the table as specified in the SELECT statement’s FROM clause. Table numbers start at 1.

Returns

TRUE or FALSE. If you drop the unique index of a table while browsing, dbtabbrowse continues to return TRUE.

Remarks

The dbtabbrowse function is one of the DB-Library browse-mode functions. For a detailed discussion of browse mode, see Browse Mode in Programming DB-Library for C

The dbtabbrowse function provides a way to identify tables that can be browsed. It is useful for examining ad hoc queries prior to performing browse-mode updates based on the queries. If the query has been hard-coded into the program, this function is unnecessary.

A table must have a unique index and a timestamp column before it can be browsed.

Call dbtabbrowse any time after calling dbresults.

See Also