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 :
Last Reviewed: March 6, 1999