Postgres 9.6
Devart 2.2.283.0
MS Excel: Office 365 version 1912
Hello,
We're using the EXCEL add-in for postgres. Because of the complexity of the database, we have an updateable view to make it easy for user to edit. However, Devart is not working with this and giving the message “Table does not have columns that uniquely identify rows (primary key or non-nullable index columns)…”
There are columns that form a logic primary key, but a view cannot have an index in postgres. Is there a way I can tell Devart what the ‘unique index’ fields are?
Thanks in advance
Search found 1 match
Search found 1 match
• Page 1 of 1
- by drobert
- Sun 19 Jan 2020 23:39
- Forum: Excel Add-ins
- Topic: Excel add-in with updateable views
- Replies: 1
- Views: 19051
Search found 1 match
• Page 1 of 1
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins