Overview

ScopeDB program is a full-featured database management application to organize any kind of data you need. It can handle multiple data tables holding any number of columns supporting a variety of data types. (Text, Float, Int, Date and Time, Popup list)

All tables are searchable, supports filtering and backup to host PC.

ScopeDB is an application based on dpScope ClientScope library

Features

• Create Databases
• Various attributes: Enable/Disable Global find, backup, deletion, protected state, and set the author attribute.
• Define database fields. Each field has some common (visibility, type, sort, etc) and type dependent (default value, domain, etc) attributes.
• Modify Databases
• Add/Remove/Modify records.
• Modify database and field attributes.
• Some field type conversion also allowed
• Filtration is also enabled with database list view. Define filter conditions on any database field.
• Multiple Databases
• Delete Databases
• Backup Databases on PC
• The program is fully customizable, general dpScope preferences are included
• Beam a whole database or a single record. Beam attributes can be changed.

System Requirements

Any PDA powered by PalmOS® 3.3 or higher.

Installation Guide

Install scopedb.prc file using your favorite synchronization tool. (Palm Desktop, Pilot Install, or similar)

The PDB files in sample_data are provided as test data to help evaluating the program. Install them for testing, or skip their installation to let the program run without any predefined database.

How to use General features Toolbar icons: NEW icon creates a new item, new database on the main screen or a new record inside a database. OPEN icon. Opens the selected database in database list view Delete icon, confirm deletion then delete record or database. Details icon, show details of the selected item Beam icon, send the selected element of a list or a detail screen to another Palm handheld using IR. OK icon, saves changes and return to previous screen. Cancel icon, confirm cancel then discard changes and return to previous screen. Right arrow, closes database attributes screen, and proceed to the field list screen Left arrow, closes the field list screen, and returns the database attributes. Up arrow, changes the order of fields on the field list screen. A field must be selected in the list. Down arrow, changes the order of fields on the field list screen. A field must be selected in the list. Apply changes on field list view and return to main screen. Close database and return to main screen Open the filter definition screen USE FILTERS icon, guides back to database list screen using the defined filters.

List screen features: Use LOOKUP field to search for an item. The text in the lookup field is the caption of the selected columns. While editing the field value the list positions itself to the first matching record. Sort field, tap on header to sort Sort field, sorted ascendant. Tap on header to rivers order. Sort field, sorted descendent. Tap on header to rivers order. Drag the list border to resize field width. Swaps toolbar visibility.

Main Screen -- Database List

The main screen contains the list of databases available. Add new, open or modify selected database according to the next operations:

• Use LOOKUP field to search for an item.
• Add new databases with NEW icon.
• Tap into the table to select database.
• Use OPEN icon to open the selected database.
• Use DELETE icon to delete the selected database.
• Use DETAILS icon to review the attributes of the selected database.
• Use BEAM icon to send the database to an another PDA via IR.

Database Attributes

The screen displays detailed information about a database. Database NAME or AUTHOR attribute can be modified.

Flag Attributes:

G. find (Global Find) Enable Palm OS Global Find function for the database. When checked, tapping on the Find icon will also search this database by field contents even when ScopeDB application is not running. Deletion Enable database deletion. Protected Make the database read only Backup Backup the database at the next HotSync® operation.

Use RIGHT ARROW to navigate to field list screen.

The CANCEL icon discards changes, and goes back to previous screen.

Field List screen for New Database

This screen appears as the second step of a database creation. Define all fields of the database on this screen before the creation of the database itself. Fields can be added, deleted and modified before the final creation of the database.
(Warning: adding new fields to an existing databases is not allowed.)

Add new fields with NEW icon. The field attributes screen will appear.

Tapping into the table to select a field for deletion or modification.

Use UP or DOWN ARROW to change the order of fields

Inspect and modify field attributes with the DETAILS icon.

Use LEFT ARROW to switch back to database attributes screen.
(Field information is maintained.)

Use CANCEL icon to discard changes and return to main screen.

Tap on APPLY CHANGES icon to initialize the database, and return to the main screen. The new database is listed on the database list.

Field List screen for Existing Database

Field list screen for an existing database is similar to those for a new database, but add field function and field order change are disabled, their icons are invisible.

Field Attributes Screen

Edit the attributes of a field in this screen.

Field name (name of field), Type (type of field), Visible (can be seen in the list view), Column width (column width in the list view), Sort and Default (default value) lines are common in every field type.

Available field types: Text contains any text with fix field size, max 65535 Float 4 byte signed fix point floats, precision between 0-9 digits Number 4 byte signed integer Flag Checkbox Date Date or time or both Pop Up List of values separated by line feeds. Each type has specific information. E.g.: you can define max number of characters, line breaks and barcode support for a string typed field.

Accepts changes and return to field list screen tapping on OK icon.

Cancel changes and return to field list screen tapping on CANCEL icon.

Database List View

When you open a database on the Main Screen tapping on the OPEN icon, the Data List Screen opens. Use this screen to manage the content of a database.

Use LOOKUP field to perform a fast search.

Tap into the table to see details of the selected record.

Add a new record to a database tapping on the NEW icon.

Tap on the BACK icon to return to the Main Screen.

Use FILTER icon to opens the filter definition screen.

Filter Definition Screen

Inspect filters defined on this screen. Each filter has a field name, a condition and a value.

Tapping into the table will open the filter detail screen. Modify or delete the filter condition there.

Add a new filter condition tapping on the NEW button, and then setup the filter condition on the filter detail screen.

The APPLY FILTER button returns to the database list view, and shows only those records, that matches the criteria.

Filter Detail Screen

Define a new or edit an existing filter. At first, you have to specify the field from the currently opened database. Then add a condition. The available conditions are depending on the field type. Define a correct typed value to the condition.

Use OK or CANCEL icons to save or discard changes.

Use the DELETE icon to drop an existing filter condition.

Record Detail Screen

This screen displays detailed information about the selected record, or adds a new one to the opened database.

Use the arrows to move the next/previous record. Modify the record displayed. Tap command icons to accept (OK) or CANCEL modifications.

Tap DELETE icon to delete an existing record on display.

Tapping on BEAM icon sends the single record displayed to another handheld via IR.

Beaming Process

This application features database sharing with other ScopeDB users. The Beam Settings dialog box can be accessed from the OPTIONS/BEAM SETTING menu item on the Main Screen. This dialog contains options to accept data via IR connection.

When Skip incoming DB with the same name is checked, the application doesn''t save any data from the incoming database, if any other database exists on the receiver handheld with the SAME name.

When the Append records to existing DB is checked, the application tries to save every records of the accepted database.
Two records have common origin, if (at least) one of them has been beamed to another device, regardless of further modifications. The Overwrite common origins sub-option controls the way these kind of records handled when attempting to overwrite one with another. If the Overwrite common origins sub-option checked, records with common origin will be overwritten on the receiver handheld. Otherwise the existing records are kept.

Overwrite or Append feature only works when an existing and the incoming databases are identical.

Tap on SAVE or CANCEL icon to save or discard modifications in this dialog.

DEFAULT button checks in a pre-defined state.

After every beam process the application informs the user how many records were saved or skipped.