Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . March 26, 2017  11:53 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. 1
(New issues posted quarterly by 5th of month)

(Insider password required)

Previous Issue Summaries

Note: Beginning with this issue, we are on a quarterly publication schedule. New issues will be posted in January, April, July and October by the 5th of the month. If you're a subscriber, you'll continue to receive your email notifications when new issues have been posted and be entitled to the total number of issues you had with your bi-monthly subscription. New subscriptions and renewals will be for the quarterly issues.

January 2017 issue summary. . .

A Street-Smart Sesame Service Calls Calendar
For businesses that schedule service calls by day of the week, starting time and duration, a pop-up panoramic calendar-like view of an entire week’s appointments can make life a whole lot easier. Even better when that calendar is natively sharable by all and enables schedulers to see ahead for an entire month or more. A calendar like this is hard to come by in Sesame. See what the boys at the the Inside Sesame Labs cooked up.

List Files by Date Created/Last Modified
Sesame's @LocalListDirectory and @ServerListDirectory list all the files in the specified folder, sorted alphabetically by filename with no additional information. But what if a filename sort is isn’t what you’re after? Suppose you need the files sorted by the date they were created or last modified so that the most recent files appear at the top of the list and the oldest ones at the bottom. You might even want such a list to show when the files were created or last modified.

Copying Prospects To Customers
It isn’t uncommon for an application to have both a Prospects/Leads database along with a Customers database. You work a prospect over time in that database. Then, when they place their first order it’s time to move them over to Customers. There are a variety of ways to copy a record from one database to another. Our compact program copies both the main form along with the data in a Notes subform to Customers and assigns the next customer number to the new record.

Derived Column Sort Workaround
Q&A reports could be sorted on a Derived (programmed) column. Sesame reports can't. It's too late because in Sesame the sort order (if any) is determined long before any programmed columns’ values are processed in the report. So if the same derived-value sort order is essential to a translated Q&A report — what can you do?

Sesame as a Utility Program
Every so often a veteran IT type will call and bend our ear about what a great little utility program Q&A was. A “Utility program”? In the hands of a go-to guy with a knack for resolving awkward data issues between non-Q&A programs, Q&A was a magic wand. We took on a tough utility job recently. This one would not have been doable in Q&A by any stretch, but it was right in old Sesame’s wheelhouse.

_______________You ask. We answer.

  • Mass Formatting Your Forms — Be cautious when using  Sesame's Advanced Element Selector followed by Perform Selected Action. You could get more than you bargained for.

  • Report Writing Made Easier  — We walk you through designing a fairly sophisticated report. Now that wasn't so bad, was it?

  • Blank Fields and Date Range Searches — Unlike Q&A, Sesame will return records with blank dates if you perform a date search for records before a certain date. What options do you have?

  • Line Numbers in Table View Subforms — Users new to Sesame think those line numbers have some kind of relationship with the data in the corresponding rows. They don't. But you can assign permanent line numbers to the subrecords.  Sample application included in this month's subscriber download file.

  • Importing/Exporting in Client/Server Mode — You just set up an export, supplied the destination filename and let 'er rip. But the file's not there.

  • Auto-Clear the Retrieve Spec — Users can lose track of their criteria when performing back-to-back searches and just frustrate themselves. The nuclear option is to have Sesame  automatically clear the Retrieve Spec after every search.

_______________Technical tidbits you can use today

  • Find All Dates in a Year — Ever need to search a date field for a particular year's worth of records? You can do it with 20-some keystrokes the old school way or get the same result with just a fraction of that. 

  • Programmed XResultSetSearch Criteria — Simple programming expressions can help dig up the records you're after.

  • Use Tooltips to Unhide Text in Tight Fields — An easy way to see the whole entry in a smallish field without having to click in it and arrow over or press F6 to expand 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.