<?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-04-10</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-04-10</p> <a name="version20070410" /> <h2>Version 2007-04-10</h2> <p>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.</p> <ol> <li><strong>Security Windows</strong> - Added horizontal scroll bar to the complex grids.</li> <li><strong>Multiple Monitors</strong> - 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.</li> <li><strong>MySQL DBAdmin</strong> - Couple of SQL text corrections so that using the DBAdmin tool with MySQL should be smoother now.</li> <li><strong>No Primary Key Error</strong> - 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 <span class="code">sWebappstat</span> table which was added to <span class="code">swWeb4</span>. 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.</li> <li><strong>Return Next Primary Key</strong> - Modifed the <span class="code">$retNextPrimaryKey</span> method in <span class="code">oRefs</span> so that if the primary key table record doesn't yet exist, a select <span class="code">MAX()</span> will be used to find the maximum pkey value and then set the last primary key value to the <span class="code">MAX()</span> value.</li> <li><strong>pExtaSQL</strong> - This parameter in <span class="code">tBase</span> 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.</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>Reopen your StudioWorks app and test it.</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">oDBAdminSQLText_MYSQL/$retSQL_AddCheck_notNull</span> <span class="moddateby">(2007-03-29 Josh L as per Andy H.)</span><br /> Subclassed and corrected the syntax for MySQL changing a column to Not Null.</p> <p><span class="code">oDBAdminSQLText_MYSQL/$retSQL_AlterColumn</span> <span class="moddateby">(2007-03-29 Josh L. as per Andy H.)</span><br /> Subclassed and corrected the syntax for MySQL alter column.</p> <p><span class="code">oErrorHandler/setLogFileAndFileOpsVar</span> <span class="moddateby">(2007-03-21 Doug K.)</span><br /> 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.</p> <p><span class="code">oSQLChildRecords/$deleteChildRecords</span> <span class="moddateby">(2007-04-05 Doug K.)</span><br /> Added missing kFalse to the $search method so that all lines are deselected. Was empty.</p> <p><span class="code">oSQLLists/getPrimaryKeyColNamesForCurrLine</span> <span class="moddateby">(2007-04-05 Doug K.)</span><br /> 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.</p> <p><span class="code">oStartupTaskDefaultMethods/$signIn</span> <span class="moddateby">(2007-03-21 Doug K per Andy H)</span><br /> Changed from $openonce to $open for the wSignIn window to allow multiple instances for multiple apps at one time.</p> <p><span class="code">oTableMethods/$retNextPrimaryKey</span> <span class="moddateby">(2007-03-21 Doug K.)</span><br /> Added sending iPKColName as second parameter for oRefs enhancement.</p> <p><span class="code">oTableMethods_MYSQL/$retNextPrimaryKey</span> <span class="moddateby">(2007-03-21 Doug K.)</span><br /> Added sending iPKColName as second parameter for oRefs enhancement.</p> <p><span class="code">tBase/$_retSelectWhereSQLText</span> <span class="moddateby">(2007-04-05 Doug K per Andy H.)</span><br /> Changed pExtraSQL character to pExtraSQLRowOrString binary. Added iExtraBindRow. Modified code to handle extra SQL row.</p> <p><span class="code">tBase/$dodeletesBatch</span> <span class="moddateby">(2007-03-21 Doug K per Andy H)</span><br /> Moved the 'Break to end of loop' to AFTER 'Calculate TempList as $cinst'</p> <p><span class="code">tBase/$selectWhere</span> <span class="moddateby">(2007-04-05 Doug K per Andy H.)</span><br /> Changed pExtraSQL from character to pExtraSQLRowOrString binary.</p> <p><span class="code">tBase/$setPrimaryKey</span> <span class="moddateby">(2007-03-21 Doug K.)</span><br /> Added sending iPKColName as second parameter for oRefs enhancement.</p> <p><span class="code">wSecurity_GroupSchemas/$#About</span> <span class="moddateby">(2007-04-05 Doug K per Andy H)</span><br /> Set $horzscroll to kTrue for the complex grid object.</p> <p><span class="code">wSecurity_GroupWindows/$#About</span> <span class="moddateby">(2007-04-05 Doug K per Andy H)</span><br /> Set $horzscroll to kTrue for the complex grid object.</p> <p><span class="code">wSecurity_UserSchemas/$#About</span> <span class="moddateby">(2007-04-05 Doug K per Andy H)</span><br /> Set $horzscroll to kTrue for the complex grid object.</p> <span class="code">wSecurity_UserWindows/$#About</span> <span class="moddateby">(2007-04-05 Doug K per Andy H)</span><br /> Set $horzscroll to kTrue for the complex grid object. <a name="swdocs4" /> <h3>swDocs4</h3> <span class="code">@71 Table Classes/@50 $doworkBatch</span> <span class="moddateby">(2007-04-09 Doug K.)</span><br /> Added documentation on $doworkBatch vs. $dowork. Speeding up $doworkBatch. Sample Code. <a name="swgui4" /> <h3>swGui4</h3> <p><span class="code">oFieldHandlerLookupTypeAhead/selectfetchMasterListRecords</span> <span class="moddateby">(2007-03-15 Josh L.)</span><br /> Reversed Mod: 4 so that we take into consideration Aliases, which is what the SelectOperatorRecords does.</p> <p><span class="code">oMenusList_abstract/$_addOtherMenuLine</span> <span class="moddateby">(2007-04-05 Doug K. per Andy H.)</span><br /> Bug fix. Removed the extra ] closing square bracket near the end of the notation string.</p> <p><span class="code">oMenusList_abstract/$_addReportsMenuLine</span> <span class="moddateby">(2007-04-05 Doug K. per Andy H.)</span><br /> Bug fix. Removed the extra ] closing square bracket near the end of the notation string.</p> <p><span class="code">oMenusList_abstract/$_addSpecialMenuLine</span> <span class="moddateby">(2007-04-05 Doug K. per Andy H.)</span><br /> Bug fix. Removed the extra ] closing square bracket near the end of the notation string.</p> <p><span class="code">oWindowsProperties/$restoreWindowSize</span> <span class="moddateby">(2007-04-05 Doug K per Andy H)</span><br /> Attempting to handle multiple monitors. Set the $top and $left properties even if they are less then zero.</p> <p><span class="code">oWindowsProperties/$restoreWindowSize</span> <span class="moddateby">(2007-04-10 Doug K.)</span><br /> Split the checkSizeAndFit method into separate methods. Modified this method to call the correct method.</p> <p><span class="code">oWindowsProperties/checkSizeAndFit_Default</span> <span class="moddateby">(2007-04-10 Doug K.)</span><br /> Split the checkSizeAndFit method into separate methods. One specifically for Mac, one for others.</p> <p><span class="code">oWindowsProperties/checkSizeAndFit_MacOS</span> <span class="moddateby">(2007-04-10 Doug K.)</span><br /> 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.</p> <p><span class="code">wBase_ToolbarTitlebar_abstract/$_constructEnabledCmndsCSV</span> <span class="moddateby">(2007-03-14 Josh L.)</span><br /> 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.</p> <p><span class="code">wContainer_List_ListChildren_abstract/$setupWindow</span> <span class="moddateby">(2007-04-09 Doug K per Birger R)</span><br /> Added $cando test to $removeCmnd, $removeToolbarButton, and $attachCmndsObserver.</p> <span class="code">wEditList_abstract/$_constructEnabledCmndsCSV</span> <span class="moddateby">(2007-03-14 Josh L.)</span><br /> Moved the security up to the superclass. <a name="swrefs4" /> <h3>swRefs4</h3> <p><span class="code">oRefs/$retNextPrimaryKey</span> <span class="moddateby">(2007-03-21 Doug K per Andy H)</span><br /> If inserting a new primarykey record in the refs table get the MAX() pkey value from pTable and increment +1. Removed the early exits.</p> <span class="code">oRefs/$setNextPrimaryKey</span> <span class="moddateby">(2007-03-21 Doug K.)</span><br /> Removed the early exits. <p class="footer">StudioWorks Documentation - Copyright 2005 Vencor Software </p></div> </body> </html>