<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Ruslan,<div><br></div><div>sorry for the late answer, but I was in gardening mode.<br><div><br><div><div>On 23.09.2009, at 19:38, Ruslan Zasukhin wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><blockquote type="cite">have a bit of a problem with the warnings file, which contains the following<br></blockquote><blockquote type="cite">lines:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Get Trigger : No trigger with name ChangeAttachmentCount<br></blockquote><blockquote type="cite">Get View : No view with name CheckDuplicates<br></blockquote><blockquote type="cite">Get SP : No SP with name PathSort<br></blockquote><blockquote type="cite">Get SP : No SP with name MailboxName<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">These are just about all Triggers, Views and Functions that I create.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">1. What does it want to tell me? For instance the first trigger is created<br></blockquote><blockquote type="cite">when the database is created.<br></blockquote><br>Well, such warns are produced when is called<br><br> GetTrigger(name)<br> GetView(name)<br><br>And object was not found.<br><br>Sounds like some code try access your object before it is created.<br></span></blockquote><div><br></div><div>I think I found the issue: when using "create or replace" the replace causes the warning to be created. See Mantis 4580.</div><br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">2. Would it be possible to add a date stamp to each line in the warning? Then<br><blockquote type="cite">I have a much better chance to find out which line is causing the warning.<br></blockquote><br>In theory yes.<br></span></blockquote><div><br></div>Added to Mantis as 4579.<br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><br><br><blockquote type="cite">3. When should I add WarningMode off in code? From experimenting just now it<br></blockquote><blockquote type="cite">seems directly after creating or opening.<br></blockquote><br>After Valentina.Init?</span></blockquote><br></div><div>This doesn't work. You need a database to have SQL work.</div><br><div apple-content-edited="true"> <div><p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mit freundlichen Grüßen/Regards</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Trixi Willius</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.mothsoftware.com">http://www.mothsoftware.com</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mail Archiver X: archive, clean and search email</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.beatrixwillius.de">http://www.beatrixwillius.de</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Fractals, 3d landscapes etc.</font></p> </div> </div><br></div></div></body></html>