Microsoft KB Archive/104907

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1773 (4.2)

SYMPTOMS
If a view is created by joining two or more tables using outer join, then issuing an UPDATE on the view may cause a general protection fault (GP fault).

For example, the following UPDATE command script will cause the problem:

create table testM (m1 varchar(8) null, datam varchar(8) null) create table testC (datac varchar(8) null) go  create view testview as  select * from testM, testC where testM.datam =* testC.datac go  insert testC values ("test") insert testM values ("hi","testo") go  update testview set m1="help" go

WORKAROUND
You may update the base table directly instead of updating the view.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
 * }

-

Last reviewed: April 28, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.