2020 issue summary. . . [order code JAN20]
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
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
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.
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?
In Sesame — Talk about a total paradigm shift.
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
— 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
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 required)
How to Copy Programming Code from
Inside Sesame to paste into Sesame's Program
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
(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.