Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . December 17, 2017  9:29 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. 4
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries

October 2017 issue summary. . . [order code OCT17]

'Stacked' or 'Snaked' Three-Across Reports
Sesame reports output your database information to HTML-encoded (web browser) format.  Picturing the encoding needed for a two- or three-across arrangement wasn’t hard. The problem was getting the report engine to accommodate it. Sample application included in this month's subscriber download file.

Custom Exporting with Mass Update
Sesame has perfectly good data export facilities. So why would anyone look at “Mass Update” as an alternative? When certain conditions and requirements are in play, there could be a method to the madness.

Drop Photos Into Forms On Demand
A bound Image field in a database shows pictures in the records. All well and good if those pictures always need to be seen. But since even a small image file can be 20K — more than all the data in the record — why not make them optional? Here's how to drop an image onto a form, only as needed, with a click of a button.

Charts & Parts Sales Trends at a Glance
Graphics and visuals communicate faster than words and numbers when comparing elements in an array of data. A company owner wanted to pull up any product record and get an instant comparative recap of its sales over the years of interest. It was the trend she was after — and a perfect task for Sesame’s StaticChart capabilities. Sample application included in this month's subscriber download file.

Homegrown Dialogs
Sesame comes with a variety of built-in dialogs, along with two do-it-yourself varieties. A company wanted a "simple report" that turned out to be anything but. A custom dialog was the perfect solution. Sporting auto-fill Product ID and Product Description dropdowns, along with a date range selector, it's  adaptable to a variety sales order, invoice or purchase order  needs. Sample dialog form included in this month's subscriber download file.

_______________You ask. We answer.

  • Programming 'Sometimes' Calculations — A method for adapting programming to deal with different situations, including temporarily disabling On Form Change programming.

  • Search with Multiple 'Ors'  with Options Or this and/or Or that. It can get real confusing real quick. This mini-tutorial aims to keep it simple.

  • Run a 'Category' of Reports from a Custom Menu — Simplified report running when the only difference is, say, the customer your running it for.

  • 'Undo' Record Damage Done by Improper Mass Update — In some cases it is possible to reverse a botched Mass Update.

  • Printing a Table View — If you've ever wondered how, here are some options.

_______________Technical tidbits you can use today

  • Is [fill in the year] a Leap Year? — A couple of math methods to determine if February of a given year has 28 or 29 days, along with Sesame's own ability to know when a leap year occurs. Application included in this month's subscriber download file.

  • Quick Dupe Check on Multiple Values ― To prevent entry of a value that already exists in the same field in another record in the database, you can set the field to Unique in the Read Only properties in Designer. To detect when two or more values in record match the same fields in the current or another database, this single-shot method can do the trick.

  • When ThrowFocus Won't — Under some conditions, Sesame's ThrowFocus command won't move focus to the specified field. Neither will a GoTo. A simple workaround takes care of the problem.


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