Getting the Most from Lantica's Sesame Database Manager
|. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . June 23, 2018 2:14 pm. PST|
Inside Sesame Issue Index
Switch to Keyword/Topic Index | Subscriber Express Index
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
As issues of
Inside Sesame are published, their
contents are added to our Keyword/Topic
index and Issue (this) index. The Issue index is organized by year and month
of issue and includes a description of the contents of each issue. The Keyword/Topic
index is organized by keyword, much like the index in the back of a book. A special
Subscriber Express Search Index
also available to Inside Sesame
subscribers. This database can be searched by keyword, topic, article title, author and
various other criteria to locate the issues in which the search criteria occur.
Subscribers can then view those issues immediately.
Ordering Back Issues...
April 2018 issue summary. . . [order code APR18]
What About that
Recent Applications List?
A grumble is sometimes heard from folks new to Sesame over what winds up on their Recent Applications list. Handy when working as expected, this shortcut-like interface feature opens an application with a click. But it isn't quite so handy when there's no way to remove unwanted testing-only and sample apps from it. We take a fresh look at this and offer a sensible solution that doesn't involve turning the feature off altogether.
Make Reports Reveal
Their Retrieve Specs
The Retrieve specs that produced a report don’t show in the report itself. But they can be helpful to know, particularly when those reports might be passed along to others. We show an easy way to print the retrieve specs right in the report's header so there's no doubt as to exactly what the report covers.
Values In a Parent/Child Structure
A new report exposed an underlying problem with a database's data structure. The report was pulling subform data from the wrong parent records. The fault wasn't in the report but in the database ― the report was merely exposing it. An investigation uncovered what had happened and when, and a finely-tuned Mass Update set things to right.
Translating Wonky Date & Money
Fields (or How Not to Lose Data)
Q&A allowed just about anything in Money and Date fields. Users could simply hit Enter to blow off Q&A’s warnings and go on their merry way, leaving corrupted data behind that could be problematic in searches, reports, merges and other output. And even more problematic in a Sesame migration. We suggest how best to deal with something like this at both ends.
Create a Customer Activity
A wholesale products company wanted to give its sales people instant access to a summary of a customer’s buying habits, typical order volume and recently-purchased products. Not a report, but a tightly-organized capsule view, in a popup, available from the customer’s record with the click of a button. Sample Application included in this month's subscriber download file.
Archiving Parts of a Huge Database
A recent Q&A-to-Sesame system migration brought up some size-related concerns ― starting with a new application that would be in the half-a-gigabyte range. This case study details how the app was reorganized to minimize its otherwise massive footprint and make it more efficient, including the ability to archive or restore records with a button click.
_______________You ask. We answer.
How to Check/Change the @Number — Sesame allows just one @Number per application. But where is it? How do you check it? How do you reset it? And why you have to be careful when doing anything involving it.
Internal Password-protected Operations — A company wanted to password protect certain database operations independently of the overall security scheme. Sample application included in this month's download file.
Sesame / Word MailMerge Rules — A detailed recap of the right way to merge print your Sesame data with a Microsoft Word merge document.
Windows 10 Updates Might Delete Scheduled Tasks — If you use a Scheduled Task to start Sesame Server and automatically unlock your application(s) following a server reboot, you'd be wise to incorporate this new info into your methodology.
Turn Off Anti-Virus Programs for Sesame Files — Tips on excluding certain files from A/V scanning to improve Sesame's performance.
Two Different XLookups From Same Element — How to configure a Sesame gizmo to run one of two different lookups depending on whether the lookup key is text or numeric.
_______________Technical tidbits you can use today
Hide All Reports in a Database — Or hide just certain types of reports, such as those for management eyes only.
@LocalFileDialog ― How to Find Multiple File Types in One Go ― A clever way to make Sesame show, say, .doc, .docx and .docm Word files in a get-a-file run. Adaptable to isolating different image file types as well.
Make a Report Total Text 'Money' Values — Money amounts in, say, a combo box, are really text values. So how to get a Sesame report to treat them as money so they can be totaled?
A Simple Report Auto-Sizer — A nifty way to enable farsighted users to make reports display for them in a larger font size.