7065 Updates to records must meet the conditions of the SQL SELECT statement because the Constrained option has been selected

Advantage Error Guide

Problem: The updated record did not meet the WHERE clause of the SQL SELECT statement.

Solution: To correct this, turn off the CONSTRAINED option of the Advantage Client Engine SQL statement.