October 2017 issue
summary. . . [order code OCT17]
or 'Snaked' Three-Across Reports
Sesame reports output your database information to HTML-encoded (web
browser) format. Picturing the encoding needed for a two- or
three-across arrangement wasn’t hard. The problem was getting the
report engine to accommodate it. Sample application included in this
month's subscriber download file.
Custom Exporting with Mass Update
Sesame has perfectly good data export facilities. So why would anyone
look at “Mass Update” as an alternative? When certain conditions and
requirements are in play, there could be a method to the madness.
Drop Photos Into
Forms On Demand
A bound Image field in a database shows pictures in the records. All
well and good if those pictures always need to be seen. But since even
a small image file can be 20K — more than all the data in the record —
why not make them optional? Here's how to drop an image onto a form,
only as needed, with a click of a button.
Charts & Parts —
Sales Trends at a Glance Graphics and visuals communicate faster than words and numbers
when comparing elements in an array of data. A company owner wanted to
pull up any product record and get an instant comparative recap of its
sales over the years of interest. It was the trend she was
after — and a perfect task for Sesame’s StaticChart
capabilities. Sample application included in this month's
subscriber download file.
Homegrown Dialogs Sesame comes with a variety of built-in dialogs, along with two
do-it-yourself varieties. A company wanted a "simple report" that
turned out to be anything but. A custom dialog was the perfect
solution. Sporting auto-fill Product ID and Product
Description dropdowns, along with a date range selector, it's
adaptable to a variety sales order, invoice or purchase order
needs. Sample dialog form included in this month's subscriber
— A method for adapting programming to deal with different
situations, including temporarily disabling On Form Change
Search with Multiple 'Ors'
with Options — Or this and/or Or that. It can
get real confusing real quick. This mini-tutorial aims to keep it
Run a 'Category' of Reports
from a Custom Menu — Simplified report running when the only
difference is, say, the customer your running it for.
'Undo' Record Damage Done by
Improper Mass Update — In some cases it is possible to
reverse a botched Mass Update.
Printing a Table View — If
you've ever wondered how, here are some options.
_______________Technical tidbits you can
Is [fill in the year] a Leap
Year? — A couple of math methods to determine if February of a
given year has 28 or 29 days, along with Sesame's own ability to
know when a leap year occurs. Application included in this
month's subscriber download file.
Quick Dupe Check on Multiple Values ― To prevent entry of a
value that already exists in the same field in another record in the
database, you can set the field to Unique in the Read Only
properties in Designer. To detect when two or more values in
record match the same fields in the current or another database,
this single-shot method can do the trick.
When ThrowFocus Won't
— Under some conditions, Sesame's ThrowFocus command won't
move focus to the specified field. Neither will a GoTo. A
simple workaround takes care of the problem.
(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.