PsiDat for EPOC (v1.25 release 3)

A Powerful Freeware Relational Database Management System for EPOC...

To create a database application for the Psion Series 5/5mx, Revo, Series 7/Netbook, NetPad, Osaris, & Geofox that will allow browsing and editing of all OPL DBMS data files, create EPOC databases with and without indexes, and feature good import/export of industry-standard database and delimited text files.

Specification :

• Full Relational capabilities including table lookups, one-to-many parent-child subtables; up to 10 nested levels.
  
• Opening and editing of all tables created with OPL's standard database functions.
• Auto-recognition of field names (can be overridden with user-defined aliases).
• Search functions: Basic Text or SQL
• Option to use a successful SQL query as a genuine filter.
• Save SQL queries so that they can be selected from a picklist.
• AutoSQL filters - create filtered views on-the-fly to match current criteria with a single shift-F
  
• Multiple Indexes.
• 5 toolbar buttons  (increasing to 7 when using sub-tables) on all machines including Revo. Buttons are dynamic (ie. they can respond to a pen held down instead of just standard pen down / pen up events).
• Up to 255 fields per table.
• Create tables containing all 17 EPOC DBMS field types.
• Browse standard EPOC Data files (and 'Save As' them to OPL database/PsiDat format)
• User-upgradeable system of field modifiers for defining special field properties, input/output effects, and flags.
  
• Editing of 13 Field Types :-

• Extensive Import / Export Capabilities :-
  

• * PsiDat CSV files can be easily reimported into the EPOC Data application (including memo fields).
  
• dBase III and dBase IV files (DBF) imports/export include memo (DBT) files and codepage conversion.
• Intelligent importing (ie. Text & CSV files are scanned and interpreted so that field types and names are automatically assigned)
• Comprehensive control of HTML exports in tabular and single record modes. See Example Unedited PsiDat HTML Export Pages and single record view (ideal for reports)
• Various XML export options See Example Unedited PsiDat XML Export Page 
• Calculated Fields
• User-defined opening banner for individual databases with automatic opening of correct table and index.
• Extensive Help File
• Create example OPL code for creating/opening/reading/writing tables with and without DATA.OPX (if you're an OPL programmer developing a standalone application, PsiDat can do much of the coding for you so that you can copy-paste the required source code into the program editor)
• Tabular Printing - up to 8 rows per record, gridlines, summary results.
• Summary Fields - COUNT, SUM, MINIMUM, MAXIMUM, AVERAGE
• Report Design (unlimited number of different reports can be saved for each table)
• Quick Print for any table without having to define a report (including LongText8 Memos and MBM graphics embedded in long binary fields)
• Restructuring of Database tables
• User-defined colours and background tiles
• Export field, record, or multiple records to clipboard with user-control of delimiters.
• Support for latitude/longitude information directly from an NMEA-compatible GPS (or indirectly through RealMaps if installed)
• On-the-fly additions to lookups and helps
• Storage & Launching of embedded files
• Built-in EPOC picture viewer.
• Built-in Sound Player
• Autowidth multi-column List View and Split List View :-
• User-defined menus and custom OPL routines.
• Simple password protection to prevent casual users altering the structure of PsiDat databases
• Italian, German, French, Dutch, and Spanish resource files included 
• Colour display on WINS emulator and Series 7 / Netbook

Cost :

• Freeware - Enjoy !