The first time you run SprintDB Pro you will be able to:

• Open a Database
• Create a New Database
• Creating Tables
• Delete an existing Database
• Add Favorites
• Remove from Favorites
• Set the Open by Double-Clicking option
• Change the Layout properties
• Set the Show System Table option
• Set the Form File Folder
• Import from a CSV file
• Export to a CSV file
• Get Help
• View the About screen

Opening a Database
To open a database, Tap the File menu and select Open Database. This will load a list of SprintDB Pro (.cbd) compatible database files. Choose the database required and Tap the filename.

To view the tables in the database, tap the Table tab. 

Opening a Table
To Open the table you can either double-tap the table name or tap the Open button. The table will be displayed in a data grid. You can then browse, filter, sort find records and more.  For details, see Using Tables.

Create a New Database
To create a new database, use the following steps.
» First, create the 'Database File'. Then create one or more 'Tables'.

1. Tap the File > New Database
2. Enter a Name for the database
3. Choose a Folder to store the database in from the DropDown box
4. Select the Type of file. The Default is Pocket Access (*cdb).
5. Choose a Location for the file. If you have CompactFlash, SD, card or Microdrive, it will be listed as 'Storage Card', or 'Storage Card1'.
6. Tap OK. This will create an empty database file.

<Top>

» Creating Tables

Delete a Database
To delete an existing database file, you must first Open it. This will display the Database Name at the top of the form -- above the List box. You can then:

Select File > Delete Database.

Please note: This action will destroy all the tables and data in the file. There is no Undo option.

<Top>

Working with Favorites

SprintDB Pro provides you with an 'Add to Favorites' feature that allows you to quickly open either a database Table or a Form. When an item has been added as a 'Favorite', it is display in the 'Favorites List' in the format shown at right. A Table is indicated with a "T" and a Form with an "F".

To add a 'Table' to 'Favorites', use the following steps:

1. Open the Database containing the Table you want to add.
2. Make sure you have selected the Table Tab.
3. Tap the the Table name to select it.
4. Tap Tools > Add to Favorites.

Once the Table or Form has been "Added to Favorites", you can tap the Favorites tab to view the list of Forms and Tables. To Open a Favorite, tap the Open button or simply double-tap the required item. Note: you must have Open by Double-Clicking checked on the File menu for this to work; see below.

<Top>

Removing Items from Favorites

1. Select the Form or Table.
2. Tap Tools > Remove from Favorites.

Open by Double-Clicking

Checking this item on the Tools menu allows you to open a Table or Form by Double-tapping on it. If it is not checked, you can only open the item by tapping the Open button.

Setting Layout Options

SprintDB Pro allows you to personalise the "look and feel" of the User Interface. By selecting Layout from the Tools menu, you can adjust the following settings:

• The Font name and type (e.g. Bold, Underline, etc.)
• The Background Color of the window
• The List Background Color
• The Button Background Color
• The Current DB Text Color
• The List Text Color
• And the Button Text Color

<Top>

Show System Table

Pocket PC devices operating under Windows CE 3.0 and Pocket PC 2002 maintain their own System Table. Normally SprintDB Pro doesn't display this table; however, by selecting Show System Table from the Tools menu, you can view these files by tapping the Table tab.

Setting the Form File Folder

When you create a Form in SprintDB Pro, it is stored in the default folder, \Program Files\SprintDB Pro\Forms. This option allows you to specify another folder to store your 'Form Files' (.RAF) in. 

To change the Form File Folder:

1. Tap the Tools menu > Form File Folder...
2. Enter the path to the new Form File Folder
3. Tap the OK button

If the folder doesn't exist, it will be created.

<Top>

Importing and Exporting CSV Files

SprintDB Pro can Import and Export CSV (Comma Separated Value) files. This allows you to, for example, export a Microsoft Excel file in CSV format, copy it to your Pocket PC and Import it into a SprintDB Pro table. You can also open Text (*.TXT) files.

CSV files may be delimited with other characters other than commas. Other characters can be: the Tab, Semicolon or Space.

Importing

1. Tap the Table tab.
2. Tap File > Import from CSV...
3. Select the type of file from the Type list. This will load the Import Wizard window and display the Data Preview box, allowing you to check the contents of the file.
4. Select the Field separator character. This can be a: Tab, Semicolon, Comma, Space or other character which you can choose by tapping the Etc option and entering the desired character into the box at the right.
5. If the Field names are stored in the first line of the file, tap the Field names in first line CheckBox.
6. To set specific String Quotation marks, and DateTime Format options, tap the Advanced button and select your preferred options from the lists provided.
7. When you have set all the required options, tap the Next button.
8. Enter either name for a New Table or tap the Existing Table Radio button and choose a table from the list. When complete, tap the Next button. You can now define the Field names and Types if you didn't previously do so.
9. To change the Field name, tap in the List grid to select the field and then enter the new name into the Name box.
10. Choose a Data Type from the Type list.
11. If the selected field is a Text field, choose the Field Size.
12. To ignore a Field Name, Check the Ignore field box.
13. Repeat the steps above for each field.
14. When complete, tap the Import button.

Exporting

When exporting a SprintDB Pro table to a CSV or TEXT file you need to use a Query, i.e. a SQL statement to determine the scope. Use the following steps:

1. Tap the Table tab.
2. Tap File > Export to CSV...
3. Tap the Query button. This will load the Query Builder.
4. From the Tbl: [Table] list, choose a table to export.
5. If you want to export all the fields in the table, the simplest way is to enter "*" [no quotes] into the SELECT field. However, you can use any valid Query.
6. When the query is complete, tap OK. The Export Wizard will now display a your data in the list control. The next step is to enter a file name for the export data.
7. Tap the Save As button and enter a File Name, desination Folder and choose a File Type, either CSV file (*.csv) or TEXT file (*.txt). When complete, tap OK.
8. Tap the Next button and choose the Field separator character. If you would like to use the data in the first line as the Field Name, check the Field names in first line box.
9. Tap the Advanced button to choose the String Quotation mark and Date and Time options.
10. Tap the Export button. The file will then be exported to the specified file name and folder.

Getting Help

Tap the Help menu > Help to open the Pocket PC version of this Help file.

Viewing the About Screen

Tap Help > About to view version and copyright information about KaioneSoft. You will need this information when you contact KaioneSoft Support.

<Top>

« Back  |  Next »