INSTALLING

To install place all these files in a directory on your desktop and run setup. It will copy all files to your Docked PDA. If a window pops up on you device asking you if you want to over write existing files, click on the "NO TO All" button. I believe it does this because in PockePc2002 some of the eVB files are now part of the operating system.

MANUAL

Tab 1 = Database - On this tab you have two options either create a new database or use an existing. A extention of either ".sdf"(Sql Server) or ".cdb"(Access) must be supplied, if it is not a error message will appear reminding you. Type in the full path and name of the database and then either hit create or apply. This will store the path and database name in an ini file and load this info into the combo box the next time you use the program. If you try and hit one of the other tabs before you either apply or create a database it will keep you on the database tab. Once a database is created or applied it will show up as the "Current Active database".

Tab 2 = Tables - This tab will show you all the tables in the database in a treeview. When clicking on a table name it will expand showing all of the available columns. Upon clicking on the column name the properties of the column will be displayed. The treeview once loaded will not refresh until the "Refresh" button is pressed.

Tab 3 = Query - Here you may type in any valid TSql for sql server ce/Access and execute it. You may have multible sql statements in the window, but must then highlight the statement you wish to execute. The "Load" button will bring up the common dialog box and allow you to input a sql text file. The file must be in the "My Documents" directory or any of the subfolders below it. The "Save" button will save whatever is in the query window to the "My Documents" folder or any sub folder. Once you have executed a sql statement a messagebox will appear saying the records have been loaded, you will need to go the the "Results" tab to see them. If the statement does not return a recordset a messagebox will appear that the statement was sucessful. There is also a copy and paste buttons that use the clipboard. NOTE: There seems to be a bug in adoce or my code that if you try to bring back a table or query that has a 1000 rows the device never seems to come back. It does seem to be more a device or ADOCE problem, not sure if it due to memory or what. In debug it will hang at the recordset open method.

Tab 4 = Results - All queries that return records are loaded here. If you click on a column in the grid it will expand in size, if you click on it again it will revert to the default size. The "Export" Button will download the grid in a "tab" delimited text file.

Tab 5 = About - This just gives you an email address if you have any feedback for me.