Microsoft KB Archive/45263
INF: Why dbqual() Returns Null WHERE Clause in Browse Mode
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 : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420
Last Reviewed: March 7, 1999