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


(Insider password required)

Previous Issue Summaries
 

 

October 2019 issue summary. . . [order code OCT19]

Copying Records to a 'Matching' Database?
What qualifies as a matching database and why would a company ever need one? Think workflow. From initial order entry to production to final invoicing, it was the way they had tracked their order processing for 25 years. Why mess with a good thing?

A Brief History of Money (Check Printing)
If you printed payroll or vendor checks from Q&A back in the day (maybe you still do), chances are you got the know-how from The Quick Answer newsletter. The January 1995 issue spelled it all out. The database design and programming that made it possible was rather complicated back then. These days it's pretty much a no-brainer.

PrintString() in a Grid Structure
Right-aligning a column of fields on a Sesame form, in Excel or a Word table is easy. But Sesame's PrintString doesn’t know or care how the fields and/or data values should align. It just prints them starting at the specified X and Y page coordinates. Right-alignment — particularly within a column of numbers — takes some doing.

Default   Right Align
$76.28
$866.49
$1,024.87
$89.25
$344.15
$10,923.19
  $76.28
$866.49
$1,024.87
$89.25
$344.15
$10,923.19

Big Range Lookup Solution
The primary databases for a landscaping and sprinkler system sales and service company were PROPERTY and JOBS. The PROPERTY database stores owner address and billing details along with information on the types and features of the various systems installed at that location. The JOBS database tracks system installation, repair and periodic maintenance. Both databases had to "talk" to each other in a big way.

@Numbers for All
A handy dandy little facility that enables you to check — and optionally reset — Sesame-style @Numbers for all database that use one. The gizmo resides on the main menu in this case and requires a password to use. We show all the components, programming, and typical usage should you care to assemble one of your own.
 


_______________You ask. We answer.


  • Create a Sorted, Drop-down, Multi-entry Field — A tall order, but you've  no doubt seen it in many variations on websites. In this case, though, the company needed to be able to select more than one U.S. state from a pop-up list of states.

  • Restrict List Not Working — Old Mr. Ampersand strikes again! How to work around him.

  • What Time Is It at the Customer's Site? — Not very productive to make a sales call to a prospect or customer at 6:00am his or her time. Can't Sesame tell us what time it is there when we pull up the record?

  • Sesame Sometimes Not Saving Data — A mystery. Think VOIP. Think IP. Think ports.

  • Sesame Exports Wrong Number of Records — Can't happen. . . Unless. . . Be mindful of where you're getting the data you paste into your fields.

  • Design Forms for Data Entry and Printing  — An alternate form or two can do wonders for your printing needs.

  • Get More from Your Lookup Tables  — An application with multiple databases might also have multiple lookup tables. Here's how to combine them into a single lookup table that all the databases can share. Very cool. 


_______________Technical tidbits you can use today
 

  • Find Field Data Types with a Mass Update. Run this little one-record mass update to get a list of all the fields and their bound-to data types.

  • Translated Reports and Data Types ― Sesame's Translator  might occasionally fail to properly bind a report column to its correct data type. Here's a quick and easy fix.

  • Quick-Select All Elements in a Report Design — Do you really need to Shift-click on 20 report elements just to apply a different font or font size? Of course not.

  • WordMerge to No Records? Fix WordMerge so it doesn't try to run a merge in Search mode.

  • How to Output All Field Restrictions  ― Got lots of Restrictions in a database. This one-record Mass Update will list them all so you can decide what they're worth and how you want to invoke them in runtime.

 


(Insider password
required)

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.