Code: Select all
DELETE FROM PermissionAssignments &&WHERECLAUSE
Code: Select all
if (tables.ADMIN_USERS_WITH_INVALID_PERMISSIONS.PermissionWhereClauseID.value != 1) {
tables.ADMIN_USERS_WITH_INVALID_PERMISSIONS.WHERECLAUSE.value="WHERE UserID=&&ResolutionUserID AND PermissionID=&&ResolutionPermissionID";
} else {
tables.ADMIN_USERS_WITH_INVALID_PERMISSIONS.WHERECLAUSE.value="WHERE UserID=&&ResolutionUserID";
}
The call to updateTable() causes this error
Code: Select all
Wrapped com.ebasetech.xi.exceptions.FormRuntimeException: unable to set column ResolutionUserID with type INTEGER from table column with type INTEGER, types incompatible? - Invalid parameter index 1. (ADMIN_INVALIDPERMISSIONS_REMOVEPERMS_CHANGE#17)