Discussion of issues, suggestions and bugs of Devart Excel Add-ins, our product line for connecting Excel to external data from cloud applications and databases
2 posts • Page 1 of 1
CHECK constraints and triggers work on the database side. Please enable Options > Edit > General > "Refresh all columns after commit" to retrieve the actual data inserted in the table.dwimberly wrote:Can I use CHECK constraints? What about a trigger?
Options > Edit > Error Handling > "Use transaction" allows you either insert all records or none of them if any error.dwimberly wrote:Can I validate multiple columns in a single pass?