Getting the Most from Lantica's Sesame Database Manager
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . March 26, 2017  11:52 am. PST

Inside Sesame's All-New
Order FileFinder2

FileFinder2's sticky options let each user customize it for the way they work

About FileFinder2

FileFinder2 is an intelligent file system navigator and file finder you can customize for the way you work, your file system, and the kinds of files you normally need to access. You need Sesame 2.0 or later to use FileFinder2.

FileFinder2 is designed as a pop-up mini-form utility that you can pop-up from any Sesame form to quickly locate, select and optionally preview files in your file system. FileFinder optionally copies the selected file name (and it's full path) into the field of your choice. You can also use FileFinder as a standalone application that you run, for example, from a desktop shortcut.

To use FileFinder2 as a pop-up mini-form utility, simply merge it into your existing application. Then, in each form you want to use it with, add a FileFinder command button and program it On Element Entry this way:

var vFile as String

vFile = @SearchStringArray(@FormAsDialog("FileFinder2"), "Selected File..")

vFile = @AccessStringArray(vFile, 2)


Replace WriteLn(vFile) with the name of the field in the underlying form where you want to store the  selected file's path. The following will place the selected file path in a field named Resume File:

Resume = vFile

FileFinder2 Setup Options

Set Drives (optional — required to find files by drive letter)
Supply the drive letters of the drives you may want to access from FileFinder2one drive letter per line, like this:


Your FileFinder picklist will then display a [Drives] selection you can click on to access all the files that match any of the specified file types (see next option) on any of the listed drives.

Set File Types (required)
Supply the file extensions for the kinds of files you'll want to find in your file system. You can specify up to 16 file extensions. Type one file extension per line, as follows:


For previewing files (see that option below), your computer must associate the file type with a particular program. For example, a doc should open in Microsoft Word;  a pdf file in Acrobat.

Set Default File Types (optional)
Supply those file extensions on the Set File Types list that you want to be checked by default for finding that type of file. You can always uncheck them for any search. Enter your default file extensions, one per line, this way:


Set Default File Location (optional)
Answer YES if you want FileFinder2 to find files on your local PC by default. Answer NO if you want it to find files on the server by default. You can set either one manually for any file search.

Set Local Folder Associations (optional)
You can associate a plain language description with a specific file path on your computer. For example, a description such as Personal Documents can be associated with a file path like C:/Documents and Settings/rjanderson. You can then click on »Personal Documents and FileFinder2 will list all the files in that folder along with any subfolders. Type the description, followed by a semicolon (;) then the file path, this way:

Personal Documents;C:\Documents and Settings\rjanderson

You can add as many of these plain language file path shortcuts as you like, one per line. Add them in the order you want them to appear on the list. FileFinder will display them preceded by a » character.

Set Server Folder Associations (optional)
The same as Set Local Folder Associations, except for finding files on your network server (if you have one). Example:


Type the description followed by a semicolon (;) then the server filepath. You can add as many of these plain language file path shortcuts as you like, one per line.

Set Starting Local Folder (required for access to local files)
This is your "home" folder on your workstation— the path to the folder where you want FileFinder2 to start when you click the Find File button with My PC checked. Example:


Set Starting Server Folder (required for access to server files)
This is your "home" folder on the network server (if any) — the path to the folder where you want FileFinder2 to start when you click the Find File button with Server checked . Example:


Set Preview Selected File (optional)
Answer YES if you want FileFinder2 to display the selected file. Otherwise answer NO.

Close FileFinder on File Selection (optional)
If set to YES, this option closes FileFinder2 when you select a file. If you launched FileFinder as a pop-up from another form, only the pop-up  closes. If you are running FileFinder as a standalone Sesame application (such as from a desktop shortcut), Sesame will close.

Create New Folder
This option lets you create a new folder on your computer on-the-fly.

Price: $89.00 / $29.00 each additional user
Contact us if you need technical assistance with FileFinder2
or would like a custom version of FileFinder2 for your company.
Marble Publications, Inc., 800-780-5474 / 949-722-9127, email