View Incident Report

Serious

Reported By: Brian Lewis
Reported On: 1/6/2016
For: Version 2.04 Build 1

# 4387 ElevateDB Generated Identity Columns Cause Read-Only Error During Transaction Commit

I get the following error when trying to execute this transaction:

Application Error: Database commit response error (ElevateDB Error #1011 An error occurred with the column tbl_id (The assignment target is read-only)) ... Line: 19712

The table has a Primary Key on the tbl_id field.

 Database.StartTransaction;
 with DataSetName do
 begin               
   First;
   while not EOF do
   begin
     Delete;
   end;
 end;
 Database.Commit;

Comments and Workarounds

The problem is with EWB's handling of ElevateDB identity columns, which are marked as read-only when they're GENERATED ALWAYS instead of GENERATED BY DEFAULT. The workaround is to use GENERATED BY DEFAULT instead.

Resolution

Fixed Problem on 1/8/2016 in version 2.05 build 1

Products Affected

Elevate Web Builder
Elevate Web Builder Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap