PRB: Error 3219 When Updating Record Set Created w/ Distinct (104459)
The information in this article applies to:
- Microsoft Visual Basic Standard Edition for Windows 3.0
This article was previously published under Q104459 SYMPTOMS
Trying to perform an update on a result set created with the Distinct
predicate results in error 3219 "Can't perform operation, it is illegal."
CAUSE
An object variable or a data control result set created with the Distinct
predicate is not updatable according to Help. The following statement is in
the Distinct keyword Help topic:
The output of a query that uses Distinct is not updatable and doesn't
reflect subsequent changes made by other users. Therefore, when you use
the Distinct predicate in a query, you are prevented from trying to
update your records.
WORKAROUND
The only workaround at this time is to not use the DISTINCT predicate
to build the results set. Note that you may have to handle the
duplicates by some other coding means.
STATUS
This behavior is by design.
Modification Type: | Minor | Last Reviewed: | 1/8/2003 |
---|
Keywords: | kbprb KB104459 |
---|
|