Microsoft KB Archive/45263

{|
 * width="100%"|

INF: Why dbqual Returns Null WHERE Clause in Browse Mode

 * }

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 &quot;UPDATE TableX set ColA = ColA&quot; 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