Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Unable to Commit delete
Wed, Jan 6 2016 8:05 PMPermanent Link

Trinione

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.

However, the following does not work.

 Database.StartTransaction;
 with DataSetName do
 begin               
   First;
   while not EOF do
   begin
     Delete;
   end;
 end;
 Database.Commit;
Thu, Jan 7 2016 11:04 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

<< 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 >>

This is a normal error caused by a read-only TField in the dataset handling in the web server.  Please post your EDB table structure (SQL), and I'll tell you what the problem is.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Jan 7 2016 11:15 AMPermanent Link

Trinione

Tim:
<< This is a normal error caused by a read-only TField in the dataset handling in the web server. >>


<< Please post your EDB table structure (SQL), and I'll tell you what the problem is. >>

Here is the info from the SQL tab for the table. Is this what you mean?

CREATE TABLE "UserAccess"
(
"userAccessID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1),
"accessOptionID" INTEGER,
"userID" INTEGER,
CONSTRAINT "pk_userAccessID" PRIMARY KEY ("userAccessID")
)

**********

The DataSet query is:
SELECT * FROM UserAccess WHERE userID =  {userID=1}

BaseTable: UserAccess

**********

All DataSet colums are set to ReadOnly = False
Thu, Jan 7 2016 11:21 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Here is the info from the SQL tab for the table. Is this what you mean? >>

Yep.

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.

I'll have to issue a fix for this.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Jan 7 2016 11:27 AMPermanent Link

Trinione

<< 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. I'll have to issue a fix for this. >>

Ah. Ok.

Since I need this to work now, I am guessing a workaround would be to create the field with the 'GENERATED BY DEFAULT' and move it along until the next release when this fix ought to be included?
Thu, Jan 7 2016 11:36 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Since I need this to work now, I am guessing a workaround would be to create the field with the 'GENERATED BY DEFAULT' and move it along until the next release when this fix ought to be included? >>

Yes, that will fix it also.

Tim Young
Elevate Software
www.elevatesoft.com
Fri, Aug 5 2016 4:40 PMPermanent Link

Trinione

<< Since I need this to work now, I am guessing a workaround would be to create the field with the 'GENERATED BY DEFAULT' and move it along until the next release when this fix ought to be included? >>
<< Yes, that will fix it also. >>

Tim:
I have not checked 2.05 beta for this. But, after a harrowing 3 hours of tests, searches online, resetting user permissions all over the place, etc. LOL... I happened upon this error yet again.

Just a reminder and hope that it is fixed in 2.05.
Tue, Aug 9 2016 8:31 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Just a reminder and hope that it is fixed in 2.05. >>

http://www.elevatesoft.com/incident?action=viewrep&category=ewb&release=2.04&incident=4387

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Aug 9 2016 10:37 AMPermanent Link

Trinione

<< http://www.elevatesoft.com/incident?action=viewrep&category=ewb&release=2.04&incident=4387 >>

Thank you.

I shall endeavour to check the Incident Report area going forward. I tend to peruse the Forum only.
Image