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
2017 issue summary. . .
A Street-Smart Sesame Service Calls
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
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.
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.
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.
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
_______________Technical tidbits you can
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
(Insider password required)
How to Copy Programming Code from
Inside Sesame to paste into Sesame's Program
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
(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.