Microsoft KB Archive/45263

From BetaArchive Wiki

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
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.