BUG: ADO/SHAPE Generates Incorrect UPDATE Statement When Using UNION Clause (304277)
The information in this article applies to:
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.6 SP1
- Microsoft Data Access Components 2.7
- Microsoft Data Access Components 2.8
This article was previously published under Q304277 SYMPTOMS If you issue a SHAPE command whose child recordset contains a UNION clause, and the
UNION creates a single resultset from multiple different tables with different
schema, the UNION works because the fields are concatenated in such a way that
the resulting resultsets have the same fields. However, if you try to
update a field in the resulting child recordset, you may receive one of the
following error messages: -2147467259 Key column
information is insufficient or incorrect. Too many rows were affected by
update. -2147217864 Row cannot be located for
updating. Some values may have been changed since it was last read.
In the first case, several rows are updated in the base tables, and sometimes
the updates are performed in the wrong table. With the second error, no rows
are updated. STATUSMicrosoft has confirmed that this is a bug in the Microsoft
products that are listed at the beginning of this article.
Modification Type: | Minor | Last Reviewed: | 11/3/2003 |
---|
Keywords: | kbbug kbpending KB304277 |
---|
|