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.

IMPORTANT NOTE: The communications protocol has changed with this version. Clients earlier than 2.6.4 will not be able to connect to a 2.6.4 server.

IMPORTANT NOTE: If you are using the Sesame API, this version of Sesame requires an updated version of the API - Version 2.6.4. Free Download here.

New Features

New sesame.ini File Entry: ABANDON RESULT SET TIMEOUT: Sets the number of seconds a result set will be retained in hopes that a client with network issues will reconnect and reclaim that result set. It defaults to 600 seconds.

Fixes

Fix so that the "-command" flag does not allow any GUI activity, so that the -command flag can be used on headless servers.

fix to the ASCII export routine so that it filters out both ASCII 10 and ASCII 13 (as opposed to "\n").

Fix crash when closing a form with a subform shared by another open form.

Fix to the focus model in tab pages so that clicking on a tab's tab causes the focus to reside (briefly) with the tab page itself.

Fixes to the mechanism by which dormant clients and clients with unreliable network connections abandon and reclaim result sets.

Fix so that entering a table cell for edit and resizing that cell does not cause a crash.

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.

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.

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

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.

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.

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.

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.

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

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.

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.

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.

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

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 FormChild of current form recursivelyParent of current form recursivelyIf 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.

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 elementPopulateListElement(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.

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

Learn more about Sesame Database ManagerI've never had programming experience before, but I've seen enough to know that Sesame can do just about ANYTHING, which is why I've committed my time and resources to learn how to use it. I've got faith in Lantica!