SIR2002 Software Problem Reports This listing shows software problem reports and enhancements ordered by the revision number that the problem was fixed in. The details show the revision where the problem was discovered. Enhancement Minor Major Fixed Feature Not fixed Not reproduced

Not Yet Fixed 2002.20.37 Secondary index problem on Solaris

Fixed in revision 2002.20.37 2002.20.36 Database Properties on Databases dialog enabled when there are no DBs connected 2002.20.36 Problems reading missing and valid values from tabfiles. 2002.20.36 Regular expression added to search member dialog 2002.20.36 Arrays are included in summary table, DEFINE PROCEDURE VARIABLES NOARRAY/ARRAYS has no effect 2002.20.36 PQLForms Painter produces bad code if last field on a screen is NOPROMPT. 2002.20.36 New databases are not fully Initialised.

Fixed in revision 2002.20.36 sir2.3 Very old SQL problem can effect ODBC access to SIR I*1 variables with large valid values. 2002.20.35 Statement must appear in PROCESS CASE/CASE is block. (Error 471) after indexed record access. 2002.20.35 Internal GUI editor puts odd characters when inserting a FILE/MEMBER etc (Unix only) 2002.20.35 Internal GUI editor jumbles inserted text if text is selected in the control (unix only) 2002.20.35 Dialog choice controls have a blank first entry and so return a result one more than expected (Unix) 2002.20.35 Old quirks with semicolon multi-statements fixed 2002.20.35 VERIFY FILE / RCF could not print record numbers with more than three digits (wrote XXX instead); 2002.20.35 Batch jobs updating through master can occasionally time out and terminate. 2002.20.35 Error 1 occasionally returned when running under master. 2002.20.35 Processing records by index and updating can result in a loop; 2002.20.35 Secondary Indexes can become corrupt after much master updating 2002.20.35 Times can be displayed incorrectly in the spreadsheet 2002.20.35 CIRs added through the spreadsheet interface display an error message 2002.20.14 RECORD SCHEMAS with no DOCUMENT command can inherit the database document after modification

Fixed in revision 2002.20.35 2002.20.34 Secondary Indexes lost after reload where procfile already exists 2002.20.34 Some database choice lists on dialogs can become confused after db connection/disconnection.

Fixed in revision 2002.20.34 2002.20.32 compiling PQLFORMS NEXT FIELD command in key fields can crash sir 2002.20.32 SIR will crash on CSV SAVE FILE when labels (L) format applied to variables with no labels defined 2002.20.32 Master can crash when writing some record types. 2002.20.32 Exporting data from the grid control to csv file is limited to 256 character width. 2002.20.32 INTEGER*1 ARRAYs with odd numbers of elements can sometimes effect the next array. 2002.20.32 A boolean referencing a common variable in a PQL Procedure can fail with Error 239 2002.20.32 Intermittent master crash 2002.20.27 bitmap memory problem under windows 2003 Server. 2002.20.15 Copying text from main window, starting external editor and pasting will hang editor.

Fixed in revision 2002.20.33 2002.20.32 JUMPing out of a PROCESS RECORD ..INDEXED BY ... block can cause problems 2002.20.31 Extra stats produced when a RETRIEVAL UPDATE UPSTAT is called from a PROGRAM with EXECUTE DBMS

Fixed in revision 2002.20.32 2002.20.31 Secondary indexes can become corrupt after adding cases 2002.20.30 Secondary indexes can become corrupt after some data entry through master 2002.20.30 Search facility added to record schema variable dialog.

Fixed in revision 2002.20.31 2002.20.30 Reload after database restructure fails 2002.20.30 General problem reusing scratch files 2002.20.30 Reading text files can sometimes fail at end of file. 2002.20.30 Journal Upload dialog only provides input for one update level

Fixed in revision 2002.20.30 2002.20.28 General problem reading text files over 2Gbytes 2002.20.28 JOURNAL DOWNLOAD fails on some strings 2002.20.28 EXIT REC in PROCESS RECORD INDEXED not unlocking current record 2002.20.28 New function MEMINFO gets status of a member 2002.20.28 Compiled member status added to member info dialog 2002.20.28 Form Painter allows nodata 2002.20.28 Form Painter allows prompt and data to be on different lines 2002.20.28 Reload Dialog can be tediously slow to initialise 2002.20.28 Internal GUI editor can crash if file/member is write locked

