Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . February 7, 2012  7:14 pm. PST
T H E  M O N T H L Y  H O W - T O  G U I D E  F O R  S E S A M E  U S E R S / D E V E L O P E R S
 
2 0 1 2
Vol. 9, No. 2
(New issues posted by 5th of month)
 


(Insider password required)

Previous Issue Summaries
Title^Summary^Year^Month^Page^Type^FName^LName^Fullname^Keywords

February 2012 issue summary. . .

Checking for Dupes Across Multiple Fields
It's easy to find out if there's another record in the database where the same field has a duplicate value. But what if you need a broader check, such as other records where several fields have the same entries as the record you're working in? We show you how to do it. Sample application included in this month's download file.

Archiving Database Records
Do you have a large database that grows so fast that it needs periodic trimming or archiving? We show you how to archive just one database within a multi-database application, along with any subforms it might contain. This customizable routine simplifies archiving, whether you need to archive weekly, monthly or annually.


_______________You ask. We answer.

  •  

  • Update Records From Startup Menu — Need to periodically update a group of records without having to go into the database? Here's our solution.

  • Control Unwanted Pop-Ups on Tabs — Under certain conditions, a pop-up can keep popping up when not wanted and for apparently no reason. We explain the problem and offer a few workarounds.

  • Flip Table View Subform to Form View — Got a Table View subform that you occasionally need to switch into Form View. Here's one way to do it.

  • Remote Access and Port Forwarding — What you need to know in order to access your Sesame applications across the Internet.


_______________Technical tidbits you can use today
 

  • One Click — Multiple Reports — Run two, three or more reports back-to-back with one click of a button, and have them appear on separate tabs in your browser.

  • Slow Down, Buddy! — Computers are fast. Sometimes too fast. Here's how to make your Sesame program pause a bit to let other impacted programs catch up.

  • Keep Child Records Bolted to Their Parents — If you include the unique parent key value in your naturally-linked subforms, that advantage breaks down if the parent key value somehow gets changed. Here’s a little program that automatically keeps your subform keys in sync with your parent keys.

 


(Insider password required)
How to Copy Programming Code from
Inside Sesame to paste into Sesame's Program Editor

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 clipboard. (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 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.

Sesame doesn't like slanted (styled) quotes: “SomeValue″
Sesame likes plain straight quote marks: "SomeValue"

To convert any styled quotes to plain quotes in the Program Editor:

  1. Copy one styled opening quote to the clipboard.
  2. Open the Program Editor’s Search | Replace box.
  3. Paste (Ctrl-V) the styled opening quote into the Find field.
  4. Type a plain quote (") in the Replace field.
  5. Click Replace All.

Follow the same steps to replace any styled closing quotes with plain quotes.

Retest the program.