Softpedia >Windows >Internet >Servers >Database Utils >Sesame Database Manager >  Changelog

Sesame Database Manager Changelog

What's new in Sesame Database Manager 2.5.3

Jun 13, 2014
  • New Features:
  • New SBasic Command: @LocalCWD() - Returns the current working directory.
  • New SBasic Command: LocalCWD() - Sets the current working directory.
  • New SBasic Command: @MoneyToWords() - Converts a numeric or currency value to cardinal text like that used for printing checks.
  • New SBasic Command: MouseCursorDefault() - Allows an SBasic programmer to indicate that the system is not busy.
  • New SBasic Command: MouseCursorWait() - Allows an SBasic programmer to indicate that the system is busy.
  • New sesame.ini File Entry: MACROS RETAIN FOCUS: Causes the focus to stay where macros leave it.
  • Optional argument added to @Sendmail to allow an HTML file to be attached.
  • Replaced mktime function with one that works on dates after the year 3000. (Windows only)
  • Open square brace ( [ ) in retrieve spec criteria escapes any following search characters until end of criteria or ;.
  • Admin interface now shows an hourglass cursor while performing a backup.
  • Added keyboard shortcut Ctrl-A to select the entire contents of an element.
  • In SDesigner, the Save button will turn yellow if a Form/Report design needs to be saved.
  • Support added for multiple monitor setups.
  • The Full versions have a new installer that provides options for desktop shortcuts, an uninstaller, and improvements based on the requirements of newer operating systems and antivirus programs.
  • Fixes:
  • Fix to crash in dialogs with drag-and-drop features.
  • Fix to case sensitivity and partial matches when updating SBasic code after an element is renamed.
  • Fixes to several memory leaks, conflicts, and limits.
  • Fix to long popup lists not allow a selection after being scrolled too far.
  • Fix to reindex field names when a result set is touched by an XResultSet command.
  • Fix to retrieve spec becoming read only if NotifyForm(7) is set and the only record is deleted.
  • Fix so WriteLn window (Slate) retains the CR LF pair on Windows when copying and pasting.
  • Fix to crash when attempting to open a file without write permissions to the recently used file list.
  • Fix to use the HOST line when speaking HTTP.
  • Fix so staic images properly strip the [image:] specifier.
  • Fix so images scale correctly when one edge matches the size of the container or either dimension reports as 0.
  • Fix to check whether both the db and dat are writable before attempting a full save.
  • Fix to working with a mix of money and integers when the integer is greater than 214748.
  • Fix to @LocalListDirectory and @ServerListDirectory to return a zero-length string if passed a path to a file instead of a directory.
  • Change to @DirectoryExists to return False if the path exists, but is not a directory.
  • Fix so @Layout and @Database can be called from GLOBAL CODE.
  • Fix so ClearIgnoreKey clears all variations of the key instead of only clearing the first one found.
  • Fix to close the Mass Update Programming Editor if the user selects a pulldown choice on the Spec Handler.
  • Fixes to better compartmentalize simultaneous ASCII exports.
  • Fix to correctly format postfix currency symbols on Linux.
  • Fix to optimize and reduce memory usage by ASCII Export.
  • Fix to Break By Day conflict between Report Designer and Report Wizard.
  • Fix to Function Key Menu to prevent a problem if focused widget is destroyed.
  • Fix to properly retain Global Values when reconciling.
  • Fix to run GLOBAL CODE when a mass update is executed engine-side.
  • Fix so daemon mode waits for 4 bad pings before closing a client seat.
  • Fix so Report columns set to not repeat print when the column breaks.
  • Fix to reset the translation table when going into and out of Preview mode.
  • Fix so Shift-F11 copy can better detect when the user needs to be warned about overwrites.
  • Fix so that answering No to the delete confirmation does not create an unbound subform.
  • Fix so F11 copies fields in Copy Spec order instead of Form order to match Shift-F11 mapping.
  • Fix so copying a form with a blank Copy Spec copies all fields.
  • Change so pasting multiple records only warns about overwrites once.
  • Fix to using FormCommit in On Form Delete programming.
  • Fix so @Sendmail can accept display formatted email addresses.
  • Fix to @Sendmail so BCC addresses work even if no CC addresses are present.
  • Fix crash when attempting to save or load a Mass Update Spec with long field identifiers.
  • Fix to deleting all items in a StringArray.
  • Fix so On Retrieve Spec Open programming in a button on a Table View subform does not try to run.
  • Fix to MIN and MAX searches to greatly increase the speed of relational indexing.
  • Fix to X-commands to correctly search for blank (=) in a numeric field.
  • Fix to the Reconcile Dialog to improve respect for the translation table.
  • Fix to crash when Alt-F8 is pressed on a startup form.
  • Multiple fixes and improvements to the Q&A Translator.
  • Fix so the Finding Duplicates progress message does not indicate that it is removing duplicates.
  • Fix to prevent a lag when using large Text Editor elements.
  • General fixes for Tables and Table View subforms.
  • Fix to crash using Alt-DownArrow in Add Mode.
  • Fix to @DirectoryExists to correctly handle root paths such as C:\
  • Fix so @PopupChoiceList automatically highlights the first item.
  • Fix to disable MIN and MAX in RegEx searches.
  • Fix to prevent Ditto (F5) from copying a new, unedited record.
  • Fix to allow autoscroll to a combo box.
  • Fix to Close Form to deal with RunEntryOnInterval programming.
  • Fix to focus indicator for checkboxes.
  • Fix to make Shift-Tab move backwards in tables.
  • Fix to the routine that locates a named form to properly restore the original form.
  • Fix to occasional lockup when navigating in the Spec WIndow with the arrow keys.
  • Fix to make the search progress bar more adaptive and finely tuned.
  • Fix to @Sendmail to prevent a crash if no To, CC, or BCC addresses have been specified.
  • Fix to prevent Windows 7 from crashing when attempting to preview a report with attached specs in SDesigner.
  • Fix to prevent the F6 Editor from writing to read-only Text Editor elements.
  • Fix so our choice lists remember highlited items between appearances.
  • Fix to disable the Save button while a save is in progress.
  • Fixes to Print Form To HTML.
  • Fix so Quick Reports better respect the length setting in the Spec.
  • Fixes to StaticChart.
  • Fix to occasional crash when minimizing Sesame, then selecting Close from the icon's right-click menu.
  • Fix to reduce the number of times cursor swaps between hourglass and arrow to accomodate certain graphics drivers. SBasic commands added to force the cursor to change, if needed.
  • Fix to allow @ExitSesame to close Sesame even if the notify flag to prevent a tab from closing is set.
  • Fix so cached programming attached to multiple copies of the same form is not deleted in Preview mode.
  • Fix to crash when Programming Editor opened after deleting an element.
  • Fix to retain a client's IP address, even if the address cannot be resolved to a name.
  • Fixes to print dialogs.
  • Fixes to Copy Specs and the Copy dialog.
  • Fix so Text Editor elements do not offer editing choices on their right-click menu if they are read-only.
  • Fix so a QuickMacro with only one event will run.
  • Fix so Menu Tree clicks a macro run even if the menu style is set to Button.
  • Fix to rebuild XLookup indexes after Merge Application.
  • Fix to an occasional crash when cancelling @OpenWindow.
  • Fix so forms opened with @FormAsDialog correctly refresh changed programming in Preview mode.
  • Fix to allow preindexing to run in Preview mode.
  • Fixes to loading default Specs.
  • Fix so IGNORE COLUMN works properly on multi-level imports.
  • Fix to prevent command buttons from reacting to the spacebar when they shouldn't.
  • Fix to make sure that On Change programming is triggered when using Ctrl-Home and Ctrl-End.
  • Optimization to rebuild the XLookup indexes only on a full save. This should speed up Mass Updates.
  • Optimization to X-commands that do not use indexing.
  • Fix to running a Report with a subreport from a Form with no matching subform.

New in Sesame Database Manager 2.5.2 (Jul 28, 2010)

  • New Features:
  • IMPORTANT CHANGE TO NETWORK OPERATION: This version includes client-server connectivity improvements.
  • IMPORTANT CHANGE TO PERFORMANCE: This version includes performance improvements when moving through records, especially records with a large number of fields.
  • Print Form to HTML includes field names in the generated HTML to improve interaction with the Sesame API.
  • A new flag - LOAD - is added to the -command startup switch which allows an application to be preloaded on a Sesame Server. See the Errata and Additions document for full details.
  • The -command startup switch no longer requires that a GUI be available so it can now be used in environments like a command line shell on a web server.
  • Fixes:
  • General fixes to type-related crashes (date, time, etc.) caused by external library changes.
  • General fixes for 32 vs. 64 bit issues.
  • General improvements to field number handling on Q&A Translation.
  • Fix to allow @Userselect to correctly return the selected value.
  • Fix to properly reattach compiled SBasic when using Just In Time compliation and toggling between Table View and Form View.
  • General fixes to Table View operation.
  • Fix so reparent commands do not incorrectly see certain records as locked.
  • Fix to allow @@ to be printed using PrintString without affecting wrapping.
  • Fix to accomodate change to default fonts in Vista/Windows 7.
  • General improvements to the Recently Used Files list.
  • Fix to record counter when running a mass update.
  • Fixes to interaction between FormFieldValue and Table View subforms.
  • Fix so that automatic updates to SBasic programming when an element is renamed does a case-insensitive search for the old name.
  • Fix to the CONCATENATE operation for FormDependentValue.
  • Fix so @Sendmail does not send more than once when 4 optional arguments are supplied.
  • Fix so that Designer check for whether a db needs to have a dsr created is case-insensitive.
  • Fix to better handle programming on froms imported with Import XML, but not relinked.
  • Fix to prevent cascading events when calling FormCommit in Table View on field entry.
  • Fix to interaction between HideTabPage and commands such as @PopupMenu that create widgets.
  • Fix to LoadSpec to force the correct specs to be available when a different form is opened in SBasic.
  • Fix to restriction checking in table view.
  • Fix to prevent the Reconcile dialog from being dismissed before the target db is unlocked.
  • Fix to correctly compare blank number and money fields in a duplicate search.
  • Fix to prevent a form from closing while it is actively compiling SBasic code.

New in Sesame Database Manager 2.5.1 (Jul 28, 2010)

  • New Features:
  • IMPORTANT CHANGE TO NETWORK OPERATION: This version includes connectivity improvements to reduce issues due to slow or busy networks and servers.
  • IMPORTANT CHANGE TO PERFORMANCE: As of this version, Sesame no longer includes the Hoard library and instead uses the memory manager provided by your operating system. Because of this, you may find that the Sesame process takes longer to exit after closing Sesame than with earlier versions.
  • Added the ability to correctly display colors when in use with programs like Remote Desktop.
  • Made RegEx searches case sensitive. Added CASELESS REGEX option to sesame.ini setting DEFAULT SEARCH SYNTAX to allow users to force caseless RegEx searches, if desired.
  • Fixes:
  • Fixed issue where code included with #include and using #define was case sensitive about the #define.
  • Fix to allow ASCII Export to sort correctly on a Boolean field.
  • Fix to allow @XPos and @YPos to return a value relative to a subform.
  • Fix to display of Quick Report Spec Window.
  • Fix to mouse wheel events with regard to List Boxes and Text Editors.
  • Fix to prevent scrolling from affecting printing Forms with Page Breaks.
  • Fix to allow AskUser and MsgBox dialogs to appear regardless of warning level.
  • Fix to searching money with formats using the comma as the decimal separator.
  • Fix to prevent Table View from saving a blank row when including a Boolean field.
  • General improvements and fixes for Table View.
  • General improvements to the Recently Used File list.
  • General improvements to record locking/unlocking.
  • Improvement to handling of unsupported image formats.
  • Fix to allow colors to be changed on cells in table view subforms.
  • Fix to prevent Just in Time Compilation from causing the On Draw event to recurse.
  • Fix to the SBasic routines that operate on a specified Form.
  • Fix to prevent an Application's startup Form from appearing until the security login is complete.
  • Fix to interaction between Alternate Form and @FormAsDialog.
  • Fix to force vertical alignment in QuickReports to Top.

New in Sesame Database Manager 2.5.0 (Jul 28, 2010)

  • New Features:
  • IMPORTANT CHANGE TO MULTIUSER OPERATION: The Sesame Server is now fully multi-threaded and allows requests from multiple users to be handled at the same time.
  • IMPORTANT CHANGE TO TRIAL VERSION: Users may now request a free key to unlock the Q&A Translator in the Trial Version.
  • IMPORTANT VERSION NOTE: This version works with the new Sesame API, which will be released shortly.
  • IMPORTANT CHANGE TO NETWORK OPERATION: This version includes a number of improvements and protections to prevent issues like bad network connections, cards and/or cables from interfering with Sesame Server.
  • IMPORTANT CHANGE TO PERFORMANCE: Sesame now uses data caching for records to improve save speed, especially on shared drives.
  • New INI file entry FIELD_EDITOR_FONT_SIZE: Allows user to set default font size for F6 Editor.
  • Added a new command line option added to force Sesame Server to unload an application. Designed for use in batch files and automation. Several internal functions updated to accomodate this, although forcing unload of an application that is actively in use is strongly discouraged.
  • Automatic scrolling on word wrap and ability to scroll when read only added to Text Editor element.
  • @PopupChoiceList now uses the list header to determine list width.
  • Removed the 512 character line limit when importing programming into the Programming Editor.
  • Improved compile speed when using #define and when opening/closing forms repeatedly.
  • Increased precision of @Round to 15 places from 6.
  • Improvements to Undo in SDesigner.
  • Improvements to the Relinker dialog in SDesigner, including case-insensitive matching and automatic unbinding of unmatched elements.
  • Added a fallback to allow applications that are too large for memory preload to still load.
  • Added a progress bar to the Export Application to XML.
  • Added a Refresh button to update the list of connected clients in Server Admin.
  • Added Increase/Decrease Font to the F6 Editor menu.
  • Find On Form now finds values in elements on Tab Pages.
  • SBasic network commnads now set @Error if they are unable to connect to the network.
  • Fixes:
  • Fixed possible collision when creating both natural and relational links between the same records.
  • General minor fixes to Q&A translator.
  • Additional protections added for X-commands operating on the currently active record/result set.
  • Fixed memory leak when using #define.
  • General fixes to prevent the F6 Editor from interfering with record operations.
  • Fixed issue where file sizes can grow if records are never deleted.
  • Fixed memory leak in text elements.
  • Fixed cursor blink in table cells and text editor elements.
  • Fix to the behavior of ThrowFocus in combination with tab pages.
  • Fix to XML Import of a database which contains no records.
  • Fix to prevent a record overwrite when launching a QuickReport from an uncommitted record.
  • Fix to allow FormViewType() to toggle a toggled Table view form back to Form view.
  • Fix so human readable macro files retain which mouse button was pushed.
  • Fix to the directory lister to check if the directory exists.
  • Fix to F6/Text Editor and spellchecker interaction.
  • Fix to prevent crash on File/Close with a startup form using a focusable text box as its first element.
  • Fix to interaction between initial values and On Immediate Change programming for radio buttons.
  • Minor fixes to radio button groups.
  • Changes to behavior with regard to tab pages and navigation keys/events.
  • Fix to prevent issues if @Exit is called more than once before the exit occurs.
  • Fixed memory leak when switching between Sesame applications without closing Sesame.
  • Fix to data validation in text elements.
  • Fix to long timeout when attempting to connect too many clients.
  • Fix to interaction between #ifdef and nested preprocessor commands.
  • Fix so SNAP TO GRID does not slow down the Report Designer.
  • Fix so @XResultSetSubset can use external filenames other than @FN.
  • Fix so that macros that change form mode are safer.
  • Fix to ensure that using F9 in combination with Find First Match saves the current record.
  • Fix to prevent Clear() from changing focus.
  • Minor fix to element group level security.
  • Fix to initialization routines when entering Preview mode.
  • Fix to interaction between macros and popups.
  • Fix to possible creation of blank records when toggling from Table View to Form View using the toggle button.
  • Fix to element indexing on referenced forms when non-addressable elements like tabsets are present.
  • Fix so that deleting the last element, then attempting to view programming for that element, does not crash.
  • Fix to occasional loss of scrollbar on Export Spec.
  • Fix so that having element highlighting turned on does not cause elements with long values to display the end of the value when entering the element.
  • Fix to PopupSelectPosition with mode 4.
  • Fix so unbound elements changed in programming when initial values are present do not cause a save.
  • Fix so that canceling out of typing a new form name also cancels creation of the new form.
  • Fix so that it is more difficult to get illegal charcters into field names.
  • Fix to turn off the temporary security bypass on application close.

New in Sesame Database Manager 2.1.0 (Nov 6, 2008)

  • New Button Menu user interface style. This new interface provides a number of new features and is on by default. Please see the Errata and Additions for full documentation.
  • Built-in Spell Checker.
  • Descriptive labels and numbering added to Spec Manager.
  • Optional CSS page breaks available in HTML report preview.
  • New SBasic Command: SetCopyBuffer() - Sets the system copy buffer (clipboard) to the specified value.
  • Help now brings up complete documentation.
  • Progress bars added for Merge Application and Reparent.
  • New ini file entry APPLICATION MODE: LOCKED starts Sesame without menubar, toolbar or command area.
  • Multiple improvements to Q&A report translation.
  • StringArray functions updated to recognize blank leading/trailing elements.
  • Changing the Name of an new element that has never been saved also updates Bound To.
  • Fix so that a Page Break in a report Group Footer does not print an extra blank page.
  • Fixes to ASCII Database command.
  • Fix to allow image labels to be changed.
  • Fix to password checking in the web server.
  • Fixes and improvements to Duplicate Selected.
  • Fix so a break value of 0 in a report Date element breaks by day.
  • Fix to prevent cloned forms from creating extra security records.
  • Fixes for non-US number settings.
  • Fix to allow @ in a value to print in Print Only reports.
  • Fix so negative currency values place the negative sign before the currency symbol.
  • Fixes to table view for three-level forms.
  • Fixes to FormCommit for three-level forms.
  • FormAsDialog is now modal.
  • Fix to hiding and restoring Tab Pages on a scrolled Form.
  • Fix so @AskUser does not reset ThisElement.
  • Fix to match password encryption between client/server and standalone.
  • Fix to Q&A translation when Exclude Security is selected to allow security to be added to the resulting Sesame application.
  • Fix so @XLookupSourceListAll strips trailing newline.