MobileDB v4.0
for the Palm Computing(R) Platform

Handmark Inc.
www.handmark.com
  

MobileDB™ and MobileDB Lite™
Copyright © 2003 Handmark
All Rights Reserved

Tip #1 - Visit our MobileDB database archive to choose from hundreds of pre-made MobileDB databases!

Tip #2 - If you like MobileDB, beam it to your Palm-using friend! Then use MobileDB to beam your favorite MobileDB databases!
 

Hot Topics
    MobileDB Overview
    MobileDB System Requirements
    How to install MobileDB and and MobileDB databases
    Differences between MobileDB and MobileDB Lite
    MobileDB Database Tools and Converters
    Where to Find Existing MobileDB Databases
 
MobileDB Instructions
1.  MobileDB Overview
        Features
        Limitations
        Known Bugs

2.  Screen Instructions
        Start Up
        Database List View
        Record List View
        Record Details View / Edit
        
MobileDB Preferences
        Database Preferences
        Sort Records
        Filter Records
        Find Records
        Print Records
        Export Records to the Date Book
        Export Records to the Address Book

        Modify Column Widths

        Modify Field Definitions

3. How do I...
        Store and use a database on a memory card?
        Assign colors to the database header and rows?
        Beam a database?
        Lock a database?
        Create a database on my Palm OS Device?
        Create a database on the PC or convert an Excel spreadsheet to a database?

4.  Version Information

5.  Purchase MobileDB

6.  License

7.  Company Information
 
 


MobileDB Overview

MobileDB for the Palm Computing Platform is the award-winning database application that allows users to view and edit any table or spreadsheet-like information on their Palm OS device. MobileDB was designed for the Palm user that needs simple and efficient access to any size table or spreadsheet information. With the release of MobileDB v4.0, Handmark has added support for storing databases on Memory Stick and SD/MMC memory expansion cards, user-defined color for database headers and rows, and the ability to check and uncheck checkboxes from the database list view (when the Edit View preference is active). An intuitive list of field types including text, number, list, checkbox, time, date and sequence as well as flexible filters and sorting functionality help you keep your data organized and accessible. You can even export your MobileDB database to the date book!

Using one of the many MobileDB tools such as MobileDB-PC, MobileDB-Excel or MobileDB-FileMaker, users can easily create MobileDB databases from comma separated file or nearly any other data source.  

Please visit http://www.handmark.com/products/mobiledb for a complete list of MobileDB tools for the Mac and PC.

Features

  • View, Edit, Delete, and Categorize unlimited MobileDB databases on any Palm OS device.
  • Store databases (read only) on expansion cards to maximize internal memory.
  • Select header and row color for easy at-a-glance viewing.
  • 7 Intuitive field types including Text, Number, List, Checkbox, Date, Time, and Sequence.
  • Beam full databases or just the filtered records to MobileDB & MobileDB Lite users.
  • Export records to the Date Book.
  • Flexible 3-way filter and sort functionality.
  • Intuitive date and time popup selection screens.
  • Lock a database to hide it from view of others using your Palm OS device.
  • Supports databases up to 20 fields and 1000 characters per field.
  • Categorize databases in 15 user-defined categories.
  • Optionally include databases to be searched in the Palm "global find" command.
  • Single-handed navigation through the entire database using the Palm OS device hard keys.
  • Many MobileDB tools, including MobileDB-PC, MobileDB-Excel, and MobileDB-FileMaker.
  • Huge support for MobileDB databases - hundreds available for download now!

Limitations

  • Maximum of 1000 characters for each data field.
  • Maximum of 20 fields per database.
  • Some database features may not be accessible when a database is stored on the memory card (more info)
  • There is no known limitation to the number of records per database. However, databases over 5000 records will be a slower with searching, sorting, scrolling, etc...

Known Bugs

No Known bugs in MobileDB at this time.


MobileDB System Requirements

MobileDB is compatible with any Palm Computing® Platform device utilizing Palm OS 3.0 or newer. For a complete list of supported devices, see the MobileDB product page on the Handmark web site.  Palm OS 1.0 and Palm OS 2.0 are no longer supported by MobileDB or MobileDB Lite.

 

How to Install MobileDB databases

Use the Palm Computing Installation tool to install the mobiledb .prc file.  Likewise, use your Palm Computing Installation tool to install any MobileDB databases (databasename.pdb).  For more information on using the Palm Computing Installation tool, consult your Palm device instructions.


Differences between MobileDB and MobileDB Lite

