|
|
|
| Revision | Details |
|---|---|
| v1.07 | Added option to the preferences dialog to allow partial memo text to be displayed instead of <MEMO> - this is also useful when printing reports. Lookup/Help table names can be left blank instead of specifying another table (also a comma may be used instead of a space before field modifiers/copy-down flags). When the table name for the lookup is left blank, a new table 'zPsiDatLookup' is created to hold the information. It's also possible to add new items to this table by typing new text in the calling table (though to do this with Lookups it is necessary to enter the field in edit mode using the cursor keys from an adjacent field). This facility should only be used for small numbers of lookup/help entries - especially if there are many fields in the database that make use of it. Added Export to Idealist Natural Format Added Export to Lotus Notes Structured Text. Added Export to HTML Improved fieldname and tablename error handling. Modified the manual editing of Lat/Long modified real numbers so that you can enter eg. 51º30'35.6" as :- 51 30 35.6 or 51º30.5' as:- 51 30.5 To enter West or South coordinates you must add a '-' sign before the first figure. Added 'Use Special Formats' to the options menu. This defines whether the <YN>, <TF>, and Lat/Long modifiers are used in the display and during text exports. The feature can be temporarily switched on and off in the export dialogs. Added the last filename to the INI file so that PsiDat defaults to this in the 'Open Database' file selector. Improved DBase import and Export routines. Support for 850-1252 and 1252-850 codepage conversion is now included. Added check on whether user has tried to export a dBase IV table without any memo fields so that option to use dBase III is given before proceeding (many PC databases fail to load these otherwise correctly-specified files). Added support for LongBinary fields. These can store entire files and are handled as follows:- EPOC picture files (MBMs) have their own built-in viewer which switches to the correct screen mode. This is pen- and cursor-enabled. The Esc key exits. It is also possible to Launch these files if another application has a file recogniser for them. Word, Sheet, Data, and OPL .OPO files are recognised and launched quickly. Record files are similar but also have an option just to play the sound. This enables the sounds to be played quicker and also allows the Revo to play sound files even though it doesn't have the Record program. Other files can be launched by the system if they have recognisable UIDs or file recognisers. Any type of file can be stored and restored. Added Calculation option to the Text field properties although this is currently limited to concatenation. Added a demonstration database (ObjectExamples) to illustrate the use of LongBinary fields. |
| v1.06 | Fixed bug that prevented a field being added when a table was restructured. |
| v1.05 | Added option to switch off sounds. Added DateTime field modifier <MOD>. This causes the field to always reflect the datetime of the last recalculation (ie. effectively it is a 'Record Last Modified' datestamp). Fixed bug in report printing when centimetre unit was used. Fixed major bug in the reading of indices that meant they were always read in ascending order. Unfortunately the bug extended to their creation as well which means that indices meant to be ascending were descending and vice-versa. The downside of this fix is that it will be necessary to delete and remake any ascending index. The upside is that browsing tables with indexes is now much faster. Revised the 'Add Index' dialog to make it clearer where the user is in the creation process. Added option to perform a full recalculation of all records in view during a 'Show Summary Values' or while printing reports. Added Import Text option. Added ability to restructure text field type to datetime type with intelligent analysis of format. Modified the table selection process so that default tables do not affect the selection when adding/deleting indexes or deleting tables. Added option to manually resize the memo buffer. This isn't required when reading existing memo fields but can be useful when you want to paste in large amounts of text. Enabled <PgUp>, <PgDn>, <Home>, and <End> keys to move up and down the fields. |
| v1.04 | Tidied up the display when switching tables. Fixed bug in report title when loading report. Tidied up the Change Table selection dialog so that it defaults to the current table. Added field display modifiers <DMS1>, <DMS2>, <DMS3>, <DMS4>, & <DMS5> to the Latitude/Longitude (Double Real) fields to match the options in RealMaps Eg. for a latitude of 35.96160 degrees:- <DMS1> means display as 35.96160º <DMS2> means display as 35º57.70'N <DMS3> means display as 35º57.696'N <DMS4> means display as 35º57'41"N <DMS5> means display as 35º57'41.8"N |
| v1.03 | Modified the way that DateTime field values are used in calculations. This allows proper calculations to one second accuracy for DateTimes within 65 years of 1/1/1970 and to 60 second accuracy for DateTimes over 65 years adrift of that date. Enhanced the restructure routine so that it can convert datetime fields to text or numeric values. Added a lottery number generator to the demo files - I never play the lottery myself but many people do and it makes a good demonstration of the new features introduced in v1.03 Added <TF> and <YN> as options for the 'Bit' field type. If the option <TF> is used, 0 or null values display as 'FALSE' and 1 displays as 'TRUE'. Similarly the <YN> option displays as 'YES' and 'NO'. Also added the feature that you can enter the Bit field value of 0 with any word beginning 'f','F','n', or 'N' and the value 1 with any word beginning 't','T','y', or 'Y'. Increased the available size of the calculation/special field again, this time up to the maximum of 255 characters. This increases flexibility, but some caution is required:- When a calculation field is processed, it creates a new string for the EVAL function to operate on containing the actual values of the fields used. If the new string length exceeds 255 characters then the calculation will not be processed. Added a RANDOMIZE statement based on the current time to the recalculate all fields function. This makes the Dice application much more useful. Added 'Latitude' and 'Longitude' options to the special use categories for floating point variables. These take their values from RealMaps external file support so they can be obtained from a GPS reading or by locating a position on a map and pressing Enter in RealMaps. Added the facility to save SQL query strings in a system table 'zPsiDatQueries' so that they can be recalled into the SQL search dialog. New queries can be saved from here as well ; if you try to save another copy of the same query then you are given the option to delete it from the pick list. Altered the logic slightly for opening and closing databases and tables. Ctrl-X closes a database and Ctrl-O can be used to change the current table within the current database. Fixed bug in the restructure routine that prevented a table being created in the same database file as the source. |
| v1.02 | Not released - change details shown in v1.03 |