2017 issue summary. . . [order code APR 17]
Check it. Grab it. Import it ― A
Comprehensive Sesame FTP Download Program
Most commercial websites today have fill-in forms of one kind or
another, from simple contact forms to elaborate order forms. Company
sites might also have private/restricted forms for their outside sales
or service people to fill in and submit from their mobile devices. But
how do you funnel that remote data down to your Sesame database with no
more than a mouse click? We point the way.
Include/Exclude Options When Copying Table Subform Content
A company had Proposals and Orders databases. When a
proposal was accepted by the customer, it was turned into a new order
by copying it to Orders. Problem was, some of the lineitems in
the table subform needed to be excluded. So they needed a fast and
intuitive way to pick which items not to copy.
Cook Up a Custom
A company was looking to restrict access to certain sensitive reports,
procedures and form elements without having to add overall security to
the application. They wanted a password field at the bottom of the
form. Only a select few people would know the password. When supplied,
command buttons and other form elements would appear, enabling an
admin person to perform the special tasks. The password masking you
normally see with password boxes didn’t come up, but we wondered how
that might be done. Sample application included in this month's
Require Password for Record
There are a variety of ways to prevent records from being deleted
from a database. This one hides the delete options on the commands
panel, disables the F3 Delete key, and prompts for a special
admin password before zapping the record. But it does something more.
It quietly copies the contents of the record to an external text file
on the server an instant before the delete so that the data can be
restored. The file tells you precisely when the record was
deleted, who deleted it, and from what workstation.
Son of WordMerge
The 300-line WordMerge add-in that comes with Sesame might seem like
overkill when all you need to merge are a few fields — perhaps along
with some subform data — to a specific document. Using just a fraction
of the WordMerge code, our savvy little substitute creates a merge
data source file (just like WordMerge with header and data rows) then
opens the doc with the data neatly merged in.
When FileWriteLn Beats
FileOverWrite ― The Strange Case of PDF995
You might think that either method for outputting text files winds up
with the same result. But if you're using PDF995 on a 64-bit
machine to generate PDF docs, you might be wrong. In Windows' security
model, creating a new file with FileOverWrite is a whole
lot different than modifying an existing file with FileWriteLn.
Reports vs. Database Design
— Why you should always design a database with the kinds of reports
you'll need in mind.
Update Multiple Records with a
Click — Reducing a complex update procedure to a simple
Truly Secure Your Data —
Steps you can take to keep prying eyes away from where they ought
not to be.
Make Updating Sesame Easier
— How to apply a Sesame upgrade to all the PC's in your
company in one fell swoop.
Set Sesame Screen Sizes — A
tutorial on getting just the right size Sesame window
particularly on laptops.
Convert Non-Y2K Dates with an
Export/Import — Back to the future.
_______________Technical tidbits you can
Images in Table View — All it
takes is a sesame.ini file setting.
Checkboxes — Only One State Matters ― A checkbox is either
on or off, right? Sesame checkboxes have three
states, but only one matters.
Hide Form Elements Geographically
— @ContainedElementList ― what's that? It's an
convenient and efficient way to work with a group of form
Find the Latest Date in a Table
Subform — This might not be as easy as you suppose.
Make Report Breaks Easier to See
— Subtotals In a lengthy report can be hard to spot. This
enhancement makes them really stand out.
Son of WordMerge 2 — (See Son
of WordMerge above) This version merges multiple database
records, is runnable from anywhere in the application, and
can be adapted to include subrecord data.