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

(Insider password required)

Previous Issue Summaries

July 2018 issue summary. . . [order code JUL18]

Databases-To-Go A Case Study
Data disasters happen. From a fire or natural disaster to Grand Theft Computers or a ransomware attack that hits even the off-site backups. It's hard to beat having an up-to-date copy of the database in hand off-site on a portable medium. How about this: at the end of the day you pop a thumb drive into your workstation, click a button, and off you go with a fully functional up-to-the-minute copy of your company's database in your pocket.

Filtering Reports with Subrecord Data
The report that comes with the sample Charity Donors database lists all the subrecords whether you want them all or not. No way to specify a date range like the previous month, last year or year to date. Jon McLaughlin's new report does the trick. And the technique is adaptable to most any form/subform database. Sample application included in this month's subscriber download file.

What's Up With the Fonts?
Sesame forms, fields, labels, buttons and reports are all custom-fontable. But fonts differ from other design attributes — they can be substituted by other (unwanted) fonts in ways that might never be seen by the application designer. We show how to find out (under the hood) which workstations  have which fonts on them, along with a program that scans all the forms in an application and comes back with a list of the fonts used in them.

Q&A Crosstabs to Sesame Totals-Only
Sesame skips over any crosstab reports when translating a Q&A database. But when they're fairly simple crosstabs, as they often are, chances are good that they can be reborn in Sesame's Report Designer with a similar summary format and the same totals.

How to Import XML files
You  know what plain ASCII or CSV files are — a more or less universal export/import format. But a more modern type of plain text export/import file format called XML is seeing increasing usage in companies. Sesame's import facilities don't accommodate XML, but an additional easy step will take care of that.

_______________You ask. We answer.

  • Importing Q&A Data — Q&A's export options can be troublesome when the data is destined for a non-Q&A application. Here are some tricks you might be able to use to migrate data from a Q&A database to Sesame.

  • Round Up to $5 — An unusual requirement to be sure. But it can be expertly done. Sample application included in this month's download file.

  • Improving the Drop-Down List — Sometimes drop-down Combo Boxes aren't the right tool for the job. If you're after dropdown-like convenience with more flexibility, check out this replacement option.

  • Check Multiple Fields for Similar Records — This technique combines the date and  purchase order number to flag two or more records with the same ID number.

  • Easy Scheduling System — Find out which vehicles are already scheduled for a given block of time.

  • "I don't have a Thumbs database, but there's one in my Sesame Data folder!"

  • Semicolons in Lookup Data — Ouch! —What to check for if an XLookupSourceList program is pulling in some, but not all, of the data, or some of the data is landing in the wrong fields.

_______________Technical tidbits you can use today

  • Find Last Month's Records with a Fixed Retrieve (plus how to make date-based retrieves run a whole lot faster on large result sets).

  • Effortlessly Trash the Database ― A no-brainer. Just follow these easy steps.

  • Avoid Special Characters in String Arrays, Too — maybe you thought this was just for lookup key values?

  • //Rem Your Retrieve Specs — Why toss out a useful spec you might need again when you can just temporarily disable it?


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