Version 2007-04-10

This release is mostly just minor bug fixes and code tweaks. Look through the detailed modifications for each library in this section to see all of the modifications. The following is a summary of the more important changes.

1. Security Windows - Added horizontal scroll bar to the complex grids.
2. Multiple Monitors - Modified the code which checks the size and fit of the window to handle multiple monitors on the Mac. The code isn't perfect yet because sys(104) doesn't tell us about displays to the left of the main monitor.
3. MySQL DBAdmin - Couple of SQL text corrections so that using the DBAdmin tool with MySQL should be smoother now.
4. No Primary Key Error - Previous to this version if you created a schema class that did not have a primary key an error would be reported when you did a runtime build. In the last release the sWebappstat table which was added to swWeb4. It does not have a primary key. This caused an error to be reported when you did a runtime build. In this version, not having a primary key in a schema class is no longer and error. Remembering to include a primary key where needed is the responsibility of the developer.
5. Return Next Primary Key - Modifed the $retNextPrimaryKey method in oRefs so that if the primary key table record doesn't yet exist, a select MAX() will be used to find the maximum pkey value and then set the last primary key value to the MAX() value.
6. pExtaSQL - This parameter in tBase has been changed to allow you to send text or a row variable. The row variable lets you use bind variables in your extra SQL.

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. Reopen your StudioWorks app and test it.

swBase4

oDBAdminSQLText_MYSQL/$retSQL_AddCheck_notNull (2007-03-29 Josh L as per Andy H.)
Subclassed and corrected the syntax for MySQL changing a column to Not Null.

oDBAdminSQLText_MYSQL/$retSQL_AlterColumn (2007-03-29 Josh L. as per Andy H.)
Subclassed and corrected the syntax for MySQL alter column.

oErrorHandler/setLogFileAndFileOpsVar (2007-03-21 Doug K.)
Do not automatically delete the log file for any reason. Leave that for the developer or user to do manually. The error log file is a text only file, so it really is never going to amount to any big size.

oSQLChildRecords/$deleteChildRecords (2007-04-05 Doug K.)
Added missing kFalse to the $search method so that all lines are deselected. Was empty.

oSQLLists/getPrimaryKeyColNamesForCurrLine (2007-04-05 Doug K.)
Changed the method so that no error is logged or reported if a SQL class has no primary key. The developer is responsible for whether or not a primary key is included.

oStartupTaskDefaultMethods/$signIn (2007-03-21 Doug K per Andy H)
Changed from $openonce to $open for the wSignIn window to allow multiple instances for multiple apps at one time.

oTableMethods/$retNextPrimaryKey (2007-03-21 Doug K.)
Added sending iPKColName as second parameter for oRefs enhancement.

oTableMethods_MYSQL/$retNextPrimaryKey (2007-03-21 Doug K.)
Added sending iPKColName as second parameter for oRefs enhancement.

tBase/$_retSelectWhereSQLText (2007-04-05 Doug K per Andy H.)
Changed pExtraSQL character to pExtraSQLRowOrString binary. Added iExtraBindRow. Modified code to handle extra SQL row.

tBase/$dodeletesBatch (2007-03-21 Doug K per Andy H)
Moved the 'Break to end of loop' to AFTER 'Calculate TempList as $cinst'

tBase/$selectWhere (2007-04-05 Doug K per Andy H.)
Changed pExtraSQL from character to pExtraSQLRowOrString binary.

tBase/$setPrimaryKey (2007-03-21 Doug K.)
Added sending iPKColName as second parameter for oRefs enhancement.

wSecurity_GroupSchemas/$#About (2007-04-05 Doug K per Andy H)
Set $horzscroll to kTrue for the complex grid object.

wSecurity_GroupWindows/$#About (2007-04-05 Doug K per Andy H)
Set $horzscroll to kTrue for the complex grid object.

wSecurity_UserSchemas/$#About (2007-04-05 Doug K per Andy H)
Set $horzscroll to kTrue for the complex grid object.

swDocs4

swGui4

oFieldHandlerLookupTypeAhead/selectfetchMasterListRecords (2007-03-15 Josh L.)
Reversed Mod: 4 so that we take into consideration Aliases, which is what the SelectOperatorRecords does.

oMenusList_abstract/$_addOtherMenuLine (2007-04-05 Doug K. per Andy H.)
Bug fix. Removed the extra ] closing square bracket near the end of the notation string.

oMenusList_abstract/$_addReportsMenuLine (2007-04-05 Doug K. per Andy H.)
Bug fix. Removed the extra ] closing square bracket near the end of the notation string.

oMenusList_abstract/$_addSpecialMenuLine (2007-04-05 Doug K. per Andy H.)
Bug fix. Removed the extra ] closing square bracket near the end of the notation string.

oWindowsProperties/$restoreWindowSize (2007-04-05 Doug K per Andy H)
Attempting to handle multiple monitors. Set the $top and $left properties even if they are less then zero.

oWindowsProperties/$restoreWindowSize (2007-04-10 Doug K.)
Split the checkSizeAndFit method into separate methods. Modified this method to call the correct method.

oWindowsProperties/checkSizeAndFit_Default (2007-04-10 Doug K.)
Split the checkSizeAndFit method into separate methods. One specifically for Mac, one for others.

oWindowsProperties/checkSizeAndFit_MacOS (2007-04-10 Doug K.)
Split the checkSizeAndFit method into separate methods. One specifically for Mac to support multiple monitors. Currently the method does not recognize extra monitors to the left or above the main monitor. Andy Hilton is looking at Applescripts to hopefully be able to detect the exact locations and size of extra monitors.

wBase_ToolbarTitlebar_abstract/$_constructEnabledCmndsCSV (2007-03-14 Josh L.)
Moved the security from EditList_abstract and List_autoconfig to this base toolbar titlebar class. This will ensure that any windows with a Toolbar will adhere to the security standards of their base schema.

wContainer_List_ListChildren_abstract/$setupWindow (2007-04-09 Doug K per Birger R)
Added $cando test to $removeCmnd, $removeToolbarButton, and $attachCmndsObserver.

swRefs4

oRefs/$retNextPrimaryKey (2007-03-21 Doug K per Andy H)
If inserting a new primarykey record in the refs table get the MAX() pkey value from pTable and increment +1. Removed the early exits.

StudioWorks Documentation - Copyright 2005 Vencor Software