Lantica Software LLC.
  Learn more about Sesame Database Manager
Sesame has been a Godsend for us. We had numerous Q&A databases that had been developed over more than a decade and are thrilled to be able to convert and improve them with Sesame. It has saved the taxpayers a lot money.
  Bruce K. Stone
City Manager - City of the Village
 

Schedule Your Free Live Demo
Click here!
 
Home
My Account
Order Sesame
Getting Started
Products
Support
Contact Us
Company
Downloads
Q&A™
 
Follow LanticaSoftware on Twitter
 
 


Sesame Database Manager is compatible with Symantec Q&A. Q & A users will find that Sesame uses many of the same keystrokes, the same search syntax, and almost the same programming syntax as used in a Q&A database. Sesame can also translate Q&A databases. Find out more.


Inside Sesame - The Monthly Newsletter for Sesame Database Manager
Read a FREE issue!

 

Sesame Change Log


Current Documentation Errata and Additions - Last updated with 2.6.2

Current sbasic_include.sbas file - Last updated with 2.6.2

Previous Documentation Errata and Additions - Last updated with 2.5.3

Dictionaries - Needed for Spellchecker - Last updated with 2.1.0

Instructions for new Button Menus - Last updated with 2.1.0


Version: 2.6.3
Release Date: May 15, 2017

Fixes

  • Fix crash when using GOTO in GLOBAL CODE. (Note: GOTO is deprecated.)
  • Fix crash when opening a new DB from a form open in table view
  • Fix crash when element in table view has On Element Entry programming with a ThrowFocus or GOTO that forces focus to itself.
  • Fix crash when pressing Escape twice in table view
  • Fix erroneous change warning on toggling from form to table view and back repeatedly.
  • Fix crash when closing a form with a subform shared by another open form.
  • Fix to prevent start-up forms from being toggled to table view.
  • Fixes to events on tab pages.
  • Optimizations to deleting the new, blank record at the end of a table view set.
  • Fix to prevent ThrowFocus from trying to set focus to an element on a form that is not visible.
  • Fix to how the F6 field editor updates an element on a tab page.
  • Multiple fixes to table view behavior
  • Fixes to record counter updates
  • Change to set form to read-only instead of disabled when a from is disabled by group security.
  • Fixes to several spurious error messages and a possible crash when shutting down under certain circumstrances.
  • Fix to Delete Duplicates
  • Fix to numbers being incorrectly interpreted as negative under certain locale settings on Linux

Version: 2.6.2
Release Date: Sep 15, 2016

Important Notes

  • IMPORTANT NOTE: The communications protocol has changed with this version. Clients earlier than 2.6.2 will not be able to connect to a 2.6.2 server.
  • IMPORTANT NOTE: If you open an existing application in version 2.6.2, falling back to an older version may cause some anomalies in the color table.
  • IMPORTANT NOTE: If you are using the Sesame API, this version of Sesame requires an updated version of the API - Version 2.6.2. Free Download here.

New Features

  • New SBasic Command:FormDependentValueFiltered() - Operates identically to FormDependentValue, except that it only looks at records meeting the specified search criteria.
  • New SBasic Command: @HostName() - Returns the TCP/IP host name.
  • New SBasic Command: ShareGlobalStatics() - Returns the state of the ShareGlobalStatics flag for the current form.
  • New SBasic Command: @ShareGlobalStatics() - Sets a flag on the current form to control whether a form opened by Open Form in a New Tab will share the current form's Global Static variables.
  • New SBasic Command: @XResultSetNew() - This command is the best way to obtain a new, empty result set for the purpose of adding new records.
  • New sesame.ini File Entry: DISPLAY ADVANCED COMMANDS: DIsplays advanced commands on the button-view menu.
  • New sesame.ini File Entry: COMMAND WAIT TIMEOUT: This command should only be changed from the default if instructed by Lantica Technical Support.
  • New sesame.ini File Entry: QUICK NET CHECK TIMEOUT: This command should only be changed from the default if instructed by Lantica Technical Support.
  • New sesame.ini File Entry: HEARTBEAT FAIL MAXIMUM: This command should only be changed from the default if instructed by Lantica Technical Support.
  • New sesame.ini File Entry: HEARTBEAT INTERVAL: This command should only be changed from the default if instructed by Lantica Technical Support.
  • New sesame.ini File Entry: HEARTBEAT TIMEOUT: This command should only be changed from the default if instructed by Lantica Technical Support.
  • Optional argument added to @Sendmail to specify the encoding type for the binary attachment, if present.
  • XResultSetValue now accepts multiple field name/value pairs to set multiple field values with a single round-trip to the server.
  • XResultOpenForm now always opens a new tab.
  • Server Admin window now lists which applications each client has open.
  • New monitoring information and tools added to the Server Admin dialog.
  • Speed improvements to XLookup indexing.
  • Speed improvements to saves.
  • Loiter() can now be used in engine-side programming.
  • Significant changes to client/server communications regarding network outages, disconnects, and command delays. Includes ability to wait on or cancel delayed commands.
  • Label color can now be retrieved with @Attribute - ATTR_ID_LABEL_RGB_COLOR
  • Color support added for Print-Only reports.
  • Color support added for <HR> tags (lines) in HTML reports.
  • Added .jpeg to the accepted file extensions for images.
  • Added environment variable SESAME_PRINT_HTML_COMMAND that overrides the print verb for reports. This repairs a situation common with Chrome installations where and html class is created in the registry, but that class does not support the print verb.

