ECN-GL589 Multiple rows updated or deleted caused errors

Defect Numbers: 285156 and 297028

Product: Acu4GL

Module: MSSQL

Machines Affected: All

Known Versions Affected: All

DESCRIPTION:

The following issues that occurred when a primary key allows duplicates have been fixed:

• Rewriting or deleting a row sometimes affected more than a single row.
• Executing READ followed by READ NEXT returned the wrong record.

To use this fix, both of the following conditions must be met:

• An identity column must be included. This can be either a hidden column using A-MSSQL-ADD-IDENTITY when the table is created, or an explicit column using the IDENTIY-COLUMN XFD directive.
• The record to update or delete must be the last record read.

Failure to meet these conditions results in a 9D/07 run-time error. See the Runtime Errors topic in Appendix B of your Acu4GLUser's Guide for details.