Although MobileDB and MobileDB Lite utilize the same databases they have different levels of functionality. See the chart below for the functionality differences.

MobileDB Lite
MobileDB
View Databases
Yes
Yes
Edit Databases
No
Yes
Create Databases
No
Yes
Clone Databases
No
Yes
Rename Databases
No
Yes
Categorize Databases
No
Yes
Supports Database Printing with PrintBoy
No
Yes
Export to Date Book
No
Yes
Export to Address Book
No
Yes
Beam Database
Yes
Yes
Sort, Filter and Find Records
Yes
Yes
Modfiy Column Widths
Yes
Yes
Modify Field Definitions
No
Yes
Modify Header and Row Color
No
Yes
Access Databases on Memory Stick or SD/MMC Expansion Card
No
Yes
# of Simultaneously Installed Databases
10
Unlimited

Compatible with all MobileDB desktop tools

Yes
Yes

MobileDB Lite users must utilize a MobileDB converter to create MobileDB databases or download existing MobileDB databases from the Internet.  There is no difference between MobileDB Lite and MobileDB databases.
 

MobileDB Tools and Converters

There are many MobileDB tools and converters available for both PC and Macintosh. The most popular and most useful converters, are Handmark's own MobileDB-PC, MobileDB-Excel, and MobileDB-FileMaker. These tools allow you to create MobileDB databases on your PC or Mac then install them on your Palm OS device. Most of these tools also allow you to open the backup MobileDB databases from your Palm OS device (in your c:\palm\<username>\backup directory) to edit or export as a comma separated file.

You can find a list of all MobileDB tools at and detailed descriptions at http://www.handmark.com/products/mobiledb.html


Where to Find Existing MobileDB Databases

There are a growing number of pre-developed, generic-content MobileDB databases available for your use.  Check out the Handmark database archive to find those of interest to you.  The MobileDB database archive is available at  http://www.mobiledb.com.

Remember - if you have created a database that other MobileDB users may be interested in, please send it to us so we can make it available for other users. The database submission instructions are available at http://www.mobiledb.com.

 

Usage

Start up

To begin using Handmark MobileDB, simply tap the appropriate icon on your application screen. Enter your product serial number on the serial number screen and you're ready to use MobileDB. Until you purchase a product serial number, you can only use the application for 15 days.

When first installed, the MobileDB application will launch into the database list view.  If you previously exited the application while in a database, the same database will be opened automatically on the next start up.  This allows you to access the same database repeatedly without having to reselect the database.

Database List View

The database list view allows you to select an action to perform, a database on which to perform the action, create a new database, or view the status (locked, location, database size, and so on) of each database. Select the category at the top right of the screen to view the databases in that category.

To open a database for viewing or editing, tap Open, then tap the database name in the database list.  The database appears and you will see the 'Record List' view with the database name at the top of the window.

To categorize a database, tap Info, then tap the database you want to categorize. Tap the Category box and select an existing category or create a new category. When databases are stored on a memory card, they will only be visible in the "All" and "Undefined" categories

To beam a database, tap Beam, then tap the database name that you want to beam. The application searches for another PalmOS device, then beams the database and the other unit, asking the recipient if they would like to "Accept" the database. Once the database has been beamed, the action selection will returns to the default, "Open." Keep in mind, that the "receiving" device must have MobileDB or MobileDB Lite already installed in order to access the MobileDB database. If necessary, you can beam the other user MobileDB or MobileDB Lite through the "Beam" menu option available on the Palm OS applications menu.

To delete a database, tap Delete, then tap the database you want to remove. If you have the MobileDB Application Preference, "Confirm Database Delete" checked then a confirmation dialog box appears. If you do not have the "Confirm Database Delete" checked then the database is automatically deleted with no confirmation. We suggest that you keep the "Confirm Database Delete" checked unless you need to quickly delete a lot of databases.

To create a new database, tap the 'New' button from the database list view, enter the desired database name, and tap 'OK'.  The 'Field Definitions' view will pop up to enter the field names and data types for the database.  Enter each name as you would like them to appear in the database (minus the colon) and leave the rest of the field names blank.  Select the data type for each field. Note - selecting the proper data type for your data will ensure maximum flexibility and consistency when using the filter and sort functions.

To view the database sizes, on the Display DB Size drop-down list at the top of the database list view tap By # Records to display the number of records in each database or By Kbytes to display the space (in kilobytes) that each database takes up on your Palm OS device. Due to the overhead required to determine the sizes each time the database list view refreshes, we suggest that you keep the selection at Don't Display until you need to display the size of the databases.

