Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . February 20, 2020  1:32 pm. PST
T H E  Q U A R T E R L Y  G U I D E  F O R  S E S A M E  U S E R S / D E V E L O P E R S

2 0 2 0
Vol. 17, No.1
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries


January 2020 issue summary. . . [order code JAN20]

Month-End Accounting Reports Made Easy
Following a migration, the company brought up a little something they had neglected to mention ―  a complex Q&A procedure they followed each month to assemble a package of specially-edited reports for their outside accountant. A custom Sesame facility designed to streamline this recurring chore turned a tedious hour-long job into a 5-minute one.

Accepting User Input (or How to Hack a Sesame Database)
There hasn’t been much talk in these pages about validating user input in Sesame. Anyone who has done any web design knows that when visitors to a site submit information, the most important imperative is:  Trust No User Input. The same can hold true in a database.

The Strange Case of the Faulty Field Editor
F6 — the function key that opens and closes the expanded text editor for reviewing / updating lengthy info — makes multiline fields easier to maintain. In Q&A DOS, F6 opens a field editor that occupies half the screen. Q&A Win vertically expands a multiline field a bit on entry. In Sesame, F6 in a multiline field pops up a scrollable editor you can move around the screen and resize to suit. But in the latest Sesame version, some head-scratching behavior occurs if two multiline fields happen to be bound to the same database field.

Supercharged F6 for Multiline Fields
We cooked up a little something that turns Sesame's F6 key into a turbo F6+ key that automatically uses @PopupStringEditor for any and all multiline fields on a form. If you've got a database peppered with multiline fields, this mod is worth a look.

Report Alignment ― Chrome & Edge
When the default browser Sesame uses to display reports happens to be either Google’s Chrome or Microsoft’s Edge, strange formatting issues have been reported in the latest versions of these two browsers. A Sesame report that should have aligned-left wound up aligning-right instead. Here's the scoop along with the fix.

_______________You ask. We answer.

  • Another Milestone — Windows 7 support is about to end. This is mainly for folks who might still have Q&A databases in their system that they occasionally consult for historical information.

  • Get Data from a Previous Record in a Report — For a Sesame accounting reconciliation report, how to go about getting  last month's ending balance from a record that isn't included in the report?

  • Translated Q&A Report Issue — Empty reports, even though the data is there in the report's result set. What's going on here?

  • Misunderstanding Restrictions In Sesame — Talk about a total paradigm shift.

  • PopupStringEditor to Edit fields — A Sesame user had so many multiline fields in his database that he couldn't see straight.

  • Where Are My Q&A Field Templates?  — Sesame's take on  field templates can be a bit wanting. Here's what can be done to smooth things over.

_______________Technical tidbits you can use today

  • Beware of 'Min' or 'Max' as Data Values. Strange things can happen.

  • Find Field Data Types Revisited ― A fresh approach to a tip in last year's last issue.

  • Other Sources of Text for @PopupStringEditor ― Normally, this handy Sesame function picks up the text in a multiline field for more convenient viewing and editing. But you can optionally make it grab the text from any plain text source, such as the content of an external Notepad file.



(Insider password

How to Copy Programming Code from
Inside Sesame to paste into Sesame's Program Editor

You can copy programming code from Inside Sesame Acrobat PDFs and paste it into your Sesame Program Editor.

Select the code with your mouse, then Right click on the selected text and choose Copy to copy it to the clipboard. (If the program continues to another page, do that page separately.)

In Sesame's Program Editor, select Edit | Paste (or press Ctrl-V) to paste the copied code into the appropriate LE/Event slot.

Inside Sesame programming examples may inadvertently contain styled quotes. If these are present, you'll get a lexical error when you Test the program. You'll need to replace these styled quotes with the plain straight quotes the Program Editor requires.

Sesame doesn't like slanted (styled) quotes: “SomeValue″
Sesame likes plain straight quote marks: "SomeValue"

To convert any styled quotes to plain quotes in the Program Editor:

  1. Copy one styled opening quote to the clipboard.
  2. Open the Program Editor’s Search | Replace box.
  3. Paste (Ctrl-V) the styled opening quote into the Find field.
  4. Type a plain quote (") in the Replace field.
  5. Click Replace All.

Follow the same steps to replace any styled closing quotes with plain quotes then retest the program.