SIRXS 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

Fixed in revision XS.01.13 XS.01.12 Auto I/O columns in schema dialog does not work for standard vars XS.01.12 FILL and COMMA functions crash when args are missing XS.01.12 PATTERN function returns 0 or 1 when argument is missing XS.01.12 SIRSQLS sends cat vars as strings but length of internal integer XS.01.12 Seven (or more) schema VALUE LABEL commands can confuse compiler XS.01.12 VALLABSV not returning the correct value for missing strings XS.01.12 TABVRANG returns column name not range info XS.01.12 pql connect tabfile with no filename specified will crash. XS.01.12 Using spreadsheet on a Database after using it on a tabfile causes problems XS.01.12 UNIX: "Cannot Position" errors using Spreadsheet on tabfile XS.01.12 Subprocedure name from expression doesn't work using DEBUG XS.01.12 Create table with "special" name causes problems with drop table XS.01.12 BLANKUND keyword on DBI now works on DATE and TIMEs XS.01.12 PQLForms local variables do not show value labels XS.01.12 Restructured Unload & Reload can delete records without warning. XS.01.12 Large real numbers are displayed in the spreadsheet as *********** XS.01.12 Undefined and Missing are displayed the same way in spreadsheet XS.01.12 PQLForms data entry mixes up BLANK and undefined XS.01.12 Auto I/O column assignment in schema dialogs can underestimate width XS.01.12 SQL (SQLServer) can crash selecting columns from particular record types XS.01.12 Master can hang updating some record types with recnum > 127 XS.01.12 PQL LOOKUP VIA will return the next record if there is no match with the supplied keys XS.01.12 Modifying a variable in STANDARD SCHEMA can effect another variable in that schema XS.01.12 Record types with more than 99 data input lines won't export/import properly XS.01.12 PQLForms field edit clause may not trigger on leaving field XS.01.12 MERGE fails on caseless databases XS.01.12 PROMPT VARDOC added to PQLForms FIELD Command XS.01.12 Consecutive dates with different maps will be combined in TO lists if they have the same metadata XS.01.12 SPSS SAVE FILE will output junk at the end of variable labels XS.01.12 VARPUT does not work on the first COMMON variable in name order.

Fixed in revision XS.01.12 XS.01.11 New "Remove Password" option on Unload dialog XS.01.11 EVALUATE and SPSS SAVE FILE in the same program gives bad strings XS.01.11 Spreadsheet can crash on searching for a case id XS.01.11 Slow memory leak associated with switching databases XS.01.11 Memory leak in processing records with standard variables XS.01.11 VERIFY FILE with RECKEY or RECDATA crashes. XS.01.11 REGREP can not return a null string result XS.01.11 VARPOSIT function has changed XS.01.11 Compare Procfiles dialog improved XS.01.11 Negativley Scaled variables are truncated in SPSS SAVE FILE XS.01.11 SPSS Portable files do not open in PSPP XS.01.11 New Exact time map format XS.01.11 PQLFORMS, FAILSCR not allowing re-entry of bad data XS.01.11 New Required Fields dialog in forms painter XS.01.11 Various problems with undefined strings in tabfiles XS.01.11 Details button in tabfile dialog can crash if there are no tables XS.01.11 Some schema mods can corrupt CIR XS.01.11 LIST STATS restructure summary table is misaligned XS.01.11 DO REPEAT now allows leading zeros in TO list XS.01.11 The MISS function did not work on local string variables

Fixed in revision XS.01.11 XS.01.10 Tabfiles don't connect in old forms. XS.01.10 PROCESS RECORD with Secondary indexes don't work on caseless databases. XS.01.10 VERIFY FILE now returns some information to globals. XS.01.10 PQLFORMS embedded PQL can be mis parsed. XS.01.10 PRINT BACK on PQLFORMS can miss a few important lines. XS.01.10 Creating some COMMON VARS on some databases can crash on verify/unload/export. XS.01.10 Encrypted Database may have problems with some longer strings. XS.01.10 Database cannot be accessed after using encryption functions. XS.01.10 A database that can EXPORT/IMPORT and VERIFY ok can corrupt after UNLOAD/RELOAD. XS.01.10 READING a TIME VAR using input format ('HH:MM:SS') reads the seconds as 00. XS.01.10 Setting a 12Hr time to 12:nnAM sets it to PM XS.01.10 SPREADSHEET Procedure before FREQUENCIES stops the freq output XS.01.10 pb=remarks on the sirbatch execution line seems to have no effect XS.01.10 A String Common Variable can cause process journal's GET VARS caseid to fail. XS.01.10 Modifying a date's range does not dynamically restructure dates outside range to undefined XS.01.10 VALIDATE AND VARPUT will now return 7 (truncated) if there is extra info after number. XS.01.10 UNLOAD can fail after using MODIFY SCHEMA to change a range XS.01.10 EXECUTE DBMS after a case block after an process index will hang. XS.01.10 Import Records can have a problem with MS SQL Server keys XS.01.10 The "?" entry in PQLForms doesn't work on record types other than record number 1 XS.01.10 Dialog painter cannot handle control names longer than 12 characters XS.01.10 Exact date maps with MMM or WWW will not accept valid dates. XS.01.10 New CPYFILE function added XS.01.10 MASTER sometimes hangs XS.01.10 Searching a record in spreadsheet can crash XS.01.10 VERIFY FILE some options can crash. XS.01.10 An EVALUATE in a PQL program can effect the output of SPSS SAVE FILE XS.01.10 D0 and F0 I/O formats read and write data differently XS.01.10 The DYNAMIC keyword on OPEN does not compile

