I use an ADO query ( insert into ...) to add a record to a table, and execute using qry->ExecSQL()
If there's an index violation (duplicate key / illegal empty field etc) it throws an exception. Can't I trap that somehow? The query component has OnPostError and OnEditError but they don't get called? Or do I have to try to insert the record a different way?