Fixes

  • Fix to occassional crash using @FormAsDialog.
  • Fixes to ThrowFocus to prevent reentrancy and endless loops.
  • Multiple fixes to table view regarding blank extended records.
  • Fix to reconcile so the resulting db/dat does not grow in size by the length of the original file.
  • Fix to XLookupR so it does not change the case of key field values.
  • Fix to prevent XResultSetCLose from overwriting a record if used in a Mass Update with @XResultSetForm("").
  • Fixes to @TrimStringLeft and @TrimStringRight
  • Fixes to incorrect subrecord parenting and keyboard handling when using Ctrl-F11 and Alt-F11.
  • Fix to prevent form elements from reformatting values when the mouse is passed over them.
  • Multiple fixes to table view regarding focus issues, view toggling, and keyboard handling.
  • Fix so table view ignores the mouse wheel if no vertical scrollbar is present.
  • Significant optimizations to sorting widgets in SDesigner.
  • Fix to Attribute() so when box type is set for combo boxes, it affects the text box portion of the combo box.
  • Fix so that setting initial value in a subform does not cause @Modified to fire if there are no other modifications.
  • Fix to allow XResultSetReprent() to reparent subrecords a parent in the same result set.
  • Fix to floating point math and SBasic rounding functions to prevent attempts to compensate for rounding errors.
  • Fixes to column measuring in PrintOnly reports.
  • Fixes to the Element Example Palette.
  • Fix so PrintOnly reports better respect bold and italic settings.
  • Minor fonting fixes.
  • Fixes so table view correctly updates brethren elements.
  • Fix to the status message for Remove Record From Results.
  • Minor fix to PrintString wrapping measurement to better match printed output.
  • Fix to programmed retrieves in combination with Min/Max searches.
  • Fix to prevent multiple users from using the same username.
  • Fix to prevent rare crash when certain deprecated commands are used in GLOBAL CODE.
  • Fix to account for the Sesame main window being positioned partially offscreen to the left.
  • Fix to prevent possible crash when attempting to load a corrupted application file.
  • Change to ExitSesame() so it is deferred until all programming has finished running.
  • Fix so Unload Database (Admin Window) forces all clients who have that database open to close it.
  • Change so that opening the same form on another tab page, recompiles the code so that the two forms do not share global static variables. See the new INI file entries listed above to control this behavior.
  • Fix so a custom splash image is restored after closing the startup form.
  • Fixes to gracefully exit a Mass Update if the application is unloaded from the Admin Window while it is running.
  • Added more support for RGB colors being managed by Sesame's color table instead of FLTK's.
  • Ctrl-U now clears text widgets.
  • Fix so that that the report writer turns the "Save" button yellow if the users "saves" from the break/header editor.
  • Fix to prevent possible junk characters at the end of a document created with Merge File Print.
  • Fix so that the right click menu for the text widget in table view appears if the input widget is visible, rather than the more general table right click menu.
  • Fix so that table view checks unformatted values against the undo value to determine if it needs to set the element's change flag and call element change programming.
  • Fix to prevent a crash if On Draw is called recursively while other events are compiling.
  • Fixes to pressing Escape in a table view subform.
  • Fix so SelectTreeItem() works for OPen A New Tab and Open Form in a New Tab.
  • Fix so table view notices an element has changed when cutting, pasting, or clearing from the right-click menu.
  • Fix to the Clear option of the table view right-click menu.
  • Fix so an element bound to a non-existent field using XML import behaves like an Unbound element and logs the condition in the error log.
  • Fix so notifications sent from the Server Admin dialog notify only the selected Client instead of all Clients on the same computer.
  • Fix so the Server Admin dialog disconnects all selected clients, not just the first one.
  • Fix to prevent command reentrancy in table view when Show Images is enabled.
  • Fix so ASynchShell returns a more meanigful result.
  • Minor fix to printing on Linux.
  • Fix so Q&A converter correctly identifies systems using the US comma separator in numbers.
  • Removed the error "S_ENG 330256 Query error on a restriction.." because it can appear too frequently when using a XLookup where the key is a field value and contains unescaped/unintended search characters.
  • Fix so ghosted elements throw the same syntax error when tested in SDesigner as when the form is opened in Preview or Runtime.
  • Fix to prevent FormDeleteRecord() from being able to overwrite a locked subrecord in certain circumstances.
  • Fix to search to allow the ".." wildcard to span multiple lines.
  • Fix to prevent a cleared retreive spec from repopulating when searching in table view.
  • Fix to Duplicates Spec behavior in table view.
  • Multiple fixes to internal sendmail library to comply with updated standards.
  • Minor fix to ThrowFocus behavior when deferred.
  • Fixes to several focus issues.
  • Fix so radio button groups fire On Immediate Change properly.
  • Fix to table view header color for radio button groups.
  • Fix so that just-in-time compilation does not prevent ON DRAW programming from being compiled just-in-time.
  • Fix to QuickReport specs so they can save subform specs.
  • Fix to command buttons on subforms on tab pages so they can run their SBasic code on the first click.
  • FIx to prevent application corruption when a form has a subform and a Mass Update is used to delete all the parent records.
  • Fix to hierarchical ASCII Imports.
  • Fix so attaching and detaching a form does not alter the window title.
  • Changes to better accomodate very large applications.
  • Fix possible lockup when running a Server on Linux.
  • Fix so that the combo box popup menu better tracks when the mouse has left the popup menu window and closes the window.
  • Fix to icon assignment for certain Sesame windows.
  • Fix to measuring and placement when Sesame is started from a shortcut where the Run property is set to Maximized.

Version: 2.6.0
Release Date: Aug 14, 2014

Important Notes

  • IMPORTANT NOTE: Sesame Personal (previously $79) is now available as a free download. There is no longer a Trial version.
  • IMPORTANT NOTE: Lantica Technical Support has moved to a fee-based model. Various types of Support units may be purchased here. Free peer-to-peer support is available on the Lantica User Forum.
  • IMPORTANT NOTE: If you are using the Sesame API, this version of Sesame requires an updated version of the API - Version 2.0. Free Download here.