Fixed in revision XS.01.10 XS.01.09 Adding or deleting key fields from an existing record can be difficult. XS.01.09 VALIDATE and VARPUT accept non all-numeric strings into numeric variables. XS.01.09 DYNAMIC Subroutines can lose their place in record processing. XS.01.09 BATCH DATA INPUT with no NOAUTO and a data list with missing I/O columns missreads input. XS.01.09 PQLFORMS painter gets font attributes passed to subsequent variables. XS.01.09 TABFILE JOURNAL not working. XS.01.09 The CREATE UNIQUE INDEX command from SQL doesn't create the index. XS.01.09 PAD with negative length parameters crashes sir. XS.01.09 Duplicate value label value. (Warning 784 - ... value 0) on processing some schemas sorted by variable. XS.01.09 A strange date appears in SQL output.

Fixed in revision XS.01.09 XS.01.08 Redimentioning an array to a negative size can crash. XS.01.08 Automatic column assignments in record schema dialog can be too wide. XS.01.08 Using VARIABLE LIST & INPUT FORMAT can produce strange data list formats. XS.01.08 Leaving a key field out of the DATA LIST in schema can cause problems. XS.01.08 Processing Journal records can crash. XS.01.08 Recursive subroutine and process record with index finds one record. XS.01.08 ENABLE TIMER will now work in menu programs. XS.01.08 Global positional parameter substitution fails with null arguments. XS.01.08 CAT VAR in CIR can crash sir on compiling the schema.

Fixed in revision XS.01.08 XS.01.07 VALID VALUES, and CAT VAR lists can become zeros after unload reload XS.01.07 Quick Report centres header on a default page width of 4096 XS.01.07 PQLServer does not work between different machine types XS.01.07 Attribute not recognised on WRITE (attrib) ... XS.01.07 LOOKUP affects apparently unrelated local variables XS.01.07 BATCH DATA INPUT to a CASELESS Database with CSV input will corrupt the database XS.01.07 Handling of partial entry fro Date Data can cause miscoding. XS.01.07 When an invalid value is entered in a PQLForms field then the user cannot leave the field until it's fixed XS.01.07 VFORMAT returns internal size for integers, External format for others. XS.01.07 DBMS SET CENY yyyy and execution parameter CENY=yyyy effect later sir sessions XS.01.07 Tabulate under Procedures menu fixes XS.01.07 Graph under Procedures menu crashes when output type is GRAPH XS.01.07 GET LINE FROM BUFFER into an expression will crash SIR XS.01.07 "Skipping to next /" warning on importing old files XS.01.07 DELETE STANDARD SCHEMA will crash XS.01.07 Procfile reverts to original after a program that does a connect database. XS.01.07 Batch data input LOGFILE writes XXXX for error number XS.01.07 master & journal rollback will corrupt database XS.01.07 VALIDATE & VARPUT inconsistant on date and cat var undefined values XS.01.07 PQLForms EDITIN on first field won't move off the field when exiting record XS.01.07 SIRxs Journal Processing start and end options not working XS.01.07 Master and process record onetime can give an error after retrieval XS.01.07 Master and process record onetime can give an error after retrieval XS.01.07 ww yyyy datemap sets year to 1583 XS.01.07 New "exact" datemap feature added XS.01.07 File dump can crash in some circumstances. XS.01.07 Second and Third missing values can disappear from a database after unrelated schema mod XS.01.07 too many fields on a page in forms can cause painter to autopage.

Fixed in revision XS.01.07 XS.01.06 SERADMIS(1,1,"") wraps the {name}; SERADMIS(1,0,"") doesn't wrap but pads the name with ascii 0: XS.01.06 system(2) return values not documented: XS.01.06 the default timeout for master is set at 5 but using the spinner you cannot get below 10 XS.01.06 odbc gets its timeout values from windows\sir.ini not "my documents"\sir.ini XS.01.06 SIR will crash if too much array space is requested XS.01.06 Multiple minitab save file from the same retrieval give error opening a scratch file XS.01.06 sirsql server log and sir logfile can now be viewed while active. XS.01.06 There is a problem with the argument list functions when used on strings XS.01.06 varput and validate give a return code 7 when a string is truncated XS.01.06 Some help buttons in pqlforms painter do nothing XS.01.06 PROCESS RECORD x VIA ({Special_Name}) gives compile error. XS.01.06 SYSTEM SECURITY command gives a confusing error if not DBA XS.01.06 VERIFY File can hang after patching some types of correctable errors XS.01.06 Correctable verify errors can occur after index block splitting.

Not Yet Fixed XS.01.10 Cannot use Find on Tabfiles in Spreadsheet XS.01.06 Timeouts cannot be set for PQL client to PQL or SQL Servers XS.01.06 There should be an easier way to adjust sir odbc timeouts when the odbc driver is installed without sir. XS.01.06 sir odbc does not work with crystal reports XI. XS.01.06 PQL Forms will not lock users out of records if they are being modified by another user.