Microsoft KB Archive/42303
INF: Using Browse Mode in DB-Library
The information in this article applies to:
- Microsoft SQL Server Programmer's Toolkit, version 4.2
The following is information on using browse mode in DB-Library (DB-Lib):
The table must have a Timestamp column, as follows:
create table xxx (columnname datatype, columnname datatype, . . . TIMESTAMP )
- The table must have a unique index, and the following must be true:
- The index must be defined before any data is added.
- The definition of primary key with sp_primary key is not required.
- The SELECT statement must include the FOR BROWSE option.
The dbtabbrowse function indicates whether browse is permitted on a table. If the return value from dbtabbrowse is not 1 after the dbresults for the SELECT...FOR BROWSE, browse will not work. Check that the table has a unique index and that the Timestamp column contains non-null data.
SELECT * FROM... after data is added to the table should produce values in the Timestamp field even though no values were entered on the INSERT statement.
Additional query words: dblib
Keywords : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420
Last Reviewed: March 7, 1999