********* Quick Documentation For JFile 1.6b *********** !!!!!!!!IMPORTANT NOTES!!!!!!! - JFile users can install this program right over top of the older one. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ***** CHANGES section moved to the bottom of this file ******* Features: - Filtering of records - Sorting on secondary and tertiary sort fields - Forward and reverse sorting by field (when tapping column heading twice) - Columnal formatting when viewing a database - Cut/Paste between fields - Local find function in the database view - Columnal formatting in the database view Limitations: - 30 databases (2 in the unregistered version) - field names can be no longer than 20 characters - 20 fields per databases - 500 characters per field of data ***************************** USAGE ******************************* ***** Viewing LONG fields: If you have a lot of data in one field (more than 200 characters usually), and it spills of the screen, you will need to drag the cursor down the the field (ie. selecting the text) to scroll to the remainder of the data in that field. This may be modified in the future for easier usage of long data fields. ***** Creating A New Database: To create a new database, tap the 'New DB' button. Enter the name of the database, and a minimum of 1 field name. Then tap the 'Create' button. You're done... you have a new Database ready add records to. ***** Viewing A Database: While on the main view screen, tap on the title of the database you would like to view. A new screen comes up, with the title indicating which database you are in. For a new database you will see only the column/field headings. To add a record to your database... ***** Adding Records To A Database: While viewing a database, tap the 'Add' button. You will be presented with a form showing the field names, and space to enter your data. When through editing your data, tap 'Done' to save the changes, 'Cancel' to cancel them, and 'Del' if you wish to delete the record from the database. ***** Sorting a Database: While viewing a database, you can tap on any of the column headings to sort the database by that particular column/field. Tapping the same column heading again will sort the database in the reverse order. Columns of all INTEGER values will sort properly. A new menu option to sort the database with secondary and tertiary sort fields is now available. ***** Horizontal Scrolling Horizontal scroll buttons added to the database view. The first column is a non-scrollable column (as this has been most requested to keep this as a 'base' column) and any other visible column will now scroll left and right through the available fields. ***** Field name modification You can now change the names of fields after the database has been created. You can also add fields to the end of the field list, and delete fields from the database. NOTE HOWEVER: that deleted fields will be replaced by the field that followed it. Ie: Previous fields: Name: Address: Phone: You can then remove Address: and replace with Phone: but you will LOSE you old 3rd field (Phone) and Phone data will actually be Address data already entered. This is a bit complex... so for now it is best to stay away from field deletion unless you have no data in the database as yet, or understand how the deletion works. In essence you are replacing the Address: field name with Phone: field name, and removing the Phone: field... no data transfer is done, just the field name change, and the removal of the third field completely. ***** Changing the Columns Format: While editing a record, you can use the Menu to increase or decrease the amount of space allotted to the data fields. Likewise, in the database view, selecting the menu item 'Column Formatting' will take you to a setup screen to determine how you would like to view the database. You have up to 20 columns to display your data in. Each field (1-20) gets its own column. You can set the number of columns you would like to see on the main database screen, as well as the width of each column. For instance, say you have the following fields: State Name: (field 1) State Bird: (field 2) State Cap.: (field 3) State Flower: (field 4) But only wanted to view the State Name and flower in the main screen. You would then choose 0 widths for columns 2 and 3, and appropriate widths for columns 1 and 4. You have up to 160 pixel width to work with so an possibility is: Column 1 Width: 90 Column 2 Width: 0 Column 3 Width: 0 Column 4 Width: 70 This will show 90 pixels for the state name, and 70 pixels for the state flower. ******************************************************************************** Changes Since 1.6a: - Fixed a number of problems dealing with older Pilot sorting with JFile Changes Since 1.6: - Quick fix of the error resulting from a Hardware 'UP' button press when already at the top of the database list Changes Since 1.5b: - Major fixes/changes to the handling of long field records - scrollers (onscreen and button) should work properly now - Fixed Up/Down hardward scroller buttons in Main database view - Fixed a problem dealing with installing JFile after a hard reset of the pilot - which would sometimes cause JFile to produce an error. Changes Since 1.5: - Speeds up redraws and sorts that was heavily reduced in version 1.5 - Eliminates the bug when doing multiple field sorts - Other smaller bug fixes Changes Since 1.4a: - Fixed a bug that caused a conflict with SelectHack (!) - Max field length increased to 500 characters per field - Again had to correct the alarm bug when viewing a database and alarm triggers on a 1000 or 5000 series model - Fixed bug in Find dialog where a garbage characters might show up Changes Since 1.4: - Bug fix, corrected the fatal error on longer fields in the edit record screen Changes Since 1.3: - JFile will now return you to the database or item you were currently viewing when you last exited the application - Space and backspace graffiti characters now simulate the left/right scroll arrows while viewing a database - Added command shortcuts for Filter, Sort, and Show All - Add a checkbox on Find & Filter to ONLY find/filter those records with fields BEGINNING with the find/filter string - Added Goto top and bottom of the database menu items (with command shortcuts) - Added menu item to jump ahead or backward a specific number of records for quicker navigation in longer databases - Hardware up/down scroll buttons on MAIN screen now scroll a full screen of db's at a time - Fixed problems when editing a record, longer fields would not scroll properly Changes Since 1.2: - Added next/previous graffiti strokes to the record view to easily move between fields without extra tapping - Added next/previous field menu items and 'Commands' also for easier movement between fields - In the show all databases view - the database names are sorted alphabetically - Switching apps while modifying a record will now save the modifications made - Bug fix: Fatal error if an alarm comes up while viewing a database fixed Changes Since 1.1b: - Added 'Please Wait' blinking message for longer sorts/finds/filters - Focus set to initial fields on most dialogs - Auto capitalization on initial field focus - Filter function added - Fields with integers and text interspersed now properly sort as text fields ie. you can sort by date if in the form year/month/day - Adding sorting by secondary and tertiary sort fields - Find and filter work on individual fields if desired Changes Since 1.1a: - This is a small bug fix release - Numerous uncommon bugs fixed Changes Since 1.1: - Fixed errant Find function Changes Since 1.0 beta-4: - Ability to have record and database deletion confirmation as an option - Ability to backup databases on a per-database basis - The inverted screen bug should no longer be seen - Screen clutter removed on some of the tables - Current record position is now remembered if you edit a record and return to the database view - A BIG speedup when viewing databases - especially larger ones - Numerous other smaller fixes and additions Changes Since 1.0 beta-3: - Name change for the app - Left/right scroll buttons on record view form to go through the records sequentially - Hardware scroll buttons now scroll full pages at a time Pen tap scroll buttons still function as line at a time scrolling - Beta-4 should not have problems handling older beta database - Delete record toggle button added to database view - Horizontal scrollers reposition to top of screen - Bug fixes include: - more fixes on the app-switching problems while editing a record, or creating/editing a new database - numerous other smaller bug fixes Changes Since 1.0 beta-2: - Quick fix to the NewDB button followed by cancel = ERROR... this is fixed now Changes Since 1.0 beta-1: - Added left/right scroll buttons to the show database form - Up to 20 fields now available - Up to 200 characters of data per field now allowed - Sorting on all INTEGER fields allowed - Local find function no longer depends on upper/lower case - Field name modification/deletion/addition added - Graffiti state indicator added to 'Find' dialog - Bug fixes include: - the UUUUU lines that sometimes appeared when switch apps fixed - error when switching apps from edit record view after deleting a field fixed - ghost characters left over when trying to remove a line of data fixed - many other misc fixes (spelling errors, new buttons etc)