PsiDat

PsiDat 1.23 1. To install, copy the PsiDat.SIS file over to the EPOC device and tap open it from the system screen. Alternatively, if you connect your EPOC device via PsiWin, the SIS file can be double-clicked in Windows and installation will start from there. 2. Install PsiDat.SIS before installing any PsiDat-<Language>.SIS files. 3. WebCol.SIS installs a Websafe216 palette tool for colour machines, if desired. +------------------------------------------------+ | THIS VERSION IS FOR REAL EPOC DEVICES ONLY | | ie. Series 5, 5mx, 7, Netbook, Revo, RevoPlus, | | Mako, Geofox, & Osaris | | DO NOT INSTALL ON THE WINS EMULATOR | +------------------------------------------------+ *** If you wish to install PsiDat on WINS you should download PsiDatW.SIS *** v1.23 - CHANGES SINCE 1.21 Added toolbar icons for devices with screensize 640x240 or above. Modified the Index selector so that it doesn't appear when switching to a different table (but reselecting the same table will offer the index selection) Added 'Save Def' button to the 'Show OPL Code' dialog. This saves a new database file to c:\PsiDatTableDef containing details of the tables fields and modifiers. This can be useful for documenting table designs - eg. by creating an HTML page. Added an option to show or hide the fieldnames/aliases. This uses the global variable showlabels%. To avoid confusion, this variable is always switched to true when switching tables or on startup (otherwise the user might not notice that they had switched to a subtable). This option also affects the appearance of single record HTML output. The underscore character "_" can now be used within table and field names (but must not be the first character) Modified the HTML export dialog so that the path defaults to that containing the current database. Added a keyboard shortcut for 'Show Summary Values' New PsiDat icon - reflecting the program's relational capabilities instead of the 'flat-file' rolodex-style. Improved the options dialogs so that they are more consistent and easier to add additional variables. Added option to include the current datetime at the foot of HTML exports. Added <CUR> currency field modifier for doublefloat fields. The output style can be controlled from the General Options dialog. Improved layout on Osaris Added userhelp$ variable for the user-defined helpfile. It still defaults to myfile$+".hlp" but can be altered by the userauto: routine if desired. Added custom header, footer, and meta tag options for the HTML exports. The 'Default Table' dialog can create a special table zPsiDatHTML. This table has three default entries; 'header', 'footer', and 'meta'. If the Used field is non-zero, then the raw contents of the HTML field will be inserted in all HTML exports in the appropriate place. It's also possible to create special entries for particular tables, eg. Suppose that we have a table called 'Index' that needs different headers, footers, and meta entries to the other tables in the database. three entries would be added to the zPsiDatHTML table called :- Index-header Index-meta Index-footer When PsiDat exports HTML it checks for page-specific headers first, and if none exists, reverts to the default ones. It is therefore easy to change just the meta entries or change/remove headers or footers separately. This can be used to standardise the output with navigation menus, copyright notices, CSS files etc. v1.21 - CHANGES SINCE 1.20 Added some basic field colour-coding, eg red for negative values. Added a unique decimal number generator function urn: Added a unique text key generator function ui:([#]). The current value of the field must be passed as #, eg. if used as a calculation for the first field, the field modifier function would read :- ui:([1]) It should be noted that the text field should be a minimum of 14 characters long (ideally 15 characters) and that there are a maximum of 100,000,000 unique numbers available per day. Both urn: and ui:(#) use the same counter and the integer portion represents the number of days since 1/1/1900. The decimal portion is incremented from zero each day. The numbers generated are unique (on the machine that created them) across all databases and tables, even if PsiDat is removed and reinstalled at a later date. If a database containing these numbers is copied to another machine, the numbers may not be unique, although they are within databases (unless other tables are copied/merged in). The purpose of these functions is to provide a unique key field for certain types of lookup table. ui:([#]) provides the unique key and urn: indicates a modification (which can be useful for synchronisation purposes). Added an option to specify whether <P> or <BR> is used in the HTML output for a carriage return character. This means that memos can be formatted more naturally if desired. Added a <LIN> field modifier. This causes a line separator to appear above the field name and enables jumping to a particular separator using the '.' key. When '.' is pressed, the nearest line separator is displayed and the user can select one using the arrow keys and the Enter key. Improved the restructure routine so that LongText8 (Memo) fields can convert to Text and vice versa within the limits of the text field size. Improved the dBASE imports so that badly structured headers are treated in a more robust manner. Added a standalone CSV-import option that can cope with CSV files created by applications that don't enclose all fields in quotes. This routine can also import memo fields. NB: There is some overlap in functionality between the text and CSV import routines. In general the text import is much quicker, but the CSV import can cope better with problematic files and can also handle memo fields. Modified the 'Merge In' option so that it can use CSV files as well as PsiDat/OPL tables. Added facility to explore a help/lookup file from within the popup table. Pressing the Tab key will allow the lookup table to be browsed. Pressing Ctrl-D (or tapping the "«" toolbar button) will switch back to the calling table. This feature can use up to 10 nested levels. The <NDR> field modifier can be used to switch off this ability. Added a facility to handle nested levels of sub-records. The <SUB> field modifier should be followed by the name of the sub-table. Anything after the sub-table name should be preceded by a space. The fieldnames in both parent and sub-table must match. Pressing Shift-O (or tapping the "»" toolbar button) will jump into the sub-table (child records) and Ctrl-D (or tapping the "«" toolbar button) will switch back to the parent table. The 'CustomerOrders' example demonstrates both features. Added a <LCK> field modifier to prevent numerical, datetime, and text fields being modified. This is especially useful with sub-table key fields but can also be useful to prevent tampering with <NOW> datestamps. Modified the <L2F>, <L3F>, and <L4F> modifiers so that they are no longer restricted to text fields. Fixed a minor error in the Show OPL Code routine. Altered the field properties dialog so that it uses multiline editing for the field modifiers. The label for this field is now standardised as 'Modifiers' regardless of the field type. The field properties dialog has been enhanced so that it remembers its position between calls and a linebreak now has similar functionality to a tab character. Added a flag file option for emulating smaller screen sizes. Added the <CIZ> field modifier for numeric fields. This instructs PsiDat to calculate the field only if it is empty or equal to zero. v1.20 - CHANGES SINCE 1.19 Modified the HTML option dialogs and added a simple preview option (the '?' button). This allows the colour scheme to be seen but will not show special fonts and features such as background images. Added <FONT> tag option to HTML options so that user can specify the font size and other attributes. Added extra HTML colour options. (Note for translators: there are significant changes to the category 20 resources in this version) Modified the HTML defaults so that they use the websafe 216 palette. Produced a standalone tool 'WebCol' for colour users to assist with defining HTML colours. Added two more default colour schemes and changed the call method so that it uses a choice field plus one button instead of a button for each scheme. Also added an option to copy the OPL code to generate the current scheme to the clipboard. Modified HTML export so that soft line breaks are handled correctly in normal text fields. Added <DT1>, <DT2>, & <DT3> field modifiers for doublefloat fields. These display a value in seconds as a datetime, date, or time component string respectively. Added <HNM> field modifier. This is used to seed the filename dialog for HTML single record output based on the value of this field. Also made it easier to select single or multiple (tabular) HTML output by adding a separate menu cascade item and keyboard shortcuts. Enabled a user-routine to alter the default HTML export filename just before calling the dialog. A user-defined procedure is called as follows:- userhtmlname$:(<filename>) <filename> is the PsiDat-generated default. If this procedure exists in a user's custom OPL routine then it should return an alternative filename or the <filename> parameter originally passed. This allows more sophisticated naming rules to be generated and always runs after the routine used by the <HNM> field modifier. Improved the HTML export dialog so that the linkback text and URL are retained by default until the current table is changed. Improved the quality and compatibility of the HTML output - especially with Mozilla and other compliant browsers. Added a recovery routine to cope with tables that have damaged indexes (a rare occurence but worth it) v1.19 - CHANGES SINCE 1.18 Fixed minor bug in field properties routine that prevented the correct field number being shown. Improved the datetime accuracy; it's now possible to set and obtain the number of microseconds and the calculation limits on very low and high dates have been removed. Added a 'Filename' option to the text field 'Special Use' options. This enables a fileselector when the field is tapped, allowing a filename to be selected or the field to be blanked. Resource file editors should note that resource item 181 is now deprecated and has been replaced by a new item 457. Fixed bug in listview that could cause the Data.OPX to panic if a new record has just been created in a table with an index. Improved the simple search facility so that the user can enter their own wildcards. Improved the sound-playing facility so that a sound can be cancelled by pressing a key. Improved the table lookups and split list view so that you can jump to a position by pressing the first letter of the required entry. Fixed minor bug in pen routine that could cause a subscript error if a pen tap occurred above the first field. Tidied up some problems with calculations, searches and SQL queries (including auto SQL filters) involving strings that include single and double quotes. Improved the memory handling when launching embedded files. Improved the handling of custom OPL source code when stored in the 3rd record of zPsiDatDefaults. When this file is launched, modified and translated, the option to replace it will update the .opo executable in record 2 as well as the changed source in record 3. Improved the Text export routine so that it can included LongText8 (Memo) fields. There is an additional option hidden away in the Options | General | > dialog called 'EPOC *.TXT'. When this is ticked, exported text will use &06 for lineends instead of &0D&0A (crlf) combinations. This makes it easier to export text for the standard Data application. v1.18 - CHANGES SINCE 1.17 Improved the predefined SQL Query selector so that it uses a lookup-style window instead of a dialog box. The picklist button has been changed to the tab key so that it is easier to call up the picklist. Added a split view mode. The autowidth list view is still available using shift-V but the far left screen pen action and tab key now call up a modal split-screen view. While navigating the list, the left and right arrow keys alter the field displayed. The favoured column is remembered while the table is open and a default can be set using the <SPV> field modifier. During split view, the toolbar buttons and position bar are disabled; any pen event outside the list or record scrollbar will return PsiDat to the normal card view. Added a feature so that a user-defined pattern background can be used instead of a solid colour - copy an EPOC picture named 'background.mbm' into the PsiDat application directory and it will be loaded instead of any colour selection if the 'Use Wallpaper' option is set. On greyscale machines, a 16 colour background tile will automatically switch PsiDat to 16 colour mode on startup. Added url:() and img:() string calculations to aid web page developments. Improved the handling of LongText8 fields when in editmode so that the user does not attempt editing without switching to the memo dialog. Added options for setting the preferred list view width and maximum start position for the field editboxes. Improved the 'N'ew Record keypress action so that a <NOW> DateTime or Lookup/Help with <CD> modifier escapes the dialog. Improved the lat/long fields so that if RealMaps is not running, PsiDat will attempt to obtain the NMEA data directly (at 4800 baud) instead of by polling the RM.SIG file. The <NOW> field modifier may also be used with lat/long fields to force a RealMaps or GPS read when creating a new record. Fixed a minor display bug that could occur after a table merge. Enabled user-defined helpfile: If a standard Data file 'MyFile.HLP' exists in the same folder as a PsiDat database called 'MyFile' then this can be accessed as well as the main helpfile. Added the field number to the field properties dialog title. Altered the binary file embedding dialog so that it initiates with the same directory as the database file and subsequently remembers the selected directory. v1.17 - CHANGES SINCE 1.16 Fixed minor bug that prevented the tablelist and indexlist being updated after importing text and dbase files. Tidied up the behaviour when a user attempts to open an EPOC data file that has no records. Modified the embedded file launch routine so that it is easier for the system to recognise an HTML file and launch it in the default browser. Some security has been added so that the user is warned and given the option not to run a custom OPL routine the first time it is run on their machine. Fixed problem that prevented v1.16 running properly on machines with codepage 1250 localisation patch. Altered the dialog boxes slightly when running on the Osaris so that they fit the screen better. Made it possible to force a completely blank new record (ie. ignore all <CD> and autofield modifiers) by typing Shift-N. The trailing space character on DateTime fields set to display 'Date only' has been removed. The autofiltering routine has been improved so that it works properly with Date fields on systems that use the US or Japanese date ordering (provided that the PsiDat settings match those in the control panel). The default forcing of zero times on Date fields has been restricted to those fields that use the <SQL> field modifier. A new function ParseSQL$:(string$) has been added. This is used by the SQL search dialog and allows the user to enter the following:- #TODAY#(to indicate today's date) #TOMOR#(to indicate tomorrow's date) These can be used together to filter records before, after, or on today's date, eg:- WHERE Date>=#TODAY# AND Date<#TOMOR#returns only records with today's Date WHERE Date<#TODAY#returns only records before today WHERE Date<#TOMOR#returns only records up until midnight today WHERE Date=#TODAY#returns only records with the DateTime value (Today at 00:00:00am) NB: Once the filter has been searched or applied, the SQL dialog displays the parsed SQL so if you want to save it for the picklist, this should be done before using it. Added option to use a Word file instead of a jotter file as the 'Rich Text' type for LongBinary fields (see 2nd page of the 'General Options' dialog). Improved the printing setup so that PsiDat should be able to remember the selected media. Added option to view/manually change the SQL statement for the current table OPEN statement. This is shown on 2nd page of the 'General Options' dialog. This can be used by advanced users to perform special sort views (eg. FOLDED SELECT to sort without case-sensitivity). However, if you alter this manually and get it wrong, PsiDat will crash - though it's very unlikely any data loss will occur because the table is closed normally before attempting to open the view. Enabled a basic print function that does not require a report layout to be prepared. This allows longtext8 (Memo) and MBM pictures embedded in longbinary fields to be printed as a continuous list. v1.16 - CHANGES SINCE 1.15 Fixed bug in dBase IV export dialog that prevented escape if the filename was invalid (ie. too long for dBase IV). HTML 'Back' default is now included in the resource file so that it can be localised. The filepath used for HTML exports is now maintained during a session. Buttons used in 'Create Table' dialog have been changed to make it quicker to use (ie. the tab and enter keys are used to move up and down the fields) Improved the table and index selection by using an ordered lookup instead of a dialog box. Added additional error-checking so that ordered lookups revert to unsorted ones when no suitable index exists on pre-ER5 machines. Improved reporting of record numbers - PsiDat can now report record numbers in excess of 65535 provided that the table contains at least one text field. Modified the table closure routine so that compaction of large (>500KB) databases is optional. Speeded up multiple record deletion for large databases. Made it possible to add text 'on-the-fly' to user-defined lookup and help tables in a similar fashion to the built-in zPsiDatLookups ones (limited to the lookup field only but can be useful) Lookup fields can now be manually cleared even if an empty string is not included in the lookup table. Improved the text cursor. Added a text calculation function TNStr:() that can be used to insert tab and new paragraph characters into calculated text fields. eg. TNStr:([1]^t[2]^p[3]^t[4]) would concatenate fields 1-4 so that '^t' would be replaced by a tab and '^p' would be replaced by a new paragraph character (ASCII 6). Provided a simple way of copying any text or numeric field to the clipboard by tapping it with the Ctrl key held down. Modified the new record routine so that the user is instantly in edit mode (unless the record is created from the toolbar since this may not always be desirable). Removed limit on number of 'copy-down' (<CD>) field modifiers. Added 'rollback' feature and improved use of transactions to improve memory usage on large databases. If rollback is available, it is indicated by a light (green) band behind the position indicator bar. Shift-Esc will rollback when available. NB: Use of First or Last record will commit the current transaction. Additional comments :- Rollback is not available if the table has an index. Explanation: if records are added, deleted, or revised so that their position changes, then attempting to rollback corrupts the table. (Interestingly, deleting all the indexes for the table seems to recover the database but DbRecover: fails to do the same - this looked too dangerous to try and work around so Shift-Esc on indexed tables just commits the transaction). On colour machines, incomplete transactions on indexed tables are indicated by a pale red band. COMMENTS/SUGGESTIONS TO:- psidat@millican.info