Ticket Q581672
Visible to All Users
Duplicate

TcxDBTreeList - The "EDatabase error" exception occurs when editing data of a bound dataset within the BeginUpdate/EndUpdate block

created 11 years ago

Hello.
I use a DxMemDataSet which is bound to a TcxDBTreeList.
When editing values of the DataSet within a BeginUpdate/EndUpdate block an exception "DataSet not in edit or insert mode" is thrown.
Attached is a demo app demonstrating the problem.
Regards,
Torsten Lang

Answers approved by DevExpress Support

created 11 years ago (modified 11 years ago)

This issue seems to be caused by the incorrect fixing of the TcxDBTreeList - The "EDatabase error" exception occurs when opening a bound dataset and populating it with data within the BeginUpdate/EndUpdate block problem. I have posted the modified (correct) hotfix code there, so please download the patch from TcxDBTreeList - The "EDatabase error" exception occurs when opening a bound dataset and populating it with data within the BeginUpdate/EndUpdate block and apply it to VCL 13.2.4. This should solve the problem.

    created 11 years ago (modified 11 years ago)

    Hello Torsten,
    This problem occurs because of the fix from the Q574440 thread.
    This problem will be fixed in the frames of the Q580604: FocusedNode not working when DataSet is set at runtime. ticket. So I've marked this ticket as duplicated.

      Comments (1)
      DevExpress Support Team 11 years ago

        Follow-up:
        In addition, I suggest you use the DataSet's DisableControls/EnableControls methods instead of TreeList's BeginUpdate/EndUpdate ones. This will help you avoid this error, prevent DataSet notifications to TreeList and improve the performance.

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.