Sesame Change Log

Current Documentation Errata and Additions - Last updated with 2.0.6

Current sbasic_include.sbas file - Last updated with 2.0.6

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

• Major version upgrade. See new feature list.

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