Pocket DB

Database System for Pocket PCs


INTRODUCTION
Pocket DB is a database program designed for the new generation of Windows CE-based color Pocket PCs, specifically the Casio E-115, 125, EM-500 Compaq iPaq H363XX,, and HP Jornada 54X Series. Pocket PCs. The program should also work on the other color Pocket PCs of the same category.

Pocket DB Using Pocket DB, you can create/remove new tables, indices, add/remove records on your Pocket PC. Data can be accessed under both "Grid View" and "Record View" modes. You can search for data using one of three different search modes: "Whole Field", Start of Field", and "Any Part of Field".

Advanced users can issue SQL statements directly to the ADOCE engine to have total control over their tables using joining, linking, indexing, multi-level sorting, etc. DDL (Data Definition Language) commands on table operations, index operations, and universal operations are also supported.

The Professional Edition of Pocket DB includes a desktop application called PocketDBUtils that allows you to transfer Microsoft Access tables to/from the device. Using PocketDBUtils, you can export tables and queries from Microsoft Access to your mobil device, add/edit/update the tables, and import them back to Access at a later time.

Because of the limitation of the current ADOCE version, this release of Pocket DB can only transfer tables between the Pocket PC and desktop. Synchronization is currently not supported! Hopefully table synchronization will be supported in the next release of ADOCE, and thus will be supported in Pocket DB. For now, you'll just have to remember whether a table on the Pocket PC or on the desktop was last modified so you can overwrite the older one.

  • Creates Access-compatible tables.
  • Supports direct user-defined SQL commands.
  • Supports direct editing of underlying tables in multi-joined recordsets.
  • Supports multiple table joining and linkingm using many-to-one and one-to-many relationship.
  • Exports tables from the Pocket PC's object stores or Pocket Access (.cdb) to Access 2000 on the desktop PC.
  • Imports tables from Access 97, 2000 on the desktop PC to the Pocket PC's object store or Pocket Access (.cdb).
  • Reads/Writes Pocket Access databases.
  • Imports/Exports tables from/to CSV files.
  • Supports both "Grid View" and "Record View" modes.
  • Supports 3 search modes: "Whole Field", "Start of Field", and "Any Part of Field".
  • Sorts any field in ascending or descending order.
  • Retrieves records using filter that meets certain criteria.
  • User-adjustable grid properties such as column width, forecolor, backcolor, etc.

Pocket DB Desktop Utilities CONTACT
doanc@san.rr.com
chris_doan@yahoo.com


WHERE TO DOWNLOAD?
Pocket DB For StrongARM-based Pocket PCs
Pocket DB For SH3-based Pocket PCs
Pocket DB For MIPS-based Pocket PCs
  • SH3-based Pocket PCs: HP Jornada 54X series, etc.
  • MIPS-based Pocket PCs: Casio E-115, 125, EM-500, etc.
  • StrongARM-based Pocket PCs: Compaq iPaq H36XX, etc.

HOW TO PURCHASE?

HOME
CD Software Solutions


LINKS