Pocket Database Viewer Plus 3.2 - User Guide and FAQ

• Start Desktop DBViewerPlus
• Create a new profile
• Select profile property as "Desktop to Handheld"
• Synchronize
• Use desktop or handheld database as usual
• If you made modifications at handheld end and want to transfer it on desktop then, Open desktop Profile and set "Keep Sync" property to "Handheld to Desktop" and Synchronize
• If you made modifications in desktop database and want to transfer it on handheld then, Open desktop Profile and set "Keep Sync" property to "Desktop To Handheld" and Synchronize.

Frequently Asked Questions - Pocket Database Viewer Plus

1. What is Database Synchronization Profile?
   "Database Synchronization Profile" is a link between your desktop database and handheld database. It manages, what database to keep in synchronization with handheld and when to synchronize.
   
   
2. How do I stop Desktop database & Handheld database synchronization?
   From desktop DBViewerPlus, select a profile which you want to stop from synchronization, Open profile properties and select "Do not Sync" option for "Keep Sync" property.
   
   
3. What is DSN/ODBC Database?
   DSN or Data Source Name is a way of Database connectivity through ODBC. Database Viewer Plus allows you to connect to ODBC database using DSNs available on your machine. You can create/manage DSNs on your machine. For that, Click on Config button in Database Selection dialog or on your machine, click Start->[Settings]->Control Panel->[Administrative Tools]->Data Sources (ODBC)
   
   
4. What are filters and How to Apply filters?
   While creating Database Profile, you may want to transfer only selected record contents on handheld. Here, you can apply filters i.e. condition on record contents to transfer on to handheld. Open Apply Filters dialog, Check mark the filters for those you want. Select database field on which you want to apply filter, select appropriate filter operator and enter the filter condition value. You can apply one or more filters. To apply more than one filter, you must select joining in between two filters i.e. "AND" or "OR". Remember, you must set proper filter value as per field selection. If you selected numeric field, say ID, then filter value must be numeric, say 35. For character data type filter value must be included in single quotes ('). For date/time fields, filter value must be in #.
   
   If you want, you can manually enter filter condition in SQL query instead of using "Apply Filters" dialog. In SQL query, at the end, put "Where filter conditions" by removing earlier condition, if any.
   
   Here are some examples of filters.
   
   name = 'John'
   amount >= 2000
   birthdate = #1/1/1978#
   time >= #2:10#
   birthdate >= '1-jan-1978'
   
   Note: Using # for filter conditions may change depending on which database you are using. MS Access, Excel allows to uses # where as Oracle, SQL Server allows to use single quote (') for date filter values.
   
   SQL Query Example:
   Where name='John' and birthdate > #1/1/1978# or EmpID > 15
   For Oracle/SQL Server:
   Where name='John' and birthdate > '1-jan-1978' or EmpID > 15
   
   
   
5. How to Apply Sort Orders?
   You may want handheld database contents in some particular order. Using Database Viewer Plus you can apply "Sort Orders" on record contents. Open "Sort Orders" dialog box, Select field on which to sort and select sort order either "Ascending" or "Descending". You can apply more than one sort orders at a time.
   
   
6. What are ways to connect to Excel Database?
   DBViewer Plus offers two ways to get connected with Excel Database using file browsing. When you browse a Excel file, DBViewer Plus will ask prompt with "Excel Connection" dialog, asking you to View as a "ODBC database" and view as a "Excel Worksheet".
   
   Using ODBC Excel connection, will allow you to work on user defined tables. Where as Using Worksheets will allow you work on Entire Worksheets available in Excel file.
   
   
7. What is SQL Query?
   SQL Query directs what contents from connected database to synchronize with handheld device. Using "Build Query" dialog user can select tables, fields, filters, sort orders which is summarized in terms of SQL query, which DBViewer Plus uses to fetch data. What ever changes you made on database, tables, fields, filters, sort orders etc, finally all these will get reflected in SQL query. So, if user has some SQL knowledge, he can directly modify SQL query to get expected data. Use can enter any valid SQL Select query, which may include table joining, filtering, sorting, grouping etc
   
   
8. I deleted a profile from handheld, at synchronization it gives me error "could not open handheld database". What can I do?
   Using desktop DBViewerPlus, set this profile to transfer data from "Desktop to Handheld". On next synchronization, this profile will get transferred on handheld.