(24 Pages as a zipped fully-illustrated MS Word 95 Document)
Or as an Adobe Acrobat file (thanks to David Rossall) :-
psidat-manual.pdf

(warning
: this document is rather out-of-date so some limitations
mentioned no longer apply.However, it's still a useful guide so I've
left it available)

"The freeware
PsiDat... is just about the ultimate database tool for Psion
palmtops - it can open, import and export virtually
everything, but you definitely have to know what you're
doing. Thankfully, there's some truly excellent help text
and documentation provided, plus a number of
examples...."(Palmtop
User magazine issue 2)

Aim :

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.

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).

User-upgradeable system of field modifiers for defining special field properties, input/output effects, and flags.

Editing of 13 Field Types
:-

Field Type

Calculations

User
Extensions

Notes

Bit

Yes

Logical: True/False,
Yes/No, or Male/Female

0 or 1

Signed
Byte

Yes

-128 to 127

Unsigned
Byte

Yes

0 to 255

Integer (OPL
%)

Yes

Stopwatch

-32768 to +32767

Unsigned
Integer

Yes

Stopwatch

0 to 65535

Long Integer
(OPL &)

Yes

Stopwatch

-2147483648 to
+2147483647

Unsigned Long
Integer

Yes

Stopwatch

0 to 4294967296

Single Float

Yes

Stopwatch

(Range uncertain but
larger than Long Integers)

Double Float
(OPL Real)

Yes

Stopwatch, Lat/Long,
DateTime Display

2.2250738585072015E-308 to
1.7976931348623157E+308
Lat/Long option allows coordinates to be entered in DMS as well as
displayed. Realtime coordinates can be read directly from an
NMEA-compatible GPS (or indirectly via RealMaps if installed)

Date/Time

Operand

Created,
Modified

Can be displayed as a DateTime, Date, or Time.

Text (OPL $)

Yes

Table Helps/Lookups,
Filename

'Lookups'
must match a value in the lookup table whereas 'Helps' may be used to
select a value which can be edited if desired. New values entered in
'Helps' can optionally be added to the helps available. Various field
modifiers can be used to alter the exact behaviour.

LongText8
(Memo)

No

LongBinary (File
Objects)

No

Rich Text file
(defaulting to Word or Jotter)

Can
be used for EPOC pictures and other documents. Most files that can be
opened by tapping them in the system screen can be launched.

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)