To view the lock status of all databases make sure the MobileDB Application Preference, "Show Lock Icons" is checked. This displays a lock icon for each database in the database list view. If the database is locked (requires a password to access) then the lock icon is "closed" or "locked." Otherwise, the lock icon is "open". Keep in mind, that a locked database only hides the data from view on the Palm OS device. The database is not encrypted and the data can be accessed with any MobileDB tool, converter, or even a generic ASCII text viewer (like Memo Pad). You should not store any highly sensitive information in a locked MobileDB database. For more information see Locking MobileDB Databases.

To view the location (handheld or card) status of all databases, make sure the MobileDB Application Preference, "Show Location Icons" is checked. This displays a location icon to the left of each database name in the database list view. Databases on the handheld display a rectangular representation of a handheld device. Databases on the card display a representation of a memory card with an angled bottom edge. Show Lock Icons has precedence over Show Location Icons in the database list view. If Show Lock Icons is selected, Location Icons will not be displayed.

You can also select the MobileDB Application Preferences by tapping the menu button and selecting 'Preferences.'  For more information on the application preferences, see MobileDB Application Preferences.

To change the MobileDB header and row color, select Colors from the Options menu. Tap the Pick button next to Header or Row and then select the desired color from the color picker by tapping on the appropriate square. ClickOK to exit the Pick Colors dialog and OK in the Color preferences to apply the changes. Header and row colors are global and are not database specific. The row color you pick will alternate with white in the MobileDB database list and record list views. Since text in MobileDB is black and cannot be changed, dark colors, such as dark blue or black, may make it difficult or impossible to read the data in the colored rows. We suggest using lighter colors for best readability.

Storing and Using Databases on a Memory Card

With the release of MobileDB4, it is now possible to store and view your MobileDB databases on Memory Stick or SD/MMC memory cards on devices that support VFS (Virtual File System). If your device supports storing MobileDB data on expansion cards, the database location will be displayed in the database list view if Show Location Icons is selected in the Preferences. If your device does not support VFS, this preference will not be available and the icons will not be displayed.

To move a database from internal memory to the memory card, tap the location icon to the left of the database that you wish to move (databases on the handheld display a handheld icon and databases on the card display a card icon). The Move Database dialogue will appear - "[Database] is currently located on the device. Would you like to move it to the card?" To move the database to the card, tap "Yes" you will see a dialogue noting, "Moving [database] to the card" and the location icon will change from the Handheld icon to the Card icon.

To move a database from the memory card to internal memory, tap the location icon to the left of the database that you wish to move. The Move Database dialogue will appear - "[Database] is currently located on the card. Would you like to move it to the device?" To move the database to the handheld, tap "Yes" you will see a dialogue noting, "Moving [database] to the device" and the location icon will change from the Card icon to the Handheld icon.

MobileDB databases and records that are stored on the memory card can be accessed and viewed in the same manner as databases that are stored on the handheld, but they are available in read-only format. If you try to make a change to a database that is stored on the card, you will receive a dialog notifying you, "The selected operation requires the database be moved from the expansion card to the device. Do you wish to continue?" Tap "OK" and the database will be automatically moved to the handheld and you can edit the database as normal. By checking the "Move database back to the expansion card when complete" box, the database will automatically be moved back to the card once you tap "done" to return to the database list view.

IMPORTANT NOTE: Due to current format limitations, database categories are NOT retained when the database is moved from the Palm OS device to the card. If you have assigned category information to your database, it will be permanently lost when the database is moved to the card.

NOTE: Databases stored on the memory card cannot be searched using the Global Find.

Record List View

Scrolling Up or Down Records - The record list view allows you to display up to 10 records in the database at any one time.  Use the scroll bar to navigate up and down the records in the database. Note: the record number indicator at the bottom of the screen (example: 735 of 890) displays the record number at the top of the screen. Since the application will not scroll past the last record location at the bottom of the screen, you will never see "890 of 890". You can scroll up or down a single record by tapping the up and down arrows at the top or bottom of the scroll bar. To page up or down either tap the scroll bar above or below the indicator or use the hard up or down keys on your Palm OS device.

Scrolling Left or Right - If there are more than two fields in each record of your database then you can use the left or right arrows at the bottom-right of the screen to scroll through the "fields" or "columns" of the database. The first field of the record remains static and will not move while the other fields scroll left and right. It is extremely important to create an optimal field width setting in order to keep the field widths small enough so the left and right scroll works correctly. See Modifying Field Width for more information.

