Insert/Update using composite unique index
Oracle Database 12c
Devart Excel Add-in Version : 1.8.868.0
Microsoft Excel 2016 MSO (16.0.9126.2295) 32-bit
We recently purchased devart license and our goal is enter to/modify data in database table. We setup devart connection to database and was able to select the table and view data. Now if we try to enter new data or edit existing data, we get following error message.
"Data cannot be edited because the table does not have columns that uniquely identify rows (primary key or unique index columns)".
Our data set doesn't have a primary key. So we defined a composite unique index as combination of 5 columns. But we are still getting the same error.
Please let us know if the usage of unique composite index is supported ?