Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Insert error reported in System Log.
Tue, Feb 2 2021 1:15 AMPermanent Link

Ian Branch

Avatar

Hi Guys,
I have the attached event reported in the System Events Log..
I am uncertain when in the Insert sequence this happens/is triggered.
Before Insert or After Insert.  There is no OnInsertError event so it could be one of the two or something else?
I thought I had the constraint being captured in the OnPostError event but it seems I have missed another avenue. Frown

Regards,
Ian



Attachments: Screenshot_3.jpg
Tue, Feb 2 2021 3:44 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


I don't recognise the error code - is it one of yours? If so what raises it? Looking at the Description column I'm guessing that its a constraint error of yours. If so its when the constraint fails which I'm guessing (I've never researched it) is on post rather than before or after.

What is it you're wanting to do when this error occurs?

Roy Lambert
Tue, Feb 2 2021 4:24 PMPermanent Link

Ian Branch

Avatar

Hi Roy,
Yes it's one of mine, a constraint.
It is the Insert entry in the Systems Event Log I don't understand, I can't figure if this is triggering on before Insert or on after Insert, or somewhere else.  Or am I just misreading the event.
I have the on post handling sorted, I just don't see why it is appearing in the System Events Log.

Ian
Wed, Feb 3 2021 7:53 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


In that case the best answer I can give is "Tim" <vbg>

Roy Lambert
Tue, Feb 9 2021 7:27 PMPermanent Link

Ian Branch

Avatar

Hi Team,
No, I haven't been to Tim on this, yet.
I am handling the Constraint error as follows..
{code}
procedure TdmC.JobTicketsPostError(DataSet: TDataSet; E: EDatabaseError; var Action: TDataAction);
begin
   //
   Action := daAbort;
   //
   MessageBeep(MB_ICONERROR);
   //
   if (E is EEDBError) then
   begin
       if (EEDBError(E).ErrorCode = 10001) then
       // Customer No & Customer Ref Constraint error.
           TaskMessageDlg('Invalid Data Entered!', EEDBError(E).ErrorMsg, mtWarning, [mbOK], 0)
       else
           TaskMessageDlg('Error Message!', E.Message, mtError, [mbOK], 0);
   end
   else
       TaskMessageDlg('Error message!', E.Message, mtError, [mbOK], 0);
   //
end;
{code}
I had expected that if I am intercepting the error like this, that it wouldn't end up in the System Events Log however on reflection if that was the case, none of the exceptions handled by the above would appear, so I guess the 10001 error appearing in the Log is OK/acceptable.

Regards,
Ian
Image