Fixed in revision 2002.20.29 2002.20.25 PQL under master can give spurious execution error 0001 2002.20.25 ONETIME option with secondary index processing not working 2002.20.25 VIA for secondary index processing under master not working 2002.20.25 PREVIOUS for secondary index processing under master not working

Fixed in revision 2002.20.27 2002.20.25 Master update records with indexes, failed to unload & reload 2002.20.25 Windows version debugging routines effected performance 2002.20.25 Merging caseless database problems 2002.20.25 RECODE schema command failed on string variables

Fixed in revision 2002.20.25 2002.20.24 Gui Editor go to line number not working on unixes 2002.20.24 Gui Editor Run then Exit doesn't prompt to save changes 2002.20.24 Edit in the Buffer dialog doesn't work 2002.20.24 Journal Download from menus doesn't start download 2002.20.24 SQL Save command to database member fails 2002.20.24 Spreadsheet does not work with categorical key fields 2002.20.24 Master can crash if given several incompatible locks 2002.20.24 Increasing max record count from < 123 to > 123 then adding a record can corrupt DB 2002.20.24 Linux file 2gb filesize limitation 2002.20.24 SIZE clause on GRID command fills rows that should be NULL with numbers 2002.20.24 Frequencies with FILENAME output gets double Page Headers 2002.20.24 Unload dialog does an itemize of the previous unload to fill in dialog defaults 2002.20.24 Problems creating the first member in a family using dialogs in unix 2002.20.24 Forms/SQL fail to increase index level when required

Fixed in revision 2002.20.24 2002.20.23 RELOAD command fails when a update level over 32,763 is specified 2002.20.23 SQL TABFILE Export splits real numbers and fails import 2002.20.23 SIR SAVE FILE calculates width from internal size; import then changes internal size 2002.20.23 FILE DUMP from the menu did not execute on pressing OK 2002.20.23 MERGE can result in bad record counts (fixable by verify /patch) 2002.20.23 SUBSET will produce a bad unload file 2002.20.23 Some export files with ACCEPT/REJECT RECS give error on batch import 2002.20.23 PQLForms will not compile on caseless database 2002.20.23 A PQL Procedure will reseed the random number generator 2002.20.23 SQL BREAK will fail on some string variables

Fixed in revision 2002.20.24 2002.20.23 SQL Select Database paths ignored on Solaris 3 3

Fixed in revision 2002.20.23 2002.20.22 KeyHelp crashes in SirForms 2002.20.22 Internal GUI Editor crashes on files over 32,768 bytes (windows 9x only). (there is a limit of 64k in this editor on windows 9x) 2002.20.22 SirSQLs not processing tabfiles in Update mode properly. 2002.20.22 Secondary index problem with unique indexes & missing keys. 2002.20.22 PURGE a connected database then there will be no default database and SYSPROC becomes the default procfile. 2002.20.22 PURGE SIR FILE will terminate command execution if source is a MEMBER 2002.20.22 UNLOAD Unloads default procfile rather than database procfile. 2002.20.22 PQL FORMS Field allows only one error clause. 2002.20.22 PQL FORMS Field readonly option puts focus to exit button, not next editable field. 2002.20.22 Cannot reload an unload where the update level is over 32,764 2002.20.22 Cannot use the UPDATE= option on reload where the update level is over 32,764 2002.20.22 DELETING many INDEXED RECORDS can leave remaining records unindexed 2002.20.22 SPREADSHEET crashes if record displayed includes TEMP VARS 2002.20.22 Standard output in CGI does not show tags (but interprets them) 2002.20.22 Standard output in CGI is double spaced 2002.20.22 FREQUENCY procedure output two heading lines 2002.20.22 CGI write with / (new line) duplicated earlier lines 2002.20.22 database EXPORT wrote common vars in external format (eg I,10) (writes internal format (eg I*4)) 2002.20.22 tabfile EXPORT (SQL) sometimes split escape quote ('') across lines 2002.20.22 tabfile IMPORT (SQL) gave error about disjunct ranges (now gives warnings) 2002.20.22 PQLFORMS READONLY option on a field causes focus to be lost and can crash. 2002.20.22 PQLFORMS crashes Tab or Click to sort field clears value from CASE ID field. 2002.20.22 PQLFORMS crashes if no sort id is entered and no records exists. 2002.20.22 PQLFORMS Fields with labels don't show null label where appropriate (unix only)