New Features

  • New SBasic Command: @IsEditable() - Returns 1 if the element is an editable type.
  • New SBasic Command: @XMLParse() - Parses an XML string and returns a handle to the resulting XML document..
  • New SBasic Command: @CalendarExtended() - Displays an interactive calendar and returns the selected date(s) as a string array. Includes options for multiple selections, date limits, navigation, and appearance.
  • New sesame.ini File Entry: USER PASSWORD EXPIRES: Sets the number of days a password is allowed to be used before it expires.
  • New sesame.ini File Entry: PASSWORD MAXIMUM ATTEMPTS: Sets the number of failed log in attempts allowed before the system will stop bringing up the login dialog.
  • New sesame.ini File Entry: PASSWORD MUST CONTAIN SYMBOL: If ON, passwords must contain at least one non-alphanumeric character.
  • New sesame.ini File Entry: PASSWORD MUST CONTAIN MIX CASE: If ON, passwords must contain both uppercase and lowercase characters.
  • New sesame.ini File Entry: PASSWORD MUST CONTAIN NONALPHA: If ON, passwords must contain at least one non-alphabetic character.
  • New sesame.ini File Entry: EXEMPTED ACCOUNT: Exempts the named account (user login name) from password expiration rules.
  • New sesame.ini File Entry: CHILD RECORDS PROTECT PARENT: If ON, a database with subrecords acquires partial protections against deletion of subrecords or parent records open in more than one result set.
  • New command-line switch: -dump_deletions: Causes the server to write an ASCII CSV entry representing all the data for any user-deleted record to a file.
  • Additional facilities to improve security capabilities and control (see above).
  • Ability for users to create their own new passwords when their old ones expire.
  • Sesame Server logs record both failed and successful login attempts for improved tracking.
  • Linux versions use the Xft font system.
  • New SDesigner Application Menu option - Export Programming: Exports all Application, Form, and Report programming to a single file.
  • New SDesigner Application Menu option - Import Programming: Imports all Application, Form, and Report programming from a single file.
    Warning - This can overwrite all existing application programming.
  • When running a report, Sesame checks to see if the SESAME_REPORT_PATH environment variable has been previously set in the current computer's Windows operating system. If not, it creates and saves all subsequent reports to a directory named SesameReports created under the folder specified in the shortcut as the Start In folder on each computer.
  • Scroll wheel support has been added to the PopUpMenu dropdown.
  • Min/Max searching has been made better and faster.
  • Opening of large Table views has been made significantly faster.
  • Improved relational index speeds.
  • Improved table view navigation with the use of the escape key.
  • Improved export/import report design capabilities in SDesigner.
  • Improved warning messages and data management for invalid data entry in numeric fields.
  • Improved display of file names in reconcile, server admin, and other file listing windows to allow the user to better understand the actual files being selected rather than just seeing the application names.
  • Improved display of various pulldown lists.
  • Improved internal rounding of monetary money decimals to the selected display format.
  • Duplex printing and Collate now obey the settings of the print dialog box.
  • Server now logs both successful and failed login attempts.
  • Multiple protections added for record/subrecord operations.
  • @Number now works on engine-side code.
  • The XML parser library now writes XML parsing errors to the Sesame log file.
  • The syntax diagram for a function now appears as the first line of the description of the function in the SBasic code editor.
  • ASCII Database now offers both txt and csv files.

Fixes

  • Fixed client/server issue where client connection count would increase, but client would never appear on the screen.
  • Optimized Save in SDesigner.
  • Fixes to several memory leaks, conflicts, and limits.
  • Fixes to several record-locking issues.
  • Fixes to several focus issues.
  • Fixes to several table issues.
  • Fixes to suppress some spurious error messages.
  • Additional NULL checking.
  • Fix so that print only reports turns off the current scheme when printing or previewing.
  • Fix to SDesigner issue involving Start Up forms.
  • Fix so X-Commands do not try to use pre-indexing if the search is on a keyword field.
  • Fix so On Form Entry programming does not run for the first record in a Mass Update.
  • Fix so HTTPGet terminates lines with 13 10.
  • Fix so that if any event fails to compile, no event will compile or run.
  • Fix to CursorPosition in On Element Entry code.
  • Fix so that read only gets set and cleared properly for text editor elements.
  • Fix in XResultSetOpenForm to handle the condition where the form is already open.
  • Increased the size of the server status window.
  • Fix to FormThrowFocus.
  • Fix so blanked boolean fields do not allow new, blank records to be saved.
  • Upgraded Linux jpeg library.
  • Fix to FormCommit on table rows.
  • Fix so @RedirectProcess returns a zero-length string instead of NULL on error.
  • Fix so that WidgetAttribute can set the text size of a Choice Button in an @OpenWindow window.
  • Fix so that On Immediate Change programming does not attempt to run during a mass update.
  • Fix to interactive table sorting.
  • Fix for ascii import that checks if the file has mismatched quotes and refuses to import if it does.
  • Fix to allow QuickReports to break by day.
  • Fix so that "Attribute(Whatever, ATTR_ID_Y, "230")" shifts the vertical rather than horizontal position.
  • Fix so that PrintAForm (and form print) use the AlternatePrinter (on Windows) if one is available.
  • Fix to validate element naming in Reports.
  • Fix so that XML imports respect element visibility setting in the XML file.
  • Fix so that importing and exporting XML reports retains the group break information, including view type.
  • Fix so Linux version of the client draws the checkmark in tri-state checkboxes, rather than trying to use the symbol font.
  • Improved error log message on GetAFieldDefinition errors.
  • Fix to progress bar protocol causing significant slowdowns in subreports.
  • Fix to correctly show/hide form scrollbars when toggling between form and table view.
  • Fix so that the element value conversion warning "Cannot retain (x), converting to (y)" more accurately represents the value.
  • Fix for renaming elements that are used in SBasic code so that partial matches at the end of a name does not change other element names in the code that partially match.
  • Fix so that ThrowFocus (and other programmed events that change the focus element) scroll or change tab page to the focused element.
  • Fix so the F5 in a property input in the element editor in SDesigner for entry template returns the value of the entry template rather than the value of the custom help.
  • Fix so that entry templates work in right justified text elements.
  • Fix to ASCII Import to separate delimiter default from separator default.
  • Fix to administrator password dialog issue.
  • Fix form scrolling issue.
  • Fix so that merging applications does not leave the merged application locked.
  • Fix to XResultSetClose to allow Unload Application to work properly on applications accessed with XResultSet.
  • Fixed conflict between administrative Unload Application function and DATABASE RETENTION setting.

Version: 2.5.3
Release Date: Aug 01, 2012

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.

Version: 2.5.2
Release Date: Jun 08, 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.

Version: 2.5.1
Release Date: Mar 16, 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.

Version: 2.5.0
Release Date: Sep 16, 2009

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.

Version: 2.1.0
Release Date: Nov 05, 2008

New Features

  • 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.

Fixes

  • 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.

Version: 2.0.6
Release Date: Apr 15, 2008

New Features

  • Maintenance release.
  • New mode added to @PrintAReport() which generates the report file, but does not launch it in the browser.
  • Additional fold option added to MergeFilePrint() which attempts to fold to end of line.
  • ASCII database can now handle files with more than 270 fields.
  • Progress bar added to ASCII database.
  • GLOBAL AUTOCOMPLETE is now OFF by default.

