Overview

There are basically two ways to use database Tables in SprintDB Pro:

1. By opening a table directly.
2. In an Application Form.

Most of these actions are controlled by the Tools menu; however, you can also 'Tap and Hold' the stylus on the Table itself to choose other options, including Hiding columns, Copying and Pasting.

» Creating Tables

1. Tap the Table tab.
2. Tap the New button. This will open the 'Create Table' form (above).
3. Enter a Name for the Table in the 'Table Name' field.
4. Enter the Field Name you require.
5. Select the Type of field: for example, Text, Integer, Double, Memo, etc.
6. If you choose a 'Text' field, you can then specify the the Size of the field in the range of 1 - 255 characters. If you require a larger size than 255, you should select Memo. Note: you can enter any number value from the Input Panel.
7. Tap the '+' button to add the table.
8. To add more field names, tab the New button and repeat steps 4 through 7.
9. You can reposition the field by tapping the field name in the list to select it and using the Up and Dn buttons.

<Index>

Creating an Index
Once you have defined all the fields required, you can Create an Index. If your database is likely to contain a large number of records, it is highly recommended that you use an Index as it will make data retrieval much faster.

1. Tap the Field Name you want to create the index on.
2. Choose the Index Type from the DropDown box. Index types are: 'ASC' (Ascending), 'DESC' (Descending) and 'No' (No index).
3. Tap the Create Index button.
4. To create indexes on another field, repeat steps 1 to 3.

Renaming and Dropping Fields

1. To 'Rename' a field: Tap the fieldname you want and tap the Rename button.
2. To 'Drop' (Delete) a field: Select the required field and tap the Drop button.

Set the AutoNumber Field

1. To create an AutoNumber field, make sure the Field Type is set to "Integer".
2. Create an 'ASC' (Ascending) Index first.
3. Select the field and tap the AutoNumber Field button.

New AutoField Types

Please Note:
SprintDB Pro version 1.7 now supports AutoFields other than the AutoIncrementalField.

The new features are:

• AutoIncremental
• RandomNumber for the Integer type field.
• GUID and RandomNumber for the Text type field.

1. In the Table Editor, select a field in the Field List.
2. Check the AutoField checkbox, and then select an AutoField type.

Renaming and Dropping Tables
To Rename a table:

1. Enter a new table name in the Table Name field.
2. Tap the Rename button.

1. Tap the Drop Table button. SprintDB Pro will prompt you by asking, "Are you sure want to drop this table "Tablename"?
2. Tap 'Yes' to continue or 'No' to cancel the action.

Warning: Dropping a table Deletes the entire table from your device. There is no Undo option.

<Index>

Saving your Table

When you have finished creating and Indexing your table, tap the Create Table button to complete the process.

Tap the Quit button to Exit.

Viewing the Table

The Main Table Controls

To view and browse a table, tap the Table Tab > Open. This will allow you to access the File and Tools menus.

Refer to the illustration (right) for information on the 'Main Controls'.

The Scroll Left & Right buttons scroll the Table columns.

<Index>

Viewing Options

Viewing a Single Record

When viewing a table in 'List View', tapping the Detail button allows you to view the details of the selected record. You can also Add, Delete and navigate in this view.

Viewing a Single Field

Tapping the Zoom button allows you to view just the record's Field contents.

Adding and Deleting Records

You can add and delete records in the 'List View', 'Detail' and 'Zoom' window views.

Undo Button

Tapping this button Undoes the last action.

Inserting the Current DateTime

To insert the Current System Date and Time in a single string, tap Tools > Insert Current DateTime.

<Index>

Creating a New Query

To create a New Query, tap File > New Query ... This opens the 'Query Builder' form. Use the following steps to build the query.

1. Enter the 'Scope' in the Select field
2. The From field will automatically contain the currently open table name. Other tables in the current database are listed in the Tbl DropDown box
3. The i.join field allows you to select another Table and Field to use if you want to create an 'Inner Join'
4. To construct the Where element of the statement, choose a FieldName from the Fld dropdown box
5. To insert an 'Operator', (=, <>, etc.) select one from the DropDown box. The default is "=".
6. The Order By field allows you to set a 'Filter'. Tap the Fld DropDown box and choose a field to order by.
7. You can then add a 'Condition', e.g. AND, OR, DESC, etc.
8. Tap the OK button to run the Query.

For more information on Queries, see Creating SQL

<Index>

Saving a Query

When a Query has been created, you can assign it a name and save it.

1. Tap File > Save As Query
2. Enter a Query Name in the Save as dialog
3. Tap the OK button

Opening a Query

Once a Query has been saved, it can be opened later. Tap File > Open Query ... . This will immediately run the query.

<Index>

The Tools Menu

This is located next to the File menu. It gives you access to the Filtering, Sorting, Editing, Aggregate, Go To Record and Find Records.

Tap and Hold Menu Options

When you view a table in "List View", you can "Tap and Hold" the stylus on a column in table. This gives you an alternative method of accessing the items on the Tools menu, plus: Hide this Column, Show All Columns, AutoSize this Column, AutoSize All Columns, Copy and Paste.

Filtering and Sorting Your Records

The following Filter options are available:

Hiding and Showing Columns

You can Hide a selected Column by selecting Hide this Column from the "Tap and Hold" menu.

To Show the hidden Column(s), select the Show All Columns item.

<Index>

AutoSizing Columns

Autosizing sets the width of the selected column to maximum width of the longest field or the width of the Fieldname. You AutoSize All Columns or just the currently selected column from the "Tap and Hold" menu.

Setting Options

To adjust the settings for the Table List view, select Options... from the
Tools menu.

The following options are available:

• Confirm before record deletion - when checked, you will be prompted to confirm your action before deleting a record.
• The Maximum characters in a column options allow you to
  a) Display all the characters in a column (Maximum) -- or
  b) Limit how many characters are displayed.
• When using Yes/No fields, you can choose a default string. Select from the available options.
• Tap'n Hold Popup Menu can be turned On or Off. If it is On, you will be able to enter a response time value in milliseconds.
• Sort by tapping list column header - allow you to tap the 'Fieldname' at the head of column to apply the default or pre-set Sort condition.

Layout Settings

You can adjust all the control properties in the Table View. For a detailed description see Layout Options in Getting Started

Finding Records

There are two ways to Find records in the Table View -- from the Tools > Find Records menu and the Tap and Hold menu.

Use the following steps to find a records:

1. Select Table and the Fieldname you want to search on. Note: By default the Fieldname and Table name will be the selected field and table but you can choose another field and table from the DropDown boxes at the right.
2. Enter a string to Find
3. Chose a Condition: contains, begins with, ends with, etc.
4. Tap OK.
5. When the first instance of the Find string has been located, you can tap the Next or Previous buttons at the bottom left of the window.
6. To close the Find, tap the End menu item.

<Index>

« Back  |  Next »