Range Lookups vs. XResultSet
―Bridging the Gap / Nesting Commands
Is it possible to pare a 16-line program down to a one-liner and get
the same result? It is, as you’ll see. But why would anybody need or
want to do such a thing? After all, Sesame doesn’t have a programming
limit as Q&A did.
Adding Subrecords via Programming
A complex Sesame application can be home to a maze of form view
subforms, some with embedded table view subforms. We needed to come up
with a way to navigate such a structure in order to import a new row
of data into a table subform located on the last (most recent)
instance of a particular form view subrecord.
Ops — Subforms, Etc.
WordMerge has a history of tweaks lengthy enough for a Subscriber
Express Index search at insidesesame.com to turn up more than
60 tips and articles on it. We add to that list here by improving on
an adaptation first explored more than 10 years ago — how to merge
both parent and subform data into a Word doc. We expand on that
original approach to make it more flexible and reliable.
WordMerge Unlimited Subform
Records Two issues with Sesame’s drop-in WordMerge program crop up from
time to time. The first centers on what data can be included in a
merge. The other has to do with the merge document itself. For merge
docs requiring both parent and child data, it’s best to swap out the
traditional WordMerge program for a simpler (and much smaller) program
that can do the job with less fuss. In this expanded version of last
month’s Son of WordMerge article, we show how to do
Sesame Version 2.6.3
— A few things to watch for in this latest release.
Windows 10 version 1703 —
Microsoft's latest release has some really cool features. Anything
else you need to know Sesame-wise? [See critical last minute
update p. 25]
My Big XLookup Stopped Working! —
Bad things can happen when adding one or more fields to a working
XLookupSourceList command. Here's the only way we know of to
isolate and resolve the problem.
Open Reports with Excel Redux
— The 'Open in Excel' option for Sesame reports disappeared
in MS Office a few years ago. Here's how to get it back.
'Export' with Quick Reports —
In a client/server environment, Sesame's Export feature puts the
export file on the server. This quick 'n' dirty workaround will let
you get at the data locally.
Retrieve Spec in
XResultSetSearch Program — A refresher course on the proper use
of @Date to retrieve a set of records.
Partial Sort of Dropdown Lists —
Need a picklist to sort some of the items a certain way but not all
of them. Here's the trick.
_______________Technical tidbits you can
Make Lookup Tables Default to Table
View — Don't you just hate it when you open a lookup table and
it's in Form view? Here's how to make it default to Table
Programming All Those Date Fields ― Got a slew of date fields
on a form and need to program them to pop up @Calendar
automatically? This will save you time.
Copy, Rename, Move External Files
— When it comes to external file management, Sesame’s programming
tools are somewhat limited. But where there's a will there's a way.
Get a Fifth Column for Your Lookup
Table Subform — A Q&A Lookup Table migrated to Sesame gives you
the same Key column plus the four related data columns. As
occasionally came up back in the Q&A days, perhaps you could use an
additional data column or two.
(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.