Fixes

  • Fixed handling of special conditions in translation of Q&A reports.
  • Fixed formatting of Long dates.
  • Allowed more events to run on Startup forms.
  • Improved handling of changes to read only status from SBasic.
  • Caused SBasic commands that refer to a form by name to prefer the current form.
  • Fix so Code Builder sets the event type.
  • Fix to printing multiple copies using the Windows print dialog.
  • Fixed double encoding of XML entities.
  • Fixed data source setting for XML import of subforms and subreports.
  • Fixed search issue with numeric values when using comma as a decimal character.
  • ASCII database no longer skips the first record when there is no header record or creates a blank record at the end.
  • Fix to linking when deleting and readding a subrecord link.
  • Fix to prevent LOAD DATA ON REDESIGN: OFF from truncating.
  • Fix to prevent focus from landing in a closed command tree.
  • XResultSetSearch can no longer access a secured app when no X password is set.
  • Fix to prevent FormCommit from mislinking grandchild records.
  • Fix to allow @GetSelectionContents() to operate properly when called repeatedly.

Version: 2.0.5
Release Date: Jan 28, 2008

New Features

  • Maintenance release.
  • Code Builder: Wizard to write SBasic for common tasks.
  • Report elements now have visual indicators in SDesigner for width and visibility.
  • Table View now has a button to switch back to Form View.
  • Significant speed increase when saving changes in SDesigner.
  • New SBasic Command: @XResultSetParent() - Returns a result set containing the natural parent of a record in a result set.
  • New SBasic Command: @XResultSetSubSet() - Returns a result set containing the natural children of a record in a result set.
  • New SBasic Command: @XResultSetRunProgram() - Runs SBasic commands engine-side on every record in a result set.
  • New Mass Update option allows mass updates to be run engine-side with a significant speed increase.
  • Easy parenting/reparenting of natural records: the Reparent tree command naturally links each record in your result set to a parent record based on matching values.
  • Orphan Search option allows easy retrieval of unparented subrecords.
  • Startup forms now respond to all SBasic events.

Fixes

  • Minor fixes to focus and keyboard behaviors in Table View
  • Minor fixes to special cases in retrieve spec programming.
  • XML Import now retains original field names.
  • Fix so super-modal dialogs like alerts do not interfere with each other.
  • Fix so On Element Entry programming runs if user clicks outside the form before switching elements.
  • Fix so relational preindexing manages the first relational record entered in an application.
  • Fix to allow HideTabPage to hide the rightmost page. Fix so RestoreTabPages restores the pages in their original order.
  • Internal date routine changes to use local time instead of UTC.
  • Fix so Sesame web server removes the thousands separator from values in numeric searches based on the locale settings.
  • Fix so @FormAsDialog does not return values on minimize.
  • Additional handling added to valid failure conditions for @XResultSetSearch.
  • Fix for conflict between X-commands and database locking.
  • Fix so that setting an external username and password does not prevent X-command access to applications without security.
  • Fix to indexing of dynamic arrays.
  • Fix to allow @ResultSetCurrentPosition in reports to work properly in runtime.
  • Fix to allow Q&A reports with derived columns that have no header to translate properly.
  • Fix to subform label handling.

Version: 2.0.4
Release Date: Dec 03, 2007

New Features

  • Maintenance release.
  • New SBasic Commands: Trap() and @Trap() - Setting a trap with Trap() allows you to keep focus in an element until you release the trap. @Trap allows you to check the state of the trap in the On Element Exit event and act accordingly.
  • New SBasic Command: XResultSetOpenForm() - Opens the specified form in Update mode with records pre-retrieved
  • Additional modes added to @Mode() - FORM_MODE_NONE and FORM_MODE_DIALOG
  • Added SPEC_OPERATION_LIST to @SpecCommand() - Returns a list of the specs of the specified type as a string array
  • @FormAsDialog now respects the size of the specified form
  • ANY/ALL setting now implemented for retrieve specs attached to Reports
  • Record delete confirmation messages now show the form name

Fixes

  • Improved triggers and speed for FormDependentValue.
  • Fix to optimized element indexing in SBasic. This also fixes the issue with only calculated values present in a report section.
  • Fix to lock up when closing an application while running in daemon mode
  • Updated printing defines in sbasic_include.sbas file
  • Multiple alerts now do not collide
  • Report Wizard correctly manages elements bound to IMAGE fields
  • Fix to Extractor when using passwords
  • Fix to web server password handling
  • Fix to duplication of radio button groups
  • Fix to loading and saving of retrieve specs in Table view
  • Fix so first element gets focus when moving between records in Add mode
  • Fix to Tab/Shift-Tab behavior in Programming Editor
  • Adjustments to On Form Exit triggers as focus enters and leaves a subform
  • Fix so @Xlookup sets the changed status on a form
  • Fix to importing of color settings for XML form
  • Fix to allow Q&A translator to translate more than five derived columns in a report
  • Adjusted mode settings for @XResultSetPrintReport() to match @PrintAReport()

Version: 2.0.3
Release Date: Oct 04, 2007

New Features

  • Maintenance release.
  • New SBasic Command: @GetSelectionContents() - Returns the contents of the clipboard
  • New SBasic Command: @IterateGlobalValues() - Returns the names of the existing Global Values as a StringArray
  • Simple Search enhanced to give more weight to standalone terms

Fixes

  • Improvements to reciprocity between Money and other numeric data types
  • Optimizations to compiling
  • Fixes for non-US keyboards in the Programming Editor
  • Increased the limit for number of elements in a report section to 1024
  • Improvements to ReportHTMLFilter
  • Fix for mixing subform programmed retrieves with parent form retrieves.
  • Increased triggers for FormDependentValue.
  • Improvements to XML layout imports
  • Improvements to merging and translating applications with security
  • Improvements to verbose mode
  • Improvements to how Form... commands select which instance of a form open in multiple tabs to use
  • Fix to allow commands that access the engine to be used in the On Draw event
  • Fixed conflict between clients and server when changing server admin passwords
  • Increased triggers for RELATIONAL PREINDEXING

Version: 2.0.2
Release Date: Aug 27, 2007

New Features

  • Maintenance release.

Fixes

  • Fixes for potential data loss when switching between Table View and Form View in combination with multiple retrievals and use of the Save Button or File/Save As.
  • Fix for translation of 1.x Money fields when translated database contains no records.
  • General improvements to data handling when toggling between Table View and Form View.
  • Fix to prevent crash if relationally linked parent has no subrecords.
  • Fix to allow specs for subforms on non-visible tab pages to appear in the Spec Window.
  • Fix to allow full editing facilities in the Programming Editor using non-US keyboards (such as German) that use dead-key combinations.
  • Fix to allow templates to be applied to existing data that is not in the template format.
  • Fix to allow Trim to remove databases with no defined fields.
  • Fix to prevent an embedded progress bar from crashing kiosk mode.