Also, keep in mind that if the Use Hard Keys for Scrolling preference is set in the MobileDB application preferences, you can use the Address Book and To Do hard keys on your Palm OS device to scroll the fields left and right in the second column.  This allows for single handed navigation of the entire database.

Selecting a Record - To select a record, simply tap the record and the record is highlighted, then navigate to the screen displaying the details of the record. MobileDB displays the record details in read-only format.

Creating a New Record - To create a new record, press the "New" button at the bottom left of the screen. This will display the editable view of the details and allow a user to add the details of the new record. The new record will be sorted properly in the new database.

Modifying the Column Widths - To modify the widths of each column, drag the column width bar (line between each column name) to the new location.

Exit - To return to the database list view, tap Done.

Menu Functions

Database
- Delete... - Delete the currently selected database (more info)
- Rename... - Rename the currently selected database
- Beam... - Beam the currently selected database to another Palm (more info)
- Clone... - Copy the entire contents of this database and paste it in a newly-create database
- Print... - Wirelessly print your database data using Bachmann Software's Printboy PRO
- Export to Date Book... - Export the records to the date book (more info)

- Export to Address... - Export the records to the address book (more info)

- Field Definitions - Modify the label names, position, data types, etc.. (more info)
- Password... - Modify the password of your database (more info)
- Info... - Modify the database information and preferences (more info)

Record
- Sort... - Sort the records based on a specified criteria (more info)
- Filter... - Filter the records to only see ones that match a specified criteria (more info)
- Show All - Remove the filter from the database, thus displaying all the records
- Find... - Find a specific record that meets a specified criteria (more info)
- Repeat Find - Use the predefined "find" criteria and find the next record that matched that criteria
- Go to Top
- Move to the top record of the database in the record view
- Go to Bottom - Move to the last record of the database in the record view

Options
- MobileDB Preferences - Modify the MobileDB application preferences (more info)

- MobileDB Colors - Select the global MobileDB Header and Row color (more info)
- About MobileDB - Find out more about MobileDB and Handmark


Record Details View / Edit

When selecting a record, there are two views that may be displayed, View Record or Edit Record. The default view displayed is determined by the 'On select, go to Edit View' preference in the Database Info. If the user needs frequent view access and occasional edit access then we suggest that this preference be unchecked so the record view is the default view.

HINT - Minimize the length of your field names in order to maximize the space available for the record details on these screens. For instance change the field name "Description" to "Desc" to free up that much more screen space for your record details!

Record View - The record view screen allows the user to view the detailed information of the record selected from the record list.  If the record details do not fit on a single screen then the user can use the up/down arrows at the bottom of the screen or the hard up/down buttons on the palm to navigate up or down the record details. Once the end of the record is reached, the use of those same buttons will "jump" to the top of the next record (up or down) in the record list.

In order to edit the record, simply tap somewhere on the record details or tap the "Edit" button. This will show the same information in an editable format.
To return to the record list press the "Done" button.

Record Edit - The record edit view enable users to edit the detailed information of each record.  If the record details do not fit on a single screen then the user can use the up/down arrows at the bottom of the screen or the hard up/down buttons on the palm to navigate up or down the record details. Once the end of the record is reached, the use of those same buttons will "jump" to the top of the next record (up or down) in the record list.

Editing the field information is dependent on the data type selected. For text and number field types simply place the cursor in the field then edit with graffiti input, keyboard input, or the standard cut, copy, paste, and undo. For a date or time field types tap the field box and a date or time selection screen will appear. For a checkbox just tap the checkbox to select or unselect it. Tap the down arrow on a list type and select the list item. When done editing either press the "Done" button or use the up/down arrows or buttons to move to another record. Your data will be saved automatically if you move to another record.

To delete the record, tap the 'Delete' button and the record will be deleted and the application will return to the record list view.  If you have the 'Confirm Record Delete' set in the application preferences you will also be warned that the record will be deleted once the 'Delete' button has been tapped.

If you chose to cancel the changes that were made to the record since you entered the 'Edit Record' screen, tap the 'Cancel' button and the application will return to the 'Record List' with no changes saved. This will only cancel the changes made to the current record you are editing. Any changes made to other records will not be canceled.

Menu Commands

Record
 - Print... - print current record using Printboy PRO
 - Export... - export data to the Datebook (more info)
 - Delete - delete the currently selected record
 - Duplicate - creates a duplicate of the currently selected record in the database

