Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . May 26, 2020  6:54 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 2 0
Vol. 17, No.2
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries


April 2020 issue summary. . . [order code APR20]

WordMerge Mini — Just the Basics. A Case Study
A county legal department dealt with wills and estate probate matters for its residents. With new computers on the way, legacy programs like Q&A had to go. Merge documents were central to the operation. We cooked up a scaled-down version of WordMerge just to see what it would take to meet the department's demanding document production needs.

Old School Label Printing
A company we migrated from Q&A to Sesame a few years back and hadn’t heard from since ran into a little trouble after replacing their aging Windows 7 pc’s with new Windows 10 machines. A label-printing routine they’d relied on for more than 25 years was dead in the water. It couldn’t be made to work on the new computers. We had a solution.

Eye-Catching Quick Reports Revisited
In the May/June 2016 Inside Sesame (Eye-Catching Quick Reports) we showcased a custom program that adds a touch of class to otherwise plain Jane Quick Reports. A fellow Sesame developer recently proposed a few more options to better accommodate his needs.

Fade-Away Input Prompts
Taking a cue from computer prompts that appear briefly then fade out (incoming email alerts, for example), the boys at the InsideSesame labs wondered if a nifty feature like this could be adapted to data entry validation. What would fade-away prompts look like in a Sesame database and how would they work? (Sample databases)

_______________You ask. We answer.

  • Hide, Don't Drag Fields Off the Form — What's the Sesame Designer Canvas? And how can it catch you out if you leave programmed fields on it?

  • Move Multiple Notes Fields to a Single Notes Field — Q&A databases often have repeating fields for notes or comments. Organizing them in a new single multiline notes field can be a tricky proposition. We show how to get it right.

  • Report Retrieve Specs the Right Way — When a report's design contains an embedded sort spec and there's different sort spec in the form for the retrieved records, only one of them will win out.

  • Broken Report Sort Specs — Beware of the Booleans, particularly with sort specs in both a main form and subform.

  • Saved Sorts Locked? — How an unknown/unexpected sort spec can botch a Sesame report.

  • Navigate Your Tabs with a Command Button  — Open the tab group you want from a handy Go-to-Tab picklist.

_______________Technical tidbits you can use today

  • Update a Combo Box On-the-Fly — Have Sesame create a new record in lookup database "A" when a Combo Box's lookup list in database "B" doesn't have it.

  • The Strange Case of the Sorted Subform
    A company that had been stable on Sesame 2.6 for years finally got around to upgrading to Sesame 2.6.4. A new issue was immediately noticed. A table subform that served as a ledger for charges and payments went wonky when a new charge or payment was added. But a bit of additional code set things right.



(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.