Linking Emails to
A company was looking to resolve some email-related issues and wanted
to know if their database system could be leveraged in some way to help
“Is there any way we could access our sales engineers’ past
email exchanges directly from our PLANTS (customers) records?”
Indeed they could. With Plant XYZ’s record displayed, email
exchanges with personnel there can be brought up for viewing with a
button click or keyword search.
Control Data Entry with Form Attributes
Need to tighten things up during data entry ― make users follow a
prescribed pattern before a record is allowed into the database? This
goes beyond mere restrictions. It's like having an intelligent
assistant guiding the process. Sample application included in this month's
subscriber download file.
For databases that store photos of people, aging can be a
factor in photo management. So a company might want to round up the
folks whose photos are out of date and take new ones. But how to tell
how old a photo on file is unless you’re looking at the person and
their photo at the same time? Easy ― have Sesame ask the operating system.
How to Keep Related String Arrays
Sesame string arrays make handy organizers. They can assist with a
variety of processing tasks by keeping track of multiple data values
that can be manipulated in programming. Unlike formal arrays, though,
string arrays are strictly one-dimensional. Or are they? String
arrays can be grouped or “stacked” to make what amounts to a
multidimensional array. This kind of power adds a new dimension to
what you can do in Sesame.
Auto-Updating Outdated Product
A company had improved on many of its product descriptions over
the years. Now in Sesame, the law of unintended consequences caught
up. To accommodate new features, all their old lineitem descriptions
had to be brought up to date with the latest ones, and any future
description changes would need to automatically update the previous
Create a Mini Data Dictionary
A school district was being forced to standardize its databases on
a product other than Sesame. Ironically, Sesame had the tools
to make the conversion far less difficult than it otherwise would have
Find a Date Range in a String
of Dates — It can be done. Here's how.
Popup Multiple Fields from
External DB — When adding a new invoice, a company needed a
window on the customer's record.
Must-fill Fields in Add Mode
Only — When standard field restrictions won't do.
Retrieve Not Working in Keyword
Fields — It worked OK in Q&A. Why not in Sesame?
Checking Checkboxes — From
elsewhere, how do you know if they're checked?.
Archive Database Translation —
Sensible archiving options for multiple translated databases with
the same structure, reports and so on.
_______________Technical tidbits you can
Class-ify Those Reports — A
quick-'n'-easy drop-in makes reports easier to follow.
Using @Frac for Varying Quantity Formats ― You've got
Quantity field that must be formatted for 2 decimal places
but you don't want a .00 to print.
When While-While Loops Beat
For-While Loops — Your loop programming could be running
far longer than it should.
Reports, Excel and Carriage Returns
in the Data — You open a report in Excel and see more rows than
the report actually has. What's up with that?.