Edit
 - Undo - undo the last cut/copy/paste command
 - Cut - cut the selected data from the field and place it in the cli
pboard
 - Copy - copy the selected data to the clipboard from the selected field
 - Paste - paste the data from the clipboard to the selected field

 - Select All - select all the data in the selected field
 - Keyboard - pop up the keyboard

Options
 - Select Font
- select the font to display in the view/edit screens

 

MobileDB Application Preferences

You can easily access application preferences from either the database list view or the record list view. Simply tap MobileDB Preferences on the Options menu in either the database list view or the record list view.  These preferences are for the entire application and are not dependent on the database selected.

Use Hard Keys For Scrolling - if checked, the Address Book and To Do hard keys on your Palm OS device will act as left and right scroll navigation buttons in the database list view.  This allows for single-handed navigation of the entire database. The up and down buttons always work in the record list and record view and edit screens, regardless of this setting.

Confirm Record Delete - if checked, this will cause the application to pop up the 'Are You Sure' dialog after the user requests to delete a record.  This may be unchecked if the user needs to quickly delete a lot of records in the database, however, we strongly suggest that the user keep this option checked during normal operation.

Confirm Database Delete - if checked, you will be prompted to confirm a database removal before it is permanently deleted.  This can be unchecked if you need to quickly delete several databases, however, we strongly suggest you keep this option checked during normal operation.

Left Hand Mode - If checked, the scroll bar will be moved to the left side of the screen.

Show Lock Icons - If checked, lock icons are displayed on the database list indicating whether or not each database is locked. If you do not use database locking, then we suggest that this remain unchecked for a "clean" database list interface.

Show Location Icons - If checked, the current location of the database, handheld, or card, is displayed to the left of the database name. NOTE - Show Lock Icons has precedence over Show Location Icons in the database list view. If Show Lock Icons is selected, Location Icons will not be displayed. (more info)


Database Info

You can easily access and change the database preferences in the record list view. Simply tap Info... on the Database menu. Note that these preferences only effect the currently selected database, so you will need to set individual preferences for each database.  

Title - allows you to modify the database title.

Records - displays the number of records in the selected database.

Size - displays the size of the selected database.

Updated - displays the date and time of most recent changes to the selected database.

PW Protection - None indicates database is not password protected. Read only indicates password is required to modify the database. Lock indicates database will request password on selection.

On Select, go to Edit View If this is checked, the application will go to the record edit view to edit the record when a record is selected in the record list view.  If this is unchecked then the application will go to the record view screen when a record is selected. We recommend that this remain unchecked for databases where the user requires quick view access and occasional edits/updates to the data.

Backup Database at Hotsync - if this is checked then a backup is automatically created during the Hot Sync application, placing it in the backup directory of your Palm user directory on your PC or Mac. On the PC, it is generally the c:\palm\<username>\backup directory. You can then use this backup to convert to a comma separated file for further editing on the PC or Mac.

NOTE: Unless there is some reason why you do not want the database backed up to your machine, this should always be selected. It does not create a new backup each time you use the Hot Sync application, only if changes have been made to the database since the last backup was created.

Search on Global Find - If this is checked then the database is searched when the you perform a Palm OS "Find". Large databases may slow the Palm OS find feature, so we suggest that this only be checked on databases that you would like to search when performing a PalmOS find. Databases on expansion cards cannot be searched using Global Find.

Display Dates in Long Format - If this is checked then the dates in utilizing the date field types will be displayed as MMM DD, YYYY instead of the default view MM/DD/YY


Sorting Records
You can sort records in the record list view. Simply tap Sort Records on the Record menu and the Sort Records screen appears.    Select the primary, secondary, and tertiary sort criteria by selecting the field to sort.  Select the Ascending or Descending selection buttons if you would like that field to be sorted in ascending or descending order. Once the sort criteria has been set, tap OK to begin the sort..  This may take a few seconds depending on the number of records and complexity of the sort.  Tap Cancel to cancel the sort. The sort is based on the field types selected. Therefore, if you want to sort chronologically then the field you are sorting on must be a date field type.


Filter Records
Filtering the records allows you to view only the records that contain specific text.  To filter records, tap Filter Records on the Record menu in the record list view.  The filter options are based on the field data type you have selected. For text fields you can choose to filter text equal to (is) or continaing (contains) the text you enter. For number field types you can filter a record that 'is', 'is not', 'is greater than', or 'is less than' the number entered. Checkbox is filtered as 'is' or 'is not' checked or unchecked and a list is filtered as 'is' or 'is not' one of the list items. The date and time fields are filtered based on 'is', 'is not', 'is before' or 'is after' the selected date or time.

