Hi Team,
If I handle a constraint like this for PostOnError...
{code}
 //
 if (E is EEDBError) then begin
   //
   case EEDBError(E).ErrorCode of
   EDB_ERROR_CONSTRAINT: begin
       tdConstraint.Content.Text := sMessage + 'has a data constraint error.' + #13 + EEDBError(E).ErrorMsg + #13 +
         'You will be returned to the Jobticket to correct either the Customer # and/or the Customer Reference.';
       tdConstraint.Execute;
       Action := daAbort;
     end;
   //
....
....
{code}

Should it still write the error to the System events Log?
"The unique constraint DupCustRefCheck for the table JobTickets has been violated (Duplicate key 466,VD75703 found)"

Regards & TIA,
Ian

Ian


My personal view is yes.

This is based on Tim having no idea what code you are writing and by the time you handle the error it has already happened and trying to figure out wether or not its been handled in a satisfactory way or not would be a little difficult.

Roy Lambert

Hi Roy,
Fair enough.  I was just worried that my handling wasn't happening.

Regards,
Ian