INF: Why dbqual() Returns Null WHERE Clause in Browse Mode

ID: Q45263

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

If the specified table does not have a unique index (or primary key) and timestamp, dbqual() will return a null WHERE clause. Dbtabbrowse() indicates whether or not a table can be updated using dbqual().

If dbtabbrowse() returns true for the table, and dbqual() still returns a null WHERE clause, you need to verify that the TIMESTAMP column is not null. This situation can occur if a timestamp column is added to a table with an ALTER statement after the table was created. A simple update such as "UPDATE TableX set ColA = ColA" will ensure that the TIMESTAMP in every record contains a value.

Additional query words: DB-Library DB-Lib dblib

Keywords : kbprg SSrvDB_Lib
Version : 4.2
Platform : OS/2
Issue type :