DataLink.EndEdit() behavior

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
ahijazi
Posts: 47
Joined: Mon 01 Oct 2007 11:13

DataLink.EndEdit() behavior

Post by ahijazi » Mon 23 Jan 2017 09:14

Dear Devart;
Using the Depts table as test case with the following structure:

Code: Select all

create table depts( oid number(8) not null, name varchar2(200), dept_desc varchar2(200),  notes varchar2(200) );

alter table depts  add constraint dept_pk primary key (oid);
alter table depts  add constraint dept_ck  check (oid < 100);

Building a simple WinForm with DataTable(CachedUpdates = false), DataLink, and four Textedits bonded to the Depts fields, and follow next steps:
1. Run the WinForm, open DataTable. Textedits will show the current record.
2. Edit Name, and Dept_Desc with new values.
3. Edit OID with value > 100, and execute DataLink.EndEdit() method, an exception is raised because of dept_ck constraint.
4. Re-edit OID with value < 100 and re-execute DataLink.EndEdit() method, no exception is raised, but the value of the Name, and Dept_Desc is reverted to the original values !!!!!!!!!, so I losses the edits done before the Exception is raised !!!!!!!!!!!!

How can I solve such an issue.

OraConnect: 9.1.131
Dev Lang: C#
Dev IDE: Visual Studio 2012
Database: Oracle 12c

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: DataLink.EndEdit() behavior

Post by Pinturiccio » Mon 23 Jan 2017 16:17

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: DataLink.EndEdit() behavior

Post by Pinturiccio » Tue 07 Nov 2017 16:12

We have answered you on our forum viewtopic.php?t=36110

Post Reply