Version: 2.0.1
Release Date: Aug 09, 2007

New Features

  • Maintenance release with updated documentation and sample files.

Version: 2.0.0
Release Date: Jun 22, 2007

New Features


Version: 1.1.5
Release Date: Jun 12, 2007

New Features

  • Table reports respect the Page Break element.

Fixes

  • General stability improvements in multi-user environments
  • Added a new startup option for diagnostic purposes: "-server_dethread" that turns off server multithreading.

Version: 1.1.4
Release Date: Jul 15, 2006

Important Note

  • Sesame will no longer accept variables declared with "var" in the GLOBAL CODE area. If you have used "var" in GLOBAL CODE, you will get a failure to compile error when you open your Form in version 1.1.4. To clear this error message, change the "var" to "stat". This only affects variables in the GLOBAL CODE area not declared inside any subroutine or function.

New Features

  • Optimizations - X-Commands, relationally linked subforms, export and a number of SBasic commands have been optimized to run faster and use less memory.
  • Password dialog box starts with the cursor in the box, so you don't have to click to type your login.
  • Sesame Choice Lists now stay open until you make a selection, even if you release the mouse.
  • Trial version guides those seeking Q&A Translation information to the free demo request form.

Fixes

  • General improvements to Table View subforms.
  • General improvements to PrintToHTML, especially with regard to Tab groups.
  • General improvements to aligning objects in Reports.
  • Safeties added to protect from issues with failed @Macro and XCommands, for Reconcile, and for multiple users pressing the Save button at the same time.
  • Fix to Copy Layout in Designer to ensure the new layout gets a unique internal id.

Version: 1.1.3
Release Date: Nov 29, 2005

New Features

  • Reports now include an option to repeat the first group header (column headers) at the top of each page. To use this new feature, choose Table (First Group Header Repeats) from the View Type dropdown on the View Header Properties dialog.
  • Report table columns can now use the Width property to span multiple columns. If the column width is specified as "C n", or "Col n", or "Column n", where "n" represents a numeric value, the COLSPAN (Column Span) is set instead of the column width, allowing a single column to span across multiple columns in a report table. Examples: C 4; column 2; COL 3
  • New SBasic commands:
    @FormNotifyForm(formName as string) as int
    FormNotifyForm(formName as string, flag as int)
    @FormIsNotifyForm(formName as string, flag as int) as int
    These work just like NotifyForm/@NotifyForm/@IsNotifyForm, except you can specify the form to be used. This allows NotifyForm flags to be applied to subforms.
  • Expanded built-in limits:
    The Programming Editor can now accept up to 2GB per event.
    Labels, Initial Values, Restrictions, Tooltips, Custom Help and lists entered in the List Editor for combo boxes/list boxes can now accept more than 1024 characters.
    Text Layout Elements can now contain up to 2 Gb.
    Single cell of a report can exceed 32K.
  • Unbound LEs no longer trigger Form changed warnings on closing.
  • Improved readability of Application Tab labels.
  • Improved readability of selected items in FieldManager.
  • Improved Application locking behavior:
    Designer files (dsr) are now locked like Runtime files so that you cannot open the same designer file twice.
    X-commands like XLookup and XPost have improved ability to work with locked applications.
  • AddToTranslationTable can now be used in the spec handler
  • The current day now gets the focus on the calendar shown by the @Calendar command.
  • Load Spec programming is no longer case sensitive about the spec name.
  • RGBColor() can now set the background color of a check box, combo box, or rounded layout element box.
  • Export sorts are no longer case sensitive.
  • The client file dialog is no longer case sensitive
  • ThrowFocus can now force focus off of a "non-form" item - like the command tree.
  • Improvements to the ability of radio buttons to respond to the Immediate Change event.
  • Mass Delete can now operate on subrecords.
  • Protections added to prevent two servers from using the same application, even if that application has been unlocked with SUnlock.

Fixes

  • Caps Lock is effective for the first char typed on the form surface in SDesigner.
  • ThrowFocus changes the current tab (if need be).
  • Parentheses are correctly used in the search spec syntax.
  • Multiple saved mass updates in Q&A translate field numbering correctly and are imported in proper order.
  • Reconcile handles deleting whole databases better.
  • Re-entrant behavior when calling @exit in programming improved.
  • You can cancel an open app operation if the current app must be closed.
  • An attached retrieve on a report and programmed retrieves can use min/max.
  • Security based read only status is cleared when re-entering search mode (F7).
  • The user level is not retained between application opens.
  • Combo Boxes retain read only (not gray) if focus is an LE when switching modes.
  • Table View does not overwrite the current row with the first row when printing.
  • General improvements to navigation and programming behavior for Table View and Subforms.
  • Tab pages with very short labels still can draw the label.
  • A locked record does not cause the unlocked record to refresh on the client when the user presses f7 on the locked record.
  • Checkboxes visually update properly.
  • Default specs for update mode get loaded recursively.
  • The NotifyForm(2) can prevent a changed "last" record from being advanced.
  • Combo Boxes hold their background color
  • Forms do not clear their subforms before the exit programming runs.
  • Long Date format properly prints the day of the week.
  • Retrieve specs remove (and truncate at that spot) any CR or LFs.
  • A fix to X11 (linux) so that F keys provide a key down event while CTRL is being held down (instead of providing a key up event).
  • Up/Down/F10/F9 keys use in table view does not overwrite a previous record.
  • Programmed retrieves (in "{ }") do not cause an erroneous error message.
  • Read-only-not-greyed-out does not "grey-out" in table items.
  • The "No Background" printing command tree items work properly with SelectTreeItem.
  • Adding users in Security Manager no longer performs unneeded file saves.
  • Images no longer disappear if the PrintString family of commands is used.
  • @CurrentElement keeps up with mouse clicks and respects command buttons.
  • Attempting to create a duplicate Layout name in Layout Manager no longer causes intermittent issues.
  • General improvements to synchronization of command tree open/closed.
  • General fixes to ThisElement used with automation programming.
  • It is no longer possible in Designer to name a Layout and an element on that Layout with the same name.

Version: 1.1.2
Release Date: Mar 17, 2005

Fixes

  • This maintenance release fixes a bug introduced in 1.1.1 which causes SBasic programming to use the incorrect element value if the element appears after a Form View Subform.

Version: 1.1.1
Release Date: Mar 15, 2005

