INF: Using Browse Mode in DB-Library

• Microsoft SQL Server Programmer's Toolkit, version 4.2

SUMMARY

The following is information on using browse mode in DB-Library (DB-Lib):

1. The table must have a Timestamp column, as follows:
   

   
         create table xxx (columnname datatype,
                           columnname datatype,
                             .
                             .
                             .
                           TIMESTAMP           )
    




2. The table must have a unique index, and the following must be true:
   
   
   1. The index must be defined before any data is added.
   
   
   
   2. The definition of primary key with sp_primary key is not required.
   
   
   



3. The SELECT statement must include the FOR BROWSE option.

MORE INFORMATION

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 : kbprg SSrvDB_Lib
Version : 4.2
Platform : OS/2
Issue type :