Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . February 22, 2019  10:10 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 9
Vol. 16, No.1
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries

January 2019 issue summary. . . [order code JAN19]

Streamlining WordMerge For Big Databases (and Other Tricks)
WordMerging in databases with an exceedingly large number of fields can have unintended consequences. Problems that might not be immediately apparent but might very well come back to bite. Fortunately, an easy tweak or two in the WordMerge program can protect against merge failures and dramatically improve overall mail-merge performance.

Exporting By Checkbox
A company needed a custom export solution ― a gizmo in the INVOICES database that lets them browse their recent invoices and selectively mark them for export for periodic mail-outs. The routine prevents the same Bill-To company from winding up more than once in the export file. Results automatically come up in Excel.

Customizing the WordMerge Docs List
Documents can be excluded from the WordMerge Select Folder or Document picklist without having to remove them from the usual default C:\Sesame2\ Docs WordMerge docs folder. Or, the opposite — only the specified docs can be allowed to show on the picklist. All it takes is a little string array magic and knowing where in the WordMerge program to work it.

Tracking Groups of Related Dates
A company needed to track four critical dates. Not their own dates. Their vendors’ dates. The approach here can prove useful when (1) there are multiple date fields in a record related to one another in some way, (2) the dates require periodic updating, and (3) an easy way is needed to find records where one or more of the dates is approaching or has passed.

Hassle-Free Price Hiking
A company selling high-volume small-ticket products to the trade was looking for a way to simplify its price updating process. Prices on several hundred products needed to be upped a bit at year end. With 8 quantity pricing tiers per product, it promised to be an agonizing and error-prone exercise. In Q&A they had no choice but to do in manually. in Sesame, they were looking for some magic.

Exporting Potential Dups to Excel
Check out this handy click-'n'-go routine that scans a 50,000-record database for potential duplicate records (based on your custom criteria) and shows the results in Excel in under 20 seconds.

_______________You ask. We answer.

  • Translated Programming Not Working — Disaster struck when a company's Q&A Read-Only fields were all programmed.

  • Translated Programming Not Working 2 — Revisiting the Auto-calc phenomenon.

  • No Main Form? — What happens exactly when Sesame translates a multi-form Q&A for Windows database?

  • Use Data from One Database as a Retrieve Spec in Another — Find the equipment, get the account numbers, retrieve the customer records with those accounts, and print a report. The only tricky part about this is working with two separate databases.

  • Double-Duty Search — an Any Restrictions search followed by a Search in Current Results was the only way to tackle this thorny problem.

  • Replacing a Sesame Client  — A user's computer dies. What's the easiest way Sesame-wise to get that user back in the game on his or her new box?

  • XLookup Data and Allow Changes — Correcting a couple of thorny issues when relying on a large zipcode lookup database to auto-fill fields.

  • Combine Multiple Database Translations — When it's possible to combine two databases into one for the sake of efficiency.

  • Q&A Windows Translation Issues — You might be in for a few surprises should you attempt to translate a Q&A for Windows database. Here's what to expect and how to deal with it.

_______________Technical tidbits you can use today

  • Express Export to Excel ― Using a custom data export program instead of Sesame’s own export facilities, you can have the results automatically pop up in Microsoft Excel  with no additional steps or questions asked.

  • Is .doc Dying in WordMerge? ― You're liable to get this error message one of these days. What to do about it when you do.


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