What About that
Recent Applications List?
A grumble is sometimes heard from folks new to Sesame over what winds
up on their Recent Applications list. Handy when working as
expected, this shortcut-like interface feature opens an application
with a click. But it isn't quite so handy when there's no way to remove
unwanted testing-only and sample apps from it. We take a fresh look at
this and offer a sensible solution that doesn't involve turning the
feature off altogether.
Make Reports Reveal
Their Retrieve Specs
The Retrieve specs that produced a report don’t show in the report
itself. But they can be helpful to know, particularly when those
reports might be passed along to others. We show an easy way to print
the retrieve specs right in the report's header so there's no doubt as
to exactly what the report covers.
Values In a Parent/Child Structure A new report exposed an underlying problem with a database's
data structure. The report was pulling subform data from the wrong
parent records. The fault wasn't in the report but in the database ―
the report was merely exposing it. An investigation uncovered what had
happened and when, and a finely-tuned Mass Update set things to right.
Translating Wonky Date & Money
Fields (or How Not to Lose Data) Q&A allowed just about anything in Money and Date fields. Users
could simply hit Enter to blow off Q&A’s warnings and go on
their merry way, leaving corrupted data behind that could be
problematic in searches, reports, merges and other output. And even
more problematic in a Sesame migration. We suggest how best to deal
with something like this at both ends.
Create a Customer Activity
Snapshot A wholesale products company wanted to give its sales people
instant access to a summary of a customer’s buying habits, typical
order volume and recently-purchased products. Not a report, but a
tightly-organized capsule view, in a popup, available from the
customer’s record with the click of a button. Sample Application
included in this month's subscriber download file.
Archiving Parts of a Huge Database A recent Q&A-to-Sesame system migration brought up some
size-related concerns ― starting with a new application that would be
in the half-a-gigabyte range. This case study details how the app was
reorganized to minimize its otherwise massive footprint and make it
more efficient, including the ability to archive or restore records
with a button click.
How to Check/Change the
@Number — Sesame allows just one @Number per
application. But where is it? How do you check it? How do you reset
it? And why you have to be careful when doing anything involving
Operations — A company wanted to password protect certain
database operations independently of the overall security scheme.
Sample application included in this month's download file.
Sesame / Word MailMerge Rules —
A detailed recap of the right way to merge print your Sesame
data with a Microsoft Word merge document.
Windows 10 Updates Might Delete
Scheduled Tasks — If you use a Scheduled Task to start
Sesame Server and automatically unlock your application(s)
following a server reboot, you'd be wise to incorporate this new
info into your methodology.
Turn Off Anti-Virus Programs
for Sesame Files — Tips on excluding certain files from A/V
scanning to improve Sesame's performance.
Two Different XLookups From
Same Element — How to configure a Sesame gizmo to run one of
two different lookups depending on whether the lookup key is text
_______________Technical tidbits you can
Hide All Reports in a Database —
Or hide just certain types of reports, such as those for
management eyes only.
@LocalFileDialog― How to Find Multiple File
Types in One Go ― A clever way to make Sesame
show, say, .doc, .docx and .docm Word files in
a get-a-file run. Adaptable to isolating different image file types
Make a Report Total Text 'Money'
Values — Money amounts in, say, a combo box, are really text
values. So how to get a Sesame report to treat them as money so they
can be totaled?
A Simple Report Auto-Sizer — A
nifty way to enable farsighted users to make reports display for
them in a larger font size.
(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.