You can also choose to combine multiple filters as an 'and' requiring a match on all the filters or 'or' which just requires a match on one filter. If you already a filter on the current database then you'll have the option to apply the filter over the current filter (filtered rec's) or all the records in the database.

Once you have entered your filter criteria, tap OK to start the filter, and Cancel to cancel the filter.

When the filter has been completed in the record list view, a small reverse 'F' appears at the top-right of the record list view.  To remove the the filter, simply tap the 'F' and the filter is removed, displaying all records.  You can also tap Show all Records on the Record menu to remove the filter off and display all records.

Find Records
To find a record that contains a specific string of text, use the Find Record feature.  Tap Find Record on the Record menu.  The record list view appears, then you can enter the find text and select the field on which to search for the text.  Press OK and the Record List appears with the record highlighted with the the text.  To repeat the find, tap the small reverse 'R' at the top-right of the screen.  The application will continue to search for the text until it reaches the end of the database and it will prompt you to start from the beginning of the database.

Print Records
To print MobileDB database records you will need PrintBoy PRO available at www.bachmannsoftware.com. To print, simply select Print Database from the menu and select the print criteria. You can also filter the records first then just print the filtered records.


Export Records to the Date Book
For databases that contain a date field you can export all the records or just the filtered records to the date book. To export the records, select Export to Date Book from the Database menu. Select the date and time (optional) fields you would like to use for the export date and time. Then select the fields to export to the date book by tapping each field to export. The fields in Bold will be exported to the date book. If you have a filter on the records then you can select "Export filtered records" to export just the filtered records. Tap OK and the records will be exported to the date book.


Export Records to the Address Book
The Export to Address... menu item can be used to export records to the Address Book application. When used in the Record List, it will attempt to export all the records currently available in the Record List. It will not export records which are not in the current filter. When used when viewing a specific record, only that record will be exported. Please note that regardless of where the utility is run from, any records that result in an empty address record will not be exported. The export screen is set up to model the address bookÕs own address edit screen. The most noticeable difference is that instead of text fields there are popup lists containing the fields of the current MobileDB database. The popup lists allows the user to map the MobileDB database fields to the Address Book fields. There is no category support on the main export screen, but the user can select the category the records are to be exported to in the Details dialog accessible by tapping the "Details" button at the bottom of the Address Export window.. Please note that the categories listed are the categories for the Address Book application and not MobileDB. Any changes made to the categories list will effect the Address application. The Details dialog omits the note field, however it can be mapped on the main export screen just like the other fields. There is no support for other special features such as the Sony picture feature.


Modify Column Widths
To modify the widths of each column, drag the column width bar (line between each column name) to the new location.


Modify Field Definitions
Select the 'Modify Field Definitions' in the 'Database' menu from the Record List view to modify the field lables, data types, add a field, remove a field, or move a field, or in the database.

MobileDB has 7 data type choices. Selecting the proper data type for your data will ensure maximum flexibility and consistency with the filter and sort functionions. The choices are text, number, list, checkbox, date, time, sequence. To change the data type of a field select a the data type from the list to the right of the entry field. Depending on the data type, an option popup dialog may appear.

To change the field name of the field, simply edit the field name. HINT - Minimize the length of your field names (labels) in order to maximize the space available on the record view/edit screens. For instance change the field name "Description" to "Desc" to free up that much more screen space for your record details!

To move a field in the database, select the field and use the menu command "Fields->Move Field Up" "Fields->Mobile Field Down". To Insert a field, select the field that you would like to come after the new field and select "Fields->Insert Field". To add a field to the end of the field list, select the menu command "Fields->Add Field". To delete a field, select the field and select the menu command "Delete Field" from the "Fields" menu. Once any changes are made, it may take a moment to make the changes in every record in the database.


MobileDB Database Locking
To lock a MobileDB database, select the database and then tap Change Password on the Database menu. Leave the "Old Password" field blank (since there is no password set) and enter your password in the "New Password" and "Retype New" fields. The next time a that database is selected, you will be prompted to enter a password before viewing or editing the database.

NOTE: This "lock" simply hides the database from view in the MobileDB application. If someone is interested enough in this information, they can simply hotsync your palm and view the database on the PC using an ASCII viewer or any MobileDB converter. DO NOT PLACE ANY SENSITIVE INFORMATION IN THIS APPLICATION WITH THE ASSUMPTION THAT "LOCKING" IT WILL SECURE THE INFORMATION. You should use an encrypted database application (like PDA SAFE ID) in order to secure sensitive information.