New Features

  • New Documentation Package: The documentation Supplements have been folded into the original 1.0 documentation. Other documentation enhancements include an improved Index.
  • @GetFromKeyboard(): Intercepts a keystroke.
  • GiveToKeyboard(): Passes on an intercepted keystroke.
  • AddToTranslationTable(): Allows a programmer to replace a string wherever it appears in the Sesame interface. For example, dialog box buttons normally label "Yes" can be changed to "Ja".
  • ReviseTranslationTable(): Alter a translation table entry.
  • RunExitProgrammingOnCloseForm() Tells Sesame to run On Form Exit programming when the Form is closed.
  • @RunExitProgrammingOnCloseForm() Return the state of the RunExitProgrammingOnCloseForm flag.
  • @FormWillClose() Allows the programmer to check and see if a Form Close event is queued.
  • Alt-End in a multiline element now moves to the end of the last line.
  • New startup switch -novisualupdate allow macros to be invisible on startup

Fixes

  • Fixed intermittent issue where reports turned black under particular circumstances.
  • Fix to issue where running a report with an attached sort spec from an uncommitted record could overwrite the record.
  • Improved Spec management during Reconcile.
  • Fixed unneeded scrolling in Spec Manager.
  • Fix to linking in relational records.
  • Fix so that XPostR respects record-locking.
  • Resized Reconcile dialog to fit on an 800x600 screen.
  • General improvements to Table View subforms.

Version: 1.1
Release Date: Dec 19, 2004
Note: This version represents a major upgrade in terms of both features and usability. Significant enhancements have been made to client/server operation, report capabilities and designer control of the Sesame interface elements, such as menu trees.

New Features

  • Powerful enhancements to report capabilities: The ability to create multiple group breaks added to reports. The feature allows for multi-layered breaks, lining up group totals and grand totals under columns, totals only reports, spacing between groups, multiple summaries, and more.
  • Improved client-server operation: Client/server operation is now more robust. The server will no longer accept connections from clients of a different version. In addition, clients and server are more "aware" of each other.
  • Tab Order: You can now set tab order for a form in SDesigner without using any programming.
  • New Reconcile Options: New reconcile options have been added to allow the application designer to reconcile in design changes, but retain the current @Number, Global Value and Saved Specs.
  • Over 50 SBasic commands added or enhanced. A Programming Manual supplement is available with full documentation and examples:
    @PromptForUserInput - Prompts the user to type some information, and returns that information to your program.
    Menu Tree commands - A family of commands to control what appears on the command menu trees.
    Printing commands - Enhancements and additions to the family of commands for printing from SBasic. These include the ability to print boxes and images. These also include the ability to select a printer, set margins, set orientation, etc.
    StringArray commands - Enhancements and additions to the family of commands for working with StringArrays. These include the ability to change the separator, replace items, compare StringArrays, extract unique values, combine StringArrays, etc.
    Element commands - Enhancements and additions to the family of commands for working with layout elements generically. These include the ability to get an element by index, count elements, etc.
    Expansion of NotifyForm - NotifyForm can now allow or prevent a number of actions, such as advance, retreat, save and delete record.
    SetDefaultTab and ClearDefaultTab - Returns the user to a particular form whenever a form is closed. Useful for creating custom menus.
    @FormIsStandalone - Checks whether a form is currently the top-level form.
    @FormCommit - Saves a particular form by name.
    @Database - Returns the database name.
    @Application - Returns the application name.
    @ImagePath - Returns the default image path.
    PopupSelectPosition - Controls the position of popup lists like those for @UserSelect and @PopupMenu.
    @Timestamp - Returns a raw timestamp for a record.
    @ServerTime and @ServerDate - Returns the current date and time from the server.
    @ASynchShell - Like @Shell, but returns control to Sesame immediately.
    OpenSlate and CloseSlate - Opens and closes the WriteLn window.
    ForceGroupBreak - Forces a group break in a report.
    ReadOnly and @ReadOnly expanded - These commands are expanded to allow for the new Read Only - Not Grayed Out setting. These commands also now work in Table View subforms.
    @RGBColor expanded - This command can now be used to change only the foreground or the background color, leaving the other as is.
    @FormFieldValue expanded - This command can now be used to get a value from the current record by using an instance of 0
    @Form... commands expanded - This family of commands can now be used to operate on the current form by leaving the form name blank ("").
  • New SBasic event: On Application Open - Runs programming when an Application is first opened.
  • Preview Application added to SDesigner toolbar so it is available without having to return to the Application menu.
  • Table View subforms now respect background and text color settings.
  • Read only elements can now be set to not gray out.
  • Right-click on any container element in SDesigner (such as a Tab Page, the Form or the Canvas) to select all its children.
  • Added Copy and Paste for entire records.
  • Improved File Dialogs - File dialogs are now resizable and include file information.
  • Insert key now toggles auto-highlighting.
  • SDesigner can now maximize to use full screen area.
  • Sesame now warns you if your application files are read-only, as can occur if on or copied from a CD.
  • Colors and fonts can now be set on List Boxes and Combo Boxes in SDesigner.
  • Selecting elements in SDesigner is now "stickier" to prevent accidental moving of elements.
  • Elements now show Parent and Coordinates when moved in SDesigner.
  • Combo Boxes now respond to highlighting, Cut, Copy and Paste.
  • SDesigner now has the ability to duplicate elements. Right-click on any element and choose Duplicate Me to create an identical element.
  • Reports are now listed in alphabetic (rather than creation) order.
  • The Up and Down arrow keys can now be used in the record counter to move between records.
  • You can now type a number larger than the number of records in the record counter to move to a new blank record.
  • Calls to @Number and GlobalValue() now commit the app to disk, even if no other save takes place.
  • ThisElement can now be used in Reports.
  • Tab pages are now included in SBasic element lists, and can be accessed using SBasic programming.
  • View Results in the Retrieve Spec will now put you in a new blank record if your result set contains no records.
  • Enhancements to make it more convenient to prevent and retreat from extended mode.
  • In SDesigner, you can use Ctrl-Arrow to move the cursor on the Form/Canvas one pixel at a time, to allow for fine detail work.
  • The Save command on the menu tree now also commits any unsaved subrecords before saving the main record.
  • Optimized Export to improve speed and memory usage
  • Enabled ThrowFocus in Table view subforms.
  • You can now set a static image in SBasic using LE_NAME="filepath".

