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?
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
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
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.
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
Can't happen. . . Unless. . . Be mindful of where you're getting
the data you paste into your fields.
Design Forms for Data Entry and
— 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
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
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.