Database Information
The database information screen is intented to display information about the database as well as allow users to set the database category. Enter the information about the database if you plan on sharing it with other users. If you want to keep users from editing the database information then press the ""Lock Text" button, enter the password, and press ok. Users will be able to view the database information but they will be required to enter that password before they can edit the database info text.

To change the category of the database, simply tap the category box and select a category. Remember that categories are NOT retained for databases moved to the memory card.


Version Information

Version 4.0
- Store and view databases on memory stick and SD/MMC memory cards
- Select header and row color for MobileDB and databases
- Check and uncheck checkboxes from record list view

Version 3.0
- Categorize an unlimited number of databases
- New data types (number, sequence, text, list, date, time and checkbox)
- Popup Dialogs for time and date fields
- Drag and drop column widths
- Multiple options to filter, search, and sort based on any field type
- Create "nested" filters (further filtering on already-filtered records)
- Combine filter criteria with "and" or "or"
- Export records to the Date Book
- Database information screen
- Beam MobileDB from within the application
- More intuitive column width setting
- Support for PrintBoy printing
- Database Information screen
- Left hand user support
- New desktop and export tools

Version 2.1
First release of MobileDB from Handmark, Inc.

Version 2.01 - 2.06
Fixed minor bugs seen in Palm OS v2.0
Fixed bugs with the scroll bar in very large databases

Locked out PalmPilot Personal users as they cannot handle the memory requirements of MobileDB.

Version 2.0
Increased the max number of databases from 20 to 60
Increased the max characters per field to 1000
Added the ability to lockand beam a database
Added the ability to view database size by # records or KBytes
Added the ability to scroll through the records from the record details views

Added font selected in the record details view
Added some great UI enhancements including scroll bars, actions on database list view, etc



Purchasing MobileDB
Handmark has released the
demo version of MobileDB for general distribution.  The demo version enables full MobileDB functionality for 15 days. Users can purchase a serial number from the Handmark web site and enter the serial number into MobileDb to "unlock" it. A MobileDB serial number code can be purchased for $19.99 online from the MobileDB product page or see the Purchasing/Registering section of the Handmark web site for more purchasing options.



Handmark Company Information
Handmark develops consumer software for the exploding handheld computer market. Handmark was created to meet an untapped opportunity for professionally packaged and supported Palm OS¨ software in the retail channel. The company is led by an experienced management team that has successfully developed and marketed numerous best-selling consumer PC software titles worldwide. Handmark software is compatible with the popular Palm¨ and Handspring¨ handheld computers as well as other licensees of the Palm OS including new devices from Sony¨. The desktop component of Palmspring applications is compatible with both Apple¨ Macintosh¨ and Microsoft¨ Windows¨ personal computers. Please see the Handmark web site for more information.

Check out more great Palm OS titles at the Handmark web site.

 

Software License Agreement

PLEASE READ THIS LICENSE CAREFULLY BEFORE USING HANDMARK SOFTWARE. BY USING THE HANDMARK SOFTWARE, YOU AGREE TO BECOME BOUND BY THE TERMS OF THIS LICENSE IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THE HANDMARK SOFTWARE.

The Handmark software ("Software") provided along with this License, is licensed, not sold, to you by Handmark Software Incorporated ("Handmark") for use only under the terms of this License, and Handmark reserves any rights not expressly granted to you. You own the media on which the Software is recorded, but Handmark and its licensors retain ownership of the Software itself.

1. License. This License allows you to:

(a) Use one copy of the Software on a single computer at a time To "use" the Software means that the Software is either loaded in the temporary memory of a computer or installed on the permanent memory of a computer. You may install the Software on a common storage device which is accessible by multiple computers, provided that if more computers have access to the common storage device than the number of licensed copies of the Software, you must have some software mechanism which locks-out any concurrent users in excess of the number of licensed copies of the Software and additional license is not needed for the one copy of Software installed on the common storage device accessed by multiple computers)
(b) Make one copy of the Software in machine readable form solely for backup purposes. Additionally, only so long as the Software is installed only on the permanent memory of a single desktop computer which is not accessible by multiple computers and that single desktop computer is used by one user for at least 80% of the time the computer is in use, that same user may also make a copy of the Software to use on a portable or home computer which is primarily used by such user As an express condition of this License, you must reproduce on each copy any copyright notice or other proprietary notice that is on the original copy supplied by Handmark
(c) Permanently transfer all your rights under this License to another party by providing to such party all copies of the Software licensed under this License together with a copy of this License and the accompanying written materials, provided that the other party reads and agrees to accept the terms and conditions of this License