Fixes

  • Fix to issue involving adding Fields using Field Manager.
  • Fixes for X command issues, including security and client-server reference counts.
  • General improvements to Table View subforms.
  • General improvements to client-server operation.
  • Fix to running reports in a client-server environment with different directory structures.
  • Reconciled the various ways of closing the command area.
  • Fix to Sort By Timestamp.
  • Fix to searching on numbers using non-US formats.
  • Image fields now show images in Reports.
  • General improvements to allowing SBasic that exits the currently running form.
  • No background printing no longer prints the background of subforms.
  • Fix to using GoTo and ThrowFocus with radio buttons.
  • X commands that return lists now have return a placeholder for a blank value.
  • General improvements to GDI resource management in Win 95/98/ME.
  • Improved image printing for certain HP LaserJet printers.
  • Fix to Copy A Layout.
  • Fix so that very long values are handled by Table View.
  • Fix to ghosted container elements.
  • Fix to merging into an application which has had records deleted, but has not been closed and reopened.
  • Read only can now be set in SBasic
  • @ResultSetTotal no longer counts uncommitted records.

Version: 1.0.4
Release Date: Jun 07, 2004

New Features

  • New SBasic commands added. A Programming Manual supplement is available with full documentation and examples:

    @DeferredMacro - Runs a macro after all other programming finishes running. Allows a macro to close the currently running Form.
    SetToolTip - Sets the tooltip for a Layout Element.
    RGBColor - Sets foreground (text) color and background color based on the full spectrum of RGB values in red, green and blue from 0-255 for a Layout Element. This gives you in excess of 16 million color combinations vs. @color() options of eight.
    @Calendar - Displays an interactive calendar and returns the selected date.
    String Array Functions - A family of functions which operates on semicolon-separated strings. Provides simplified array functionality.
    @XLookUpAll - Returns a semicolon-separated list of values from the source element in all the matching records.
    @XLookupSourceList - Returns a semicolon-separated list of values from the first matching record.
    @XLookupSourceListAll - Returns a table-like structure of values from all matching records
    XPostAll - Posts to all matching records in external database.
    @StringArrayElementList() - Returns a semicolon-separated string of all the element names on the current layout.
    ThisElement - Built-in element reference to the element currently running programming.
    SetThisElement - Sets the built-in ThisElement reference to the named element.
    UnSetThisElement - Resets the built-in ThisElement reference to the currently running element.
    @ElementName - Returns, as a string, the element name from an element reference.
    @ElementType - Returns a number representing the type of a layout element.
    @ElementBoundTo - Returns the name of the database field to which the element is bound.
    @ElementBoundToType - Returns a number representing the type of database field to which the element is bound.
  • Programming can now be imported into a Form, as well as exported.
  • Improve the ability of Tab Pages to automatically switch when focus changes.

Fixes

  • Fixed a "loophole" that could allow Reconcile to an open application.
  • Fixed an issue where saving a layout in Designer while running client/server would cause other clients connected to the same Sesame server to reload their open application.
  • Fix so that an XP client can connect reliably to a Windows 2003 server.
  • Fixes to behavior of attached Retrieve Specs.
  • Prevent merging applications with the same layout names.
  • Allow SelectTreeItem to distinguish Sort and Sort By Timestamp.
  • Prevent Save As commands from overwriting an open application.
  • Prevent FormFieldValue and @FormFieldValue from triggering event programming.
  • Fixes to Table View Subforms.
  • Fix to @UserSelect and @XLookup writing the return value to the running element, under certain conditions.
  • Make combo boxes work with F6 editor.
  • Fix to searching from relational subforms with non-matching key types.
  • Prevent Tab Pages from ghosting.
  • Allow Split to write to either a LE or a variable.
  • Fix so PrintForm does not overwrite the color palette on systems with low color depths.
  • Fix so @Color will consistently create colors as indicated by the Programming Manual.

Version: 1.0.3
Release Date: Apr 07, 2004

New Features

  • Tab Pages can now be reordered within their Tab Group by right-clicking on the Tab and choosing Move Left or Move Right.
  • Tab selectors will now draw in the same color as their corresponding Tab Page.
  • Tab selectors draw with "fancy" slanted edges.
  • Subforms only get scrollbars if needed.
  • Expand @Rest to accept either a retrieve spec or a retrieve spec program.
  • Allow @Exit to be called from a command button.
  • Expand Form commands like @FormFieldValue to accept (but not require) the full path to the Form and the mode, to allow for situations where the same Form is open in multiple tabs. You can now specify which Form and mode to affect. Examples:
    @FormFieldValue("Countries!Cites:(add)", "Population", 1)
    @FormFieldValue("Countries!Cites:(update)", "Population", 1)
    @FormFieldValue("Countries!Cites:(search)", "Population", 1)
  • Improve Form commands to better determine which instance of a Form to affect. If the Form Path and mode are not supplied, Sesame will look for a matching Form name in the following order:
    Current Form
    Child of current form recursively
    Parent of current form recursively
    If not found, fails setting the @Error flag.
    Example:
    @FormFieldValue("Cites", "Population", 1)
  • Reports respect the ANY/ALL setting of an attached spec.
  • Undo can now undo deletion of a tab and all its contained elements.
  • Retrieve Spec can now handle multiple retrieve spec programs in the same element.
  • Retrieve Spec can now process a programmed retrieve expression matching the value of the current layout element with or without a preceding equal sign (=).

Fixes

  • Fix to image browser to allow adding and editing of image element values.
  • Fix: Undo Delete of tab elements in Designer does not leave stray End markers.
  • Fix to prevent palette collision between a form and its subforms.
  • Adjustment so that Table subforms can know how many records they have as soon as the records are retrieved.
  • Fix to Q&A translator to assign a time format that does not strip leading zeroes from minutes.
  • Fix to FormNewRecord so it does not turn off subsequent event programming.
  • Fix to rearranging elements on a Table subform.

Version: 1.0.2
Release Date: Mar 19, 2004

