<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>StudioWorks - Version 2007-03-07</title> <meta name="keywords" content="omnis studio, raining data, studioworks documentation" /> <link rel="stylesheet" type="text/css" href="http://www.studiotips.net/css/codedoc.css" /> <link rel="stylesheet" type="text/css" href="http://www.studioworks-dev.net/css/codedoc.css" /> </head> <body> <div id="container"> <p><a href = ../index.html > Sw4 </a> &nbsp &gt; &nbsp <a href = index.html > About </a> &nbsp &gt; &nbsp Version 2007-03-07</p> <a name="version20070307" /> <h2>Version 2007-03-07</h2> <p>The following is a summary of the changes include in this release:</p> <ol> <li><strong>Field Handler Lookup Type Ahead</strong> - Remove the <span class="nav">Select</span> button option from the lookup record not found prompt. It is not necessary to have the select option, since the user can select a record from the lookup drop list. This change eliminates the problem of the the prompted select list getting all the records when there is a huge number of lookup records and the prompt window not have a <span class="nav">More</span> button.</li> <li><strong>Redeveloperize Window</strong> - The original code would replace any fields that were the <em>wrong</em> object type. Removed this <em>aggressive</em> code from the concretizer object.</li> <li><strong>Web App Monitor</strong> - A non-visual web app monitor object has been added to the <span class="code">swWeb4</span> library. This enhancement replaces the previous visual web monitoring which only kept the stats in memory. The non-visual web app monitor tracks activity by adding records to a Webappstat table in the database. The non-visual web app monitor include a feature which automatically sends a summary of the web app stats by email to the specified administrator. (Works great! I've been getting a web stat emails from each of my web apps every morning.) See <span class="nav">StudioWorks > Web > Web App Monitoring</span> for more info and setup instructions.</li> <li><strong>RDBMS Server Timestamp</strong> - The <span class="code">tBase</span> table class and the FrontBase and MySQL <span class="code">oTableMethods</span> objects have been modified to set the InsDateTime and ModDateTime to the RDBMS server's timestamp value. This eliminates the possibility of incorrect timestamp values coming from client computers or clients in different time zones when using FrontBase or MySQL. If other StudioWorks developers know the timestamp functions for other RDBMSs, please test them at your end and then let me know what they are. They can be added for the next release.</li> </ol> <p>To update to this new release:<br /> <ol> <li>Backup your application.</li> <li>Replace your old <span class="file">studioworks</span> folder and contents with the new <span class="file">studioworks</span> folder included with this release.</li> <li>If you had a working web app you will need to add the task variable webmon to your remote task variable and retest your web app functions. Contact me if you have any problems.</li> </ol></p> Each library and the modifications in the release are listed below. The modifications are compiled from the <span class="code">@MOD</span> tag comments found in the methods of the classes in the library. <a name="swbase4" /> <h3>swBase4</h3> <p><span class="code">Startup_Task/$#About</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added tvar 'webmon' which points to 'oWebMonitor'.</p> <p><span class="code">Startup_Task_Module_template/$#About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added tvar 'webmon' which points to 'oWebMonitor'.</p> <p><span class="code">oConstants/$:SMTPPassword</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added a constants property for the SMTP server to be used for sending emails. This can be used for initializing the oEmail object. As with any oConstants property, you can set this from the 'startupsettings.txt' file.</p> <p><span class="code">oConstants/$:SMTPUserName</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added a constants property for the SMTP server to be used for sending emails. This can be used for initializing the oEmail object. As with any oConstants property, you can set this from the 'startupsettings.txt' file.</p> <p><span class="code">oConstants/$:WebAppStatsEmailAddr</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added a constants property for the email address to send web app stats to. This is used for initializing the oWebMonitor object. As with any oConstants property, you can set this from the 'startupsettings.txt' file.</p> <p><span class="code">oConstants/$:WebAppStatsInterval</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added a constants property for the interval to send web app stats to. This is used for initializing the oWebMonitor object. As with any oConstants property, you can set this from the 'startupsettings.txt' file.</p> <p><span class="code">oEmail/$initialize</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Remove pinging the SMTP server from the $initialize method because if it fails the StudioWorks startup is stopped. The $sendEmail method pings the SMTP server each time anyway so no need to do this during the startup.</p> <p><span class="code">oFunctions/$construct</span> <span class="moddateby">(2007-03-07 Doug K.)</span><br /> Added objdataname columns to the iTemplatObjsList.</p> <p><span class="code">oFunctions/$retContainedObjs</span> <span class="moddateby">(2007-03-07 Doug K.)</span><br /> Added objdataname to the objects list.</p> <p><span class="code">oFunctions/$trimWhitespace</span> <span class="moddateby">(2007-02-14 Doug K &amp; Josh L)</span><br /> Added function to trim kCr, kLf, kTab, ' ' from either or both ends of a string.</p> <p><span class="code">oStartupTaskDefaultMethods/$installMenus</span> <span class="moddateby">(2007-02-20 Doug K.)</span><br /> Removed the 'install web monitor menu' code. Moved to non-visual web app monitoring. Developers can install the visual web app monitor, but must do this from the main library Startup_Task.</p> <p><span class="code">oStartupTaskDefaultMethods/INSTALLWEBMONITORMENU</span> <span class="moddateby">(2007-02-20 Doug K.)</span><br /> Deprecated 'installWebMonitorMenu' method.</p> <p><span class="code">oStartupTaskDefaultMethods/autoSignIn</span> <span class="moddateby">(2007-02-20 Doug K.)</span><br /> Change $cinst.$signInOKContinue to $ctask... so that the Startup_Task method is called. The Startup_Task $signInOKContinue method may have some custom code.</p> <p><span class="code">oStartupTaskVarsTool/$constructTaskVars</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added 'webmon' to the task variables.</p> <p><span class="code">oTableMethods/$setSQLText_InsDateTime</span> <span class="moddateby">(2007-02-26 Doug K.)</span><br /> Added method to allow SQLText to be modified to set the InsDateTime column value to the server timestamp value.</p> <p><span class="code">oTableMethods/$setSQLText_ModDateTime</span> <span class="moddateby">(2007-02-26 Doug K.)</span><br /> Added method to allow SQLText to be modified to set the ModDateTime column value to the server timestamp value.</p> <p><span class="code">oTimers/$#About</span> <span class="moddateby">(2007-02-20 Doug K.)</span><br /> Discontinued the oTimers object. It is too broad range to be useful. Moved the 'DeleteHTMLTempFiles' functionality to oWebMonitor in the swWeb4 library.</p> <p><span class="code">tBase/$doinsertsBatch</span> <span class="moddateby">(2007-02-26 Doug K.)</span><br /> Added call to oTableMethods.$setSQLText_InsDateTime &amp;amp; $setSQLText_ModDateTime to allow it to be set to the server timestamp value.</p> <span class="code">tBase/$doupdatesBatch</span> <span class="moddateby">(2007-02-26 Doug K.)</span><br /> Added call to oTableMethods.$setSQLText_ModDateTime to allow it to be set to the server timestamp value. <a name="swdocs4" /> <h3>swDocs4</h3> <p><span class="code">@00 Menus/@00 About</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Added documentation for Menus.</p> <p><span class="code">@00 Reports/@10 Reports Menu</span> <span class="moddateby">(2007-02-13 Doug K.)</span><br /> Added the pMenuLineID_opt parameter to the documentation for $_addReport</p> <span class="code">@19 StudioWorks Web App Monitoring/@00 About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added documentation on SW's non-visual web app monitoring. <a name="swgui4" /> <h3>swGui4</h3> <p><span class="code">Startup_Task/$#About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added tvar 'eml' which points to 'oEmail'.</p> <p><span class="code">Startup_Task/$#About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added tvar 'webmon' which points to 'oWebMonitor'.</p> <p><span class="code">Startup_Task/$construct</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added tvar 'webmon' which points to 'oWebMonitor'.</p> <p><span class="code">mMenu/$_addMenuLine</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Added code to set shortcut keys for menu lines if specified in the parameters.</p> <p><span class="code">mMenu/$initialize</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Added 'shortcutkey' to the parameters passed to $_addMenuLine.</p> <p><span class="code">oConcretizer/$updateDeveloperWinClass</span> <span class="moddateby">(2007-03-07 Doug K. per Will Adkin)</span><br /> Removed the code which would replace an existing field if the $objtype was 'wrong'. The code was a little too aggressive.</p> <p><span class="code">oFieldHandlerLookupTypeAhead/$promptSelectLookupRecord</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Check for a $promptSelectLookupRecord entry field method. If found, call it and process no further here.</p> <p><span class="code">oFieldHandlerLookupTypeAhead/promptLookupRecordNotFound</span> <span class="moddateby">(2007-01-31 Doug K per Tom Maher)</span><br /> Removed the option to 'select' from a list of all lookup records. That can be done within the lookup list.</p> <p><span class="code">oMenusList_abstract/$_addOtherMenuLine</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Overhauled the method to automatically add the o...MenuObserver object class and to use the irDefaultMenuClass if non is specified.</p> <p><span class="code">oMenusList_abstract/$_addReportsMenuLine</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Changed pShortCutKey_opt from char to int data type.</p> <p><span class="code">oMenusList_abstract/$_addSpecialMenuLine</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Changed pShortCutKey_opt from char to int data type.</p> <p><span class="code">oMenusList_abstract/addWindowMenuLine</span> <span class="moddateby">(2007-01-31 Doug K.)</span><br /> Added calculation of pShortCutKey to the menu lines list. Change pShortCutKey to an integer value.</p> <span class="code">wToolbar/$resize</span> <span class="moddateby">(2007-02-14 Doug K.)</span><br /> Added ivar iLastWidth and a check to make sure the container width has actually changed before running the method. This is to prevent running the method a second time after $initializeButtons. <a name="swreports4" /> <h3>swReports4</h3> <span class="code">oReportsList_abstract/$addReports</span> <span class="moddateby">(2007-02-13 Doug K per Mike Matthews)</span><br /> Updated the sample code to include the MenuLineID parameter. <a name="swweb4" /> <h3>swWeb4</h3> <p><span class="code">Startup_Task/$#About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added tvar 'webmon' which points to 'oWebMonitor'.</p> <p><span class="code">oRemoteTaskMethods/$destructMethod</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Modified the method to use the new non-visual oWebMonitor object.</p> <p><span class="code">oRemoteTaskMethods/$eventMethod</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Modified the method to use the new non-visual oWebMonitor object.</p> <p><span class="code">oWebMonitor/$#About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added non-visual web monitoring object class with sWebappstat and sWebStatsSummary_listdef schema classes.</p> <span class="code">oWebStatsEmailTimer/$#About</span> <span class="moddateby">(2007-02-15 Doug K.)</span><br /> Added non-visual web stats email timer object class. <p class="footer">StudioWorks Documentation - Copyright 2005 Vencor Software </p></div> </body> </html>