Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . September 23, 2017  5:36 am. 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 1 7
Vol. 14, No. 3
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries

July 2017 issue summary. . .

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.

WordMerge Special Ops — Subforms, Etc.
WordMerge has a history of tweaks lengthy enough for a Subscriber Express Index search at 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 that.

_______________You ask. We answer.

  • 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 use today

  • 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 view.

  • 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 On-the-Fly — 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

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.