New Features

  • Added version number to Server window.
  • Added the ability to set a Width on Report Elements.
  • Added a new SBasic programming event (OnRetrieveOpen) to allow programming to be run when a Retrieve Spec is opened.
  • Allowed the OnElementEnter event to run on a Retrieve Spec for command buttons. Existing command buttons should use the new @Mode function to determine whether to run their OnElementEnter event.
  • New SBasic commands added. A Programming Manual supplement will be available shortly with full documentation and examples:

    SubformVisibility(element_name, state) - Sets the visibility of a subform element
    @SubformVisibility(element_name) - Returns the visibility of a subform element
    PopulateListElement(element, list) - Clears and repopulates combo boxes and list boxes.
    @FormNewRecord(form_name) - Adds records to a specified Form.
    @Mode() - Returns the Mode of the current Form: Add, Update, or Search.
    CursorPosition(element, position) - Sets the cursor position in a Text element.
    @CursorPosition(element, position) - Returns the cursor position in a Text element.
    @IsBlank(element) - Returns whether an element value is blank, regardless of field type.
    @CreateNewRecord() - Identical to CreateNewRecord() except it returns the result set position of the newly added record.

Fixes

  • Fix to allow GoTo to go to the LE that already has focus.
  • Fix to allow Reports to have an attached Sort Spec without an attached Retrieve Spec.
  • Table view subforms position themselves correctly on Tabs.
  • Fix to handling of German and other European keyboards.
  • @LoadRetrieveSpec now goes to the Retrieve Spec before loading.
  • General fixes to searching for blank non-text values.
  • General fixes to programming in table view subforms.
  • Fix to allow @GlobalValue to be called from a Retrieve Spec program.
  • Fix so XUserSelectR uses a LE name instead of a field name. Makes it consistent wth the other X commands.
  • Fix to NotifyForm.
  • Fix so check boxes respond to OnImmediateChange event.
  • Make combo boxes more responsive to keyboard and mouse, especially when first entered.
  • Fix so PrintString correctly calculates value dimensions when wrapping at right margin.
  • Prevent corrupt initial values in a Q&A database from crashing the translator.
  • Fix so long restrictions do not crash.
  • Retain compiled programming, so that programming in Runtime is only compiled once per Form, per session.
  • General improvements to ODBC driver.
  • Fix to accomodate Forms with more than 511 elements.
  • Fixed double-scroll in Layout Manager and Field Manager.
  • General improvements to subreports. NOTE: Any subreport elements created before version 1.0.2 must be removed from the parent report and reinstated. The subreport itself does not need to be deleted or redesigned. You only need to delete and reinstate the subreport element on the parent report.
  • Added Sort to the Results Menu, so it can be called with @SelectTreeItem.
  • Fix to formatting to handle additional European number and currency formats.
  • Fix to static images in Reports.
  • Fix to XPost and XPostR to handle numerics in the destination using REPLACE.
  • General fixes to GoTo, CPREV, CNEXT, CHome, CEnd, CPgUp, CPgDn.
  • Fix to security to prevent a lockout condition.
  • Fix to file path handling in X commands.
  • XPost and XPostR now return an error if the target application is open on another server.
  • Fix so loading a saved Import Spec includes Ignore columns.
  • Fix to allow deletion of SUBRECORD fields.
  • Fix to scaling of static images on Print record.
  • Fix to Designer so that extensive font changes do not crash.
  • Fix to date formatting in SBasic.
  • Alert added to Table View if mandatory restrictions are not met.
  • Fix to allow Count and Average to work properly in Report View Footers.
  • Fix to allow Reports to be selected using @SelectTreeItem.

Version: 1.0.1
Release Date: Jan 26, 2004

New Features

  • "No Background" options added to Print Record commands. These will print the form with no background color, no boxes around the values and values forced to black text.
  • Added Close Command Area and Open Command Area to the View menu. These are disabled if SBasic invokes CloseCommandArea, or if the -closed startup switch is used.
  • Sesame Server interface displays the maximum number of allowed connections.
  • If a value entered into a layout element cannot be converted to the correct type, a warning appears. Two new start up switches can be used to control warning level, if you want it to be different from the default.
    -warn_none: Turns off almost all popup warnings and confirmations, including invalid values, confirm deletes, non-mandatory restrictions, etc.
    -warn_high: Behaves as the default mode, except you will also be warned if values are reformatted in any way. This includes formatting dates, adding commas to numeric values, etc.
  • Alt-F8 brings up the Spec Manager
  • Ctrl-Enter in tables enters "edit" mode.
  • New SBasic command added:

    ThrowFocus(element)
    Parameters: element as element reference
    Type: Miscellaneous
    Returns: Nothing
    Sends focus to a different layout element. This command is different from GOTO in that it automatically returns and completes execution of the calling code, whereas GOTO halts execution of the calling code.
    If ZipCode <> "" Then
    {
    	ThrowFocus(City)
    	// The following line will run, even though the focus has moved
    	State = "PA"
    }
  • New command line switch (-daemon) added to allow Sesame server to run without a user interface.
    sesame -daemon -server my_server

Fixes

  • Additional handling for printer driver quirks added to prevent "postage stamp" printing and some other printing anomalies.
  • Fixes to handle additional cases during Q&A translation based on databases provided by users.
  • Numeric keypad symbols are recognized. ( * / - + )
  • General fixes to initial value handling.
  • General fixes for Table type subforms and Table View.
  • General fixes to navigation and event programming on Tabs.
  • Improved font management.
  • General improvements to determining whether a record has been changed.
  • Fix some navigation and keyboard issues with Combo Boxes.
  • Fix to searching for blank values for certain field types.
  • Fix to prevent the file browser from sometimes truncating the first letter of the path.
  • Fix to Change Field Type.
  • fileReadLn() no longer cuts off the last character of the last line in a file.
  • CreateNewRecord prevented from recursing into other event programming to create an endless loop.
  • Change PrintString to use the minimal hardware margins instead of defaulting to 1 inch.
  • Improve how Redesign Current Application behaves in a client-server environment, including adding the ability to handle spaces in the server name.
  • Fix to allow Ditto to handle images.
  • Passwords are no longer retained until Sesame is closed.
  • Fix to commands in Designer that change element position to account for scrollbar position.
  • Fix to validation of field name when adding a new subform to allow reuse of existing relationships
  • Fix to allow the Trial version to handle large applications.
  • Fix to reports so if there is a numeric column that has a blank value it does not repeat the value of the previous column.
  • Fix to allow Ctrl-UpArrow to navigate out of a subform.

Version: 1.0.0
Release Date: Dec 15, 2003

Initial Release

  Learn more about Sesame Database Manager
At present, we are using Sesame to manage about 30,000 products on our e-commerce website. Sesame handles all the pricing, product descriptions, thumbnail and detailed images, etc. We can effortlessly email our customers invoices, order confirmations, print packing slips, sales totals, etc.
  Steve A.
Small Business Owner - Texas