Fixed in revision 2002.20.22 2002.20.21 PQLFORMS subroutine + update options not working together. 2002.20.21 Spreadsheet Boolean ignored where rectype = cir 2002.20.21 Spreadsheet with date keys and new date map containing single D & M fails 2002.20.21 Manual DIFFERENCE FILE COPY under master corrupting database 2002.20.21 Redefine array problem fixed 2002.20.21 Using Secondary indexes in PQLForms 2002.20.21 Long prefix problem on recent database open list fixed 2002.20.21 SQL CREATE UNIQUE INDEX crashes on Solaris

Fixed in revision 2002.20.21 2002.20.20 SET command sets array elements as they were originally defined (sized) rather than as they were most recently redefined. 2002.20.20 SECONDARY INDEXES enhancement to error message Attempted to add duplicate entry to unique index - show index values. 2002.20.20 SECONDARY INDEXES not initialised properly in pql - first entry not indexed. wa rebuild index after first data added

Fixed in revision 2002.20.20 2002.20.19 PQLFORM fails on catvars 2002.20.19 PQLForms field level processing only done when operator presses ENTER

Fixed in revision 2002.20.20 2002.20.19 SAVE TABLE crash 3 32

Fixed in revision 2002.20.20 2002.20.19 New keyword NOMAXKEY on EXPORT command 2002.20.19 SEPARATOR keyword added to CSV SAVE FILE summary procedure 2002.20.19 dates in forms/sql fail 2002.20.19 SIRWEB.CGI looks for an variable "Content" and uses its value in the content-type header 2002.20.19 Connecting tabfiles with files containing blanks in file/folder names. 2002.20.19 VARNAME & VARNAMEC (0,1) in caseless database fixed to return undefined not "********" 2002.20.19 Switching databases in PQL + pql Lookup fixed 2002.20.19 Journalling under Master fixed 2002.20.19 new Separator option in CSV save file: CSV SAVE FILE ... [/separator="single_character" | TAB ]

Fixed in revision 2002.20.19 2002.20.18 Running a precompiled form fails 2002.20.18 GET VARS ALL on PQL Lookup fails to get strings. 2002.20.18 PQL Lookup must be in case block error. 2002.20.18 Fixed deleting fields in forms painter 2002.20.18 ODBC import csv files and should work with table owners too. 2002.20.18 IN A CASELESS DATABASE, VARNAME[C](0,1) RETURNS "********" 2002.20.18 FORMS LOOKUP VIA hangs 2002.20.18 GRID SOMETIMES DISPLAYS DATES AS D/M/YYYY (EG 0/0/2002 FOR 20 OCTOBER)

Fixed in revision 2002.20.18 2002.20.16 find in spreadsheet not working 2002.20.16 Display non-existent variable in PQL Debugger crashes 2002.20.16 Problems with LABELS on PQLForms 2002.20.16 LOOKUP dbname.recname format doesn't compile 2002.20.16 Strings longer than 32 characters in secondary index not working properly 2002.20.16 REAL numbers in secondary index not working properly 2002.20.16 UNLOAD deleted secondary indexes on source database 2002.20.16 DATABASE IS block without case/record commands did not restore properly after END DATABASE 2002.20.16 PQLForms Painter fixes & enhancements

Fixed in revision 2002.20.16 2002.20.15 Creating a tabfile index can fail and leave scratch files open 2002.20.15 Tabulate labels can have one extra random character~ 2002.20.15 Entry in PQLForms can jump to the next page entering data near the bottom of a page

Fixed in revision 2002.20.15 2002.20.14 PQL OPEN /APPEND Creates a new file 2002.20.14 dialog/ form painter new 'Space evenly' option added 2002.20.14 warning about multiple values for the same label 2002.20.14 new SET ITEM FONT id,bold,italic,underline,size,fontname 2002.20.14 SIR SAVE FILE writing bad file. 2002.20.14 Remove limit on number of text files opened at the same time. 2002.20.14 Cannot change Read-only attribute on text in dialog painter 2002.20.14 Cross record functions (SUMR, etc.) do not work with PROCESS REC ... INDEXED BY. 2002.20.14 PROCESS RECORD AFTER (0) does not work when the key is an AUTOINCREMENT type. 2002.20.14 If a subroutine aborts and it is more than one level deep in subroutines, SIR2002 crashes. 2002.20.14 EXECUTE DBMS does not work in a RETRIEVAL 2002.20.14 Switching databases through menu system doesn't work 2002.20.14 Multiple CASE blocks in a retrieval update can result in error -3039