Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 9 of 9 total |
Unable to Commit delete |
Wed, Jan 6 2016 8:05 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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. |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |