Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . March 21, 2018  8:50 pm. 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 8
Vol. 15, No. 1
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries

January 2018 issue summary. . . [order code JAN18]

Linking Emails to Database Records
A company was looking to resolve some email-related issues and wanted to know if their database system could be leveraged in some way to help out:

 “Is there any way we could access our sales engineers’ past email exchanges directly from our PLANTS (customers) records?

Indeed they could. With Plant XYZ’s record displayed, email exchanges with personnel there can be brought up for viewing with a button click or keyword search.

Control Data Entry with Form Attributes
Need to tighten things up during data entry ― make users follow a prescribed pattern before a record is allowed into the database? This goes beyond mere restrictions. It's like having an intelligent assistant guiding the process. Sample application included in this month's subscriber download file.

Photo Aging (Gracefully)
For databases that store photos of people, aging can be a factor in photo management. So a company might want to round up the folks whose photos are out of date and take new ones. But how to tell how old a photo on file is unless you’re looking at the person and their photo at the same time? Easy ― have Sesame ask the operating system.

How to Keep Related String Arrays in Sync
Sesame string arrays make handy organizers. They can assist with a variety of processing tasks by keeping track of multiple data values that can be manipulated in programming. Unlike formal arrays, though, string arrays are strictly one-dimensional. Or are they? String arrays can be grouped or “stacked” to make what amounts to a multidimensional array. This kind of power adds a new dimension to what you can do in Sesame.

Auto-Updating Outdated Product Descriptions
A company had improved on many of its product descriptions over the years. Now in Sesame, the law of unintended consequences caught up. To accommodate new features, all their old lineitem descriptions had to be brought up to date with the latest ones, and any future description changes would need to automatically update the previous ones.

Create a Mini Data Dictionary
A school district was being forced to standardize its databases on a product other than Sesame. Ironically, Sesame had the tools to make the conversion far less difficult than it otherwise would have been.

_______________You ask. We answer.

  • Find a Date Range in a String of Dates — It can be done. Here's how.

  • Popup Multiple Fields from External DB — When adding a new invoice, a company needed a window on the customer's record.

  • Must-fill Fields in Add Mode Only — When standard field restrictions won't do.

  • Retrieve Not Working in Keyword Fields — It worked OK in Q&A. Why not in Sesame?

  • Checking Checkboxes — From elsewhere, how do you know if they're checked?.

  • Archive Database Translation — Sensible archiving options for multiple translated databases with the same structure, reports and so on.

_______________Technical tidbits you can use today

  • Class-ify Those Reports — A quick-'n'-easy drop-in makes reports easier to follow.

  • Using @Frac for Varying Quantity Formats ― You've got Quantity field that must be formatted for 2 decimal places but you don't want a .00 to print.

  • When While-While Loops Beat For-While Loops — Your loop programming could be running far longer than it should.

  • Reports, Excel and Carriage Returns in the Data — You open a report in Excel and see more rows than the report actually has. What's up with that?.


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