2. Restrictions. The Software contains trade secrets in its human perceivable form and, to protect them, you may not REVERSE ENGINEER, DECOMPILE, DISASSEMBLE OR OTHERWISE REDUCE THE SOFTWARE TO ANY HUMAN PERCEIVABLE FORM YOU MAY NOT MODIFY, ADAPT, TRANSLATE, RENT, LEASE, LOAN OR CREATE DERIVATIVE WORKS BASED UPON THE SOFTWARE OR ANY PART THEREOF

3. Termination. This License is effective until terminated This License will terminate immediately without notice from Handmark or judicial resolution if you fail to comply with any provision of this License Upon such termination you must destroy the Software, all accompanying written materials and all copies thereof, and Sections 5, 6 and 7 will survive any termination

4. Limited Warranty. Handmark warrants for a period of ninety (90) days from your date of purchase that the Software as provided by Handmark will substantially conform to Handmark's published specifications for the Software Handmark's entire liability and your sole and exclusive remedy for any breach of the foregoing limited warranty will be, at Handmark's option, replacement of the media (if any), refund of the purchase price (based on fair market value of the Software) or repair or replacement of the Software. THIS LIMITED WARRANTY IS THE ONLY WARRANTY PROVIDED BY HANDMARK AND HANDMARK AND ITS LICENSORS EXPRESSLY DISCLAIM ALL OTHER WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE SOFTWARE AND ACCOMPANYING WRITTEN MATERIALS. BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF IMPLIED WARRANTIES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU.

5. Limitation of Remedies and Damages. IN NO EVENT WILL HANDMARK OR ANY OF THE LICENSORS, DIRECTORS, OFFICERS, EMPLOYEES OR AFFILIATES OF ANY OF THE FOREGOING BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL, INDIRECT OR SPECIAL DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION AND THE LIKE), WHETHER FORESEEABLE OR UNFORESEEABLE, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE OR ACCOMPANYING WRITTEN MATERIALS, REGARDLESS OF THE BASIS OF THE CLAIM AND EVEN IF HANDMARK OR A HANDMARK REPRESENTATIVE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Handmark's liability to you for direct damages for any cause whatsoever, and regardless of the form of the action, will be limited to the greater of $500 or the money paid for the Software (based on fair market value of the Software) that caused the damages. THIS LIMITATION WILL NOT APPLY IN CASE OF PERSONAL INJURY ONLY WHERE AND TO THE EXTENT THAT APPLICABLE LAW REQUIRES SUCH LIABILITY BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CON-SEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU.

6. General. This License will be construed under the laws of the State of Missouri, except for that body of law dealing with conflicts of law If any provision of this License shall be held by a court of competent jurisdiction to be contrary to law, that provision will be enforced to the maximum extent permissible, and the remaining provisions of this License will remain n full force and effect If you are a U S Government user then the Software is provided with "RESTRICTED RIGHTS" as set forth in subparagraphs (c) (l) and( 2) of the Commercial Computer Software Restricted Rights clause at FAR52227-19 o sub paragraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at DFARS 52 277-7013, as applicable Manufacturer Handmark, Incorporated 105 East 5th Street, Suite 201, Kansas City, MO 64106.

MobileDB Serial Number
One MobileDB serial number may only be used by a single user on one Palm Computing(R) Platform device. A new serial number is required for each Palm Computing Platform device. Evaluation Version

Evaluation and Registration
This is not free software. Subject to the terms below, you arehereby licensed to use this software for evaluation purposes for 15 days only. If you use this software after the 15 day evaluation period a license fee of $19.99 is required. Licenses are available through the Handmark web site at www.handmark.com. When payment is received you will be sent a serial number which can be entered into the MobileDB application form.

Unregistered use of MobileDB after the 15-day evaluation period is in violation of U.S. and international copyright laws.

Distribution
You are hereby licensed to make as many copies of the this software and documentation as you wish; give exact copies of the original evaluation version to anyone; and distribute the evaluation version of the software and documentation in its unmodified form via electronic means. There is no charge for any of the above. You are specifically prohibited from charging, or requesting donations, for any such copies, however made; and from distributing the software and/or documentation with other products (commercial or otherwise) without prior written permission.

Send comments and requests about this information to info@handmark.com or visit the Handmark web site at: http://www.handmark.com/