Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Insert error reported in System Log. |
Tue, Feb 2 2021 1:15 AM | Permanent Link |
Ian Branch | 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. Regards, Ian Attachments: Screenshot_3.jpg |
Tue, Feb 2 2021 3:44 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Ian Branch | 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
In that case the best answer I can give is "Tim" <vbg> Roy Lambert |
Tue, Feb 9 2021 7:27 PM | Permanent Link |
Ian Branch | 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |