Version 2007-03-07

The following is a summary of the changes include in this release:

1. Field Handler Lookup Type Ahead - Remove the Select 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 More button.
2. Redeveloperize Window - The original code would replace any fields that were the wrong object type. Removed this aggressive code from the concretizer object.
3. Web App Monitor - A non-visual web app monitor object has been added to the swWeb4 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 StudioWorks > Web > Web App Monitoring for more info and setup instructions.
4. RDBMS Server Timestamp - The tBase table class and the FrontBase and MySQL oTableMethods 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.

To update to this new release:

1. Backup your application.
2. Replace your old studioworks folder and contents with the new studioworks folder included with this release.
3. 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.

swBase4

Startup_Task/$#About (2007-02-14 Doug K.)
Added tvar 'webmon' which points to 'oWebMonitor'.

Startup_Task_Module_template/$#About (2007-02-15 Doug K.)
Added tvar 'webmon' which points to 'oWebMonitor'.

oConstants/$:SMTPPassword (2007-02-14 Doug K.)
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.

oConstants/$:SMTPUserName (2007-02-14 Doug K.)
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.

oConstants/$:WebAppStatsEmailAddr (2007-02-14 Doug K.)
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.

oConstants/$:WebAppStatsInterval (2007-02-14 Doug K.)
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.

oEmail/$initialize (2007-01-31 Doug K.)
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.

oFunctions/$construct (2007-03-07 Doug K.)
Added objdataname columns to the iTemplatObjsList.

oFunctions/$retContainedObjs (2007-03-07 Doug K.)
Added objdataname to the objects list.

oFunctions/$trimWhitespace (2007-02-14 Doug K & Josh L)
Added function to trim kCr, kLf, kTab, ' ' from either or both ends of a string.

oStartupTaskDefaultMethods/$installMenus (2007-02-20 Doug K.)
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.

oStartupTaskDefaultMethods/INSTALLWEBMONITORMENU (2007-02-20 Doug K.)
Deprecated 'installWebMonitorMenu' method.

oStartupTaskDefaultMethods/autoSignIn (2007-02-20 Doug K.)
Change $cinst.$signInOKContinue to $ctask... so that the Startup_Task method is called. The Startup_Task $signInOKContinue method may have some custom code.

oStartupTaskVarsTool/$constructTaskVars (2007-02-14 Doug K.)
Added 'webmon' to the task variables.

oTableMethods/$setSQLText_InsDateTime (2007-02-26 Doug K.)
Added method to allow SQLText to be modified to set the InsDateTime column value to the server timestamp value.

oTableMethods/$setSQLText_ModDateTime (2007-02-26 Doug K.)
Added method to allow SQLText to be modified to set the ModDateTime column value to the server timestamp value.

oTimers/$#About (2007-02-20 Doug K.)
Discontinued the oTimers object. It is too broad range to be useful. Moved the 'DeleteHTMLTempFiles' functionality to oWebMonitor in the swWeb4 library.

tBase/$doinsertsBatch (2007-02-26 Doug K.)
Added call to oTableMethods.$setSQLText_InsDateTime & $setSQLText_ModDateTime to allow it to be set to the server timestamp value.

swDocs4

@00 Menus/@00 About (2007-01-31 Doug K.)
Added documentation for Menus.

@00 Reports/@10 Reports Menu (2007-02-13 Doug K.)
Added the pMenuLineID_opt parameter to the documentation for $_addReport

swGui4

Startup_Task/$#About (2007-02-15 Doug K.)
Added tvar 'eml' which points to 'oEmail'.

Startup_Task/$#About (2007-02-15 Doug K.)
Added tvar 'webmon' which points to 'oWebMonitor'.

Startup_Task/$construct (2007-02-15 Doug K.)
Added tvar 'webmon' which points to 'oWebMonitor'.

mMenu/$_addMenuLine (2007-01-31 Doug K.)
Added code to set shortcut keys for menu lines if specified in the parameters.

mMenu/$initialize (2007-01-31 Doug K.)
Added 'shortcutkey' to the parameters passed to $_addMenuLine.

oConcretizer/$updateDeveloperWinClass (2007-03-07 Doug K. per Will Adkin)
Removed the code which would replace an existing field if the $objtype was 'wrong'. The code was a little too aggressive.

oFieldHandlerLookupTypeAhead/$promptSelectLookupRecord (2007-01-31 Doug K.)
Check for a $promptSelectLookupRecord entry field method. If found, call it and process no further here.

oFieldHandlerLookupTypeAhead/promptLookupRecordNotFound (2007-01-31 Doug K per Tom Maher)
Removed the option to 'select' from a list of all lookup records. That can be done within the lookup list.

oMenusList_abstract/$_addOtherMenuLine (2007-01-31 Doug K.)
Overhauled the method to automatically add the o...MenuObserver object class and to use the irDefaultMenuClass if non is specified.

oMenusList_abstract/$_addReportsMenuLine (2007-01-31 Doug K.)
Changed pShortCutKey_opt from char to int data type.

oMenusList_abstract/$_addSpecialMenuLine (2007-01-31 Doug K.)
Changed pShortCutKey_opt from char to int data type.

oMenusList_abstract/addWindowMenuLine (2007-01-31 Doug K.)
Added calculation of pShortCutKey to the menu lines list. Change pShortCutKey to an integer value.

swReports4

swWeb4

Startup_Task/$#About (2007-02-15 Doug K.)
Added tvar 'webmon' which points to 'oWebMonitor'.

oRemoteTaskMethods/$destructMethod (2007-02-15 Doug K.)
Modified the method to use the new non-visual oWebMonitor object.

oRemoteTaskMethods/$eventMethod (2007-02-15 Doug K.)
Modified the method to use the new non-visual oWebMonitor object.

oWebMonitor/$#About (2007-02-15 Doug K.)
Added non-visual web monitoring object class with sWebappstat and sWebStatsSummary_listdef schema classes.

StudioWorks Documentation - Copyright 2005 Vencor Software