DBHelp¹äš"¹äš"HELPDBOS tSTRоtSTRÑtSTRÒ ¦tSTRÓ tSTRÔ ±tSTRÕ tSTRÖøtSTRךtSTRØ tSTRÚÐtSTRÛÑThe database chooser allows you to open and manage all of your databases. • To open a database, tap its name. • To create a new database of any type, tap the New button. All of the other database operations can be accessed from a database's context menu. Tap the icon next to a database's name to activate the context menu for that database. The operations are: • Open Read/Edit- Open the database for normal viewing and editing. All data are protected until the Modify button is pressed. • Open Read/Write- Open the database for viewing and editing without any protection. • Open Read-Only - Open the database for viewing only. No changes can be made while in read-only mode. • Info - Activate the information dialog; you can set the category in which the database will appear in the chooser list. • Beam - Send this database to another device via the IR port. • Delete - Remove this database permanently from the device. • Rename - Change the name of the database. • Duplicate - Create an identical copy of the database under a different name. • Create using... - Similar to tapping the New button except the structure of the selected database will be used as the template for a new database. You can customize the database list so that the databases are listed in either alphabetical order or a manual order chosen by you. Use the Display option on the Options menu to choose. In manual mode, press the pen on a database name and drag the database to the desired position in the list. Use the category selector in the upper-right corner to restrict the database list to only those databases in a particular category. You can set a database's category by choosing Info from the database's context menu. Advanced option: Choosing the Rescan Databases option from the Advanced menu will force DB to search the device for new databases that it might not know about. • Enter the title for the new database into the text field. • DB supports more than one database type for various reasons. Use the Type drop-down list to choose what type should be used for the new database. Note: Not all of the database types support all of DB's features. DB's native type (called "DB" aptly enough) should normally be used unless you have a compelling reason to use another . Use the Sort Order drop-down list to choose an ordering for the listed databases: • Alphabetic - The databases are listed in alphabetical order based on the title. Note: Once selected, any manual ordering will be forgotten. • Manual - There is no particular ordering. You can change the ordering by simply dragging the database to the desired position. • Enter the new name for the selected database into the text field. • If a database with that name already exists, you will be notified. Simply choose another name. • Enter the name for the copy of the selected database into the text field. • DB supports more than one database type for various reasons. Use the Type drop-down list to choose what type should be used for the copy. This is very useful when switching from a legacy type such as the "DB 0.2.x" type to DB's native type which supports all of the newer features. • You can choose to copy the entire source database or just its design. Use the Extent drop-down list to determine what happens. • Select a category for this database by using the Category drop-down list. • You can hide this database from view by enabling the Private checkbox. The database will be hidden when the device has been set to "Hide Private Records" via the Security application. • The database type to which this database belongs is displayed on the Type line. • The list view displays the records of the database in a simple tabular form. • The ordering and size of the columns can be customized via the Edit List Views... command in the ListBox menu which is on the title line. • Tap the Find button to display only those records containing the string. • Select "Filter none" on the list view to show all records. • Tap on a column's header to sort the records by information within that column. • The records can be sorted with additional criteria via the Sort command on the Options menu. • The database design, such as the number and type of fields, can be changed via the Edit Database Design command on the Options menu. • The selection of columns displayed can be changed by choosing a different list view from the View drop-down. This dialog allows you to search the database for specific strings. Only matching records will be showed in the list view. • Select "Filter none" on the list view to show all records. • Enable the Case Sensitive Search checkbox if you want case to matter during the search. • Enable the Match Whole Word checkbox if you want the search string to only match against whole words. • Use the Search drop-down to restrict the search to a specific field. For new databases, this screen allows the initial structure of the database to be created. For each field in the new database, fill in a row of the display. There is no need to fill in every single row. DB will automatically recognize that the remaining rows are blank and will not use them. For existing databases, the current database structure will be displayed for review or modification. Some changes to the design of an existing database may be extensive enough to require a complete rebuild of the database. DB will always ask for confirmation before a rebuild when the Done button is tapped. • You can add and delete rows by tapping the down arrow on the left side of a row. This will display a context menu for that row offering choices: Insert before, Insert after, and Remove. • Every field must have a name. This is especially important for new databases since DB will not recognize a row as a field unless you fill in the name. The popup list on the right-hand side of the display allows you to choose a data type for a field. A data type specifies to DB the type of information that will be stored in the field. There are several types available: • String - plain text • Boolean - true/false, on/off, etc. • Integer - integer numbers between -2147483648 and 2147483647 • Date - month, day, and year • Time - hour and minute • Note - string of 11 characters + note of 500 characters displayed in a memo • List - list of Items (32 items max) • Link - llink to a record of another database • Float - float number