PRSQL9105007: SELECT..FOR BROWSE Fails with NULL TIMESTAMP

ID Number: Q75161

1.10

OS/2

Summary:

Problem ID: PRSQL9105007

SYMPTOMS

While executing a SELECT .. FOR BROWSE command, the following error

message is received:

Attempting to insert NULL value into column .. in work table..;

column does not allow NULLS. Update fails.

CAUSE

SQL Server does not correctly execute the FOR BROWSE command when

the table contains a TIMESTAMP column that contains NULL values.

WORKAROUND

Include the TIMESTAMP column in the SELECT list. This is done

explicitly using

SELECT columns, TIMESTAMP FROM...

or implicitly using

SELECT * FROM...

STATUS

Microsoft has confirmed this to be a problem with SQL Server

version 1.1. Microsoft is researching this problem and will post

new information here as it becomes available.