Data On The Run 4 User Guide
To view the user guide in PDF format,
Click Here
Contents:
Quick Start Notes:
Installation Notes
Upgrading from Data On The Run 3
Compatible Devices
About the .NET Compact Framework
Launching the program and selecting a file
Opening a table
List View
Form View
Zooming in on your fields
Returning to the list of files
Working with Data
Transferring a database to the device
Working with Queries
Creating a new query
Saving a query
Using wildcards and functions
Entering SQL Commands
Removing an applied query
Editing an existing query
Deleting a saved query
Managing your database
Creating a new database
Creating a new table
Adding a new record
Deleting a record
Sorting your records
Deleting a table
Editing the table structure
The Drop Down Wizard
Setting up drop down choices
Program Options
Using list view as default
Including date/time in fields
Automatically open last table
Other available options
Data On The Run ©2001-2004, Biomobility,
LLC
http://www.biomobility.com
Installation Notes:
Data On The Run is built targeting Microsoft's .NET Compact Framework. The
.NET Compact Framework is required; see "About
the .NET Compact Framework" for more information. To install Data
On The Run, download the installer, and double
click on this file on your desktop computer with the device connected,
and follow the prompts. Windows Mobile 5 users can find instructions
here.
See Also
Contents
Upgrading from Data On The Run 3
It is recommended that you remove earlier versions of Data On The Run prior to
installing Data On The Run 4. Versions 3 and earlier used files that are
no longer needed in the new version.
See Also
Contents
Compatible Devices
Data On The Run is written to support standard, landscape, and square screen Pocket
PC/Windows Mobile devices. Data On The Run will work with any Pocket PC
device as long as the .NET Compact Framework is installed;
see below for more information.
Compatible devices include the Dell Axim series, Compaq iPAQ, Toshiba, Viewsonic,
and any other device that runs the Pocket PC/Windows Mobile operating system.
See Also
Contents
About the .NET Compact
Framework
Data On The Run is built targeting Microsoft's .NET Compact Framework.
Version 1 Service Pack 2 or later of the .NET Compact Framework is recommended.
Here is a list of devices and which version of the Compact Framework they
shipped from the factory with:
Pocket PC 2002 and earlier devices - did
not include the Compact Framework; you can
download it here.
Pocket PC/Windows Mobile 2003 devices - included Service Pack 1.
Data On The Run will work with Service Pack 1, but for best performance you can
upgrade to Service Pack 2 or later.
Windows Mobile 2003SE devices - include Service Pack 2; no further
downloads are necessary.
See Also
Contents
Transferring a database to the device
See http://www.biomobility.com/transfer.htm
See Also
Contents
Launching the program and selecting a file
To launch Data On The Run, tap "Start" "Programs""Data On The
Run". It will open with a list of available database files. You can
choose the file you wish to open by tapping on that file, or click the New
button to create a new database file.
See Also
Creating a new database
Returning to the list of files screen
Contents
Opening a table
After launching Data On The Run and selecting a table, you can
tap the "Tables" tab to see a list of available tables in your database file.
You can choose the table you wish to open by tapping on that table, or click the
New button to create a new table.
See Also
Creating a new table
Contents
List View
Tap the list view tab and you will see your data in a grid.
If you would like to edit the contents of a field, tap twice on that field and
it will bring up a box at the top of the grid where you can edit your data.
Clicking the New button from List view will add a new record to the database.
Buttons and menus at the bottom, from left to right, are: the New button, the
Main menu button, edit menu (indicated by the small triangle to the right of the
Main menu button), Delete the current record, Sort the records, and Query (search) the records.
See Also
Contents
Form View
Tap the form view tab and you can view your data one record at
a time. To edit an entry, tap on that field and type in the new value you
want. Buttons and menus at the bottom, from left to right, are: the New
button, the Main menu button, edit menu (indicated by the small triangle to the
right of the Main menu button), Go to first record, Go to previous record, Go to
next record, Go to last record, Delete the current record, Sort the records, and
Query (search) the records.
See Also
Contents
Zooming in on your fields
In form view, to view a larger window and see more of the data
in a particular field, tap the field name on the left hand side of the form
view. This will bring up a larger window where you can view and edit your
data.
See Also
Contents
Returning to the list of
files
To return to the list of database files and select a different
database or create a new database, tap the Main icon
(Green runner person logo)
and choose "Change Database".
See Also
Contents
Creating a new query
From Tables, Form, List, or Query view you can tap the
magnifying glass icon to query (search) your data. Also, from the Query
tab you can tap the New button, or tap and hold over the box that lists the
queries and choose "Create New Query". To create a query, first select the
table you wish to query from the top drop down list. Next, select which
field you wish to search. Then, choose a criteria, such as "Is Equal To"
or "Contains". Then enter the data you wish to search for in the
"contains" text box. For more complex searches, you can click the "And..."
or the "Or..." buttons to add additional criteria for a more complex search.
See Also
Saving a query
Using wildcards and functions
Entering SQL Commands
Removing an applied query
Contents
Saving a query
To apply your query without saving it, click the green OK
button at the bottom once you are done building your query. To apply AND
save your query for future use, click the "Save" button (it looks like a floppy
disc). If you wish to save the current view as a query, click on the Query
tab, and the Manage menu item, and select "Save current SQL to Query list".
See Also
Contents
Using wildcards and
functions
When building a new query, you can enter "Wildcard()" or
"Today()" as the text to search for in the "Contains" text box. When the
query is run, if it contains "Wildcard()" then you will be prompted for a value
to search for, and if it contains "Today()" then today's date will be used for
that value each time the query is run. The Wildcard() and Today()
functions can be entered in the "contains" text box automatically by accessing
the "Advanced" menu when building a query.
See Also
Contents
Entering SQL Commands
If you are familiar with SQL and would like to manually type
in your own SQL queries, choose "Advanced" "Enter SQL command".
See Also
Contents
Removing an applied query
Tap on the "Query" tab and the "Manage" menu item. Here
you will find menu choices to remove the current sort, remove the current query,
and remove both the current sort and query.
See Also
Contents
Editing an existing query
To edit an existing query, tap and hold over the query and choose "Edit" from
the pop up menu.
See Also
Contents
Deleting a saved query
To delete a saved query, tap and hold over the existing query and choose
"Delete" from the pop up menu.
See Also
Contents
Creating a new database
From the list of files screen, choose the New button.
You will be prompted to name your database. Your new database will contain
no tables.
See Also
Returning to the list of files screen
Creating a new table
Contents
Creating a new table
From the "Tables" tab, click the New button, or tap and hold
over the list of tables and choose "Create New Table". You will be
prompted for a name for your new table; enter the table name and choose OK.
Then, you will see a box where you can type in the name of a field, and beside
that there is a drop down list of available data types. Type in the field
name, choose the type of data you want that field to hold, and click the "Add"
button. You will see the list of fields and their data types in the list
below. Continue this process until you have all of your desired fields.
To delete a field, tap the field in the list and choose the "Delete" button.
See Also
Contents
Adding a new record
From either Form or List view, choose the New button and a new
record will be added.
See Also
Form View
List View
Contents
Deleting a record
To delete a record from List view, tap on the gray bar on the
left of the grid to highlight the entire row, and then choose the delete button
from the bottom. In form view, clicking the delete button will delete the
record that you are currently viewing.
See Also
Contents
Sorting your records
From either Form or List view, click the Sort icon. From
the first drop down list, choose the primary sort field and then from the box
below that whether you wish to sort ascending or descending. If you would
like, you can choose a secondary sort field, also followed by ascending or
descending order. To cancel out of this screen without applying a
sort, simply click OK without selecting anything.
See Also
Contents
Deleting a Table
To delete a table, tap and hold over the table and choose "Delete" from the
pop up menu.
See Also
Contents
Editing the table structure
To delete a field, move a field, rename a field, or add new fields, tap and
hold on the table in Table view and choose "Properties". Then, tap and hold
over the fields for additional options. Be aware that some changes to the table
structure can disable synchronization between a desktop Access file and the
mobile device.
See Also
Contents
The Drop Down Wizard
Tap the main menu icon
(Green runner man at the bottom) and
choose "Drop Down Wizard". First, select the table that you wish to have
drop down choices for. Next, select the field in that table where the
choices will be available. Then, choose whether you want the choices
pulled from another table, or if you wish to type in the values. If you
choose to type in the values, in the next screen you will type in each value in
the text box, and then click the "Add" button until you are done. Once
done click "Finish". If you choose to have your choices pulled in from
another table, you'll be asked from which table and which field you'd like to
pull in choices from. Once done click "Finish". These choices will
now be available by tapping on the black triangle to the right side of form view
beside your data for that field, and also at the top of List view when you are
editing your data
An advanced drop down option is to display choices from one field in the drop
down list, yet use the actual values from another field. You can select
which field you wish to display, then click the "Advanced" button and select
which field you wish to have the actual values come from.
See Also
Contents
Using list view as default
You can select whether you want the program to automatically
take you to Form or List view whenever a query is applied or a table is opened.
See Also
Contents
Including date/time in
fields
This option controls whether date/time fields display only the
date, or both the date and the time.
See Also
Contents
Automatically open last
table
If you select this option, when you reopen the program after
it has closed, you will be returned to the last file you were using, and to the
last table, with the last SQL that you had applied.
See Also
Contents
Other available options
You can adjust the Font size, the color of the labels, and the
widths of the field names. Additionally, there is an advanced option that
will specify the lowest number that can be assigned for the ID of a new record.
See Also
Contents
