The APPX 4.2.3 Patch Release addresses the following items:

• Bug # 93: Toolbox is not accessible from Data Dictionary
• Bug #272: F8 sometimes won't end Main Menu
• Bug #358: REFRESH statement does not send widgets to client
• Bug #383: Cosmetic Query Process Level display bug
• Bug #422: --- STREAM CLOSE returns failure for 'pipe' stream
• Bug #427: Java Client 0AD Tools and Utilites Menu Process pulldown needs work
• Bug #437: Java 0AD File Design level has no Toolbox button
• Bug #447: File Chooser steps on field contents during folder drill down
• Bug #548: ILF Search & Replace fails on KEY portions of I/O commands
• Bug #564: Some 0AD Process PullDown descriptions are less-than-perfect
• Bug #577: Current Query Des. Sel. Rel. hidden by SCAN indicator in ADD/CHG
• Bug #660: GUI Title Bar disappears
• Bug #678: Image Editor Item Display (F11) needs Page X of Y as per java client
• Bug #732: Full re-install of JC b9 over writes some Advanced options in .ini
• Bug #743: AppxdSvc Always Logs
• Bug #760: Tabbing through multi-row fields requires hitting tab twice
• Bug #774: Hard to Get Item Help - Impossible in Option 98
• Bug #784: Keyboard Buffer does not work
• Bug #802: Convert Images Utility is virtually useless
• Bug #804: CNV PORT is missing from ILF Editor Statement SCAN
• Bug #835: 'This record already held by another user' unexpectedly encountered
• Bug #837: Output Image Editor displays row of = 's as gray bar
• Bug #842: DD Toolbox Missing 'Convert to Domain' & 'Copy'
• Bug #851: 30 column scan fails
• Bug #863: REWRITE statement returns T but doesn't really rewrite
• Bug #882: 0SA APPL ALLOW DESIGN - No longer works
• Bug #884: REFRESH TEMP 80 is broken
• Bug #891: Focus remains on date chooser button
• Bug #892: FLEP Problem with Cache Priority 1
• Bug #898: Using a cached file as the PCF can cause crashes
• Bug #906: Mod logs don't display occurrences correctly
• Bug #907: Mod logs show deleted record values in wrong column
• Bug #914: Scanning on field name too restrictive
• Bug #915: 'guilook' defaults differently, can't change it.
• Bug #925: End of Process (Query Setup) EP does not always run
• Bug #930: Access to Designer Rights
• Bug #934: Constrained Read silently skips records
• Bug #935: Date Chooser Returns Blank Date
• Bug #947: HELP loses changes if you edit twice
• Bug #950: REFRESH TEMP 80 in Output aborts Output
• Bug #963: Can't select by keyboard on single-field-display file scans
• Bug #975: RESTORE statement hangs if scanning on 'DEFAULT RECORD' field
• Bug #976: F1-F12 not working on text fields
• Bug #978: -windowTitle= command line argument ignored
• Bug #997: PgUp and PgDn in SCAN for Process Name oversteps processes
• Bug #998: GUI destroys alpha field content if multiple '= ' characters are contained
• Bug #1006: Print On Screen - Option 7 No longer works
• Task #111: Implement new Unix/Linux Connection Manager

Bug # 93: Toolbox is not accessible from Data Dictionary

• The Data Dictionary toolbox, which contained such utilities as "Convert Field to Domain" and "Copy Fields", was not visually accessible. This has been fixed.

Bug #272: F8 sometimes won't end Main Menu

• It was sometimes necessary to click on "Exit" from the APPX Main Menu, rather than just pressing F8 (or ESC), to exit APPX. This has been fixed, as part of the major reworking of keyboard handling for type-ahead issues.

Bug #358: REFRESH statement does not send widgets to client

• When a REFRESH statement was executed, field values were being sent to the screen but widget records were not. This has been fixed.

Bug #383: Cosmetic Query Process Level display bug

• The first two records of the Query Process scrolling image appeared 'within' the box of the header frame.
• This has been fixed.

Bug #422: --- STREAM CLOSE returns failure for 'pipe' stream

• This has been fixed.

Bug #427: Java Client 0AD Tools and Utilites Menu Process pulldown needs work

• The 'Utilites' and especially the 'Tools' menus contained enough optional children that having a Group specification of the Optional Child label would not be a luxury.
• This has been fixed.

Bug #437: Java 0AD File Design level has no Toolbox button

• Toolbox was accessible only through opt-1
• This has been fixed.

Bug #447: File Chooser steps on field contents during folder drill down

• This has been fixed.

Bug #548: ILF Search & Replace fails on KEY portions of I/O commands

• ILF Editor didn't find values in the key space of a READ, READNEXT, or BEG READ statements.
• User also couldn't manually change those values when in his ILF Search&Replace.
• Search & Replace also failed on the right side of an IF statement, but that could be manually corrected, and the Search & Replace continued.
• This only seemed to happen when the 'new' string is shorter that the 'old'.
• This has been fixed.

Bug #564: Some 0AD Process PullDown descriptions are less-than-perfect

• Documentation Process Pulldown : 'Summary' and 'Detailed' presumably refer to Domains
• This has been fixed.

Bug #577: Current Query Des. Sel. Rel. hidden by SCAN indicator in ADD/CHG

• There was about one cell too little allowed for the 'Rel' in this scrolling display.
• This has been corrected.

Bug #660: GUI Title Bar disappears

• An INPUT process' Frame-Size-Rows of less than the default of 21, caused the GUI (Window Properties) Titlebar-Options 'Title' attribute to not display a titlebar at runtime. This has been fixed in Java client release 4.2.2c.

Bug #678: Image Editor Item Display (F11) needs Page X of Y as per java client

• (From Bruce Johnston:) I was going to complain that the scroll bar doesn't appear on the displayed frame until I remembered that it's NOT a scrolling window but rather a display with 10 modifiable occ. of the info on each line.
• No need to complain - it has been fixed.

Bug #732: Full re-install of JC b9 over writes some Advanced options in .ini

• After a full uninstall and re-install, the caret color, which had been set to red, went back to black even though other default in the .ini retained my custom values.
• This has been fixed.

Bug #743 - AppxdSvc Always Logs

• You can adjust the logging parameters by setting three registry values:
  LogServiceDir - set to the name of a directory and AppxDSvc will write the log there (in a file named $(LogServiceDir)\serviceName.log
• LogAllEvents - set to 'Y' to get a complete log or any other value to disable most log messages. The default is 'N' so you should be seeing very few message written to the log
• LogCreate - set to 'Y' to create a log file or any other value to disable logging. The default is 'N' (starting with 4.2.3 - it defaulted to 'Y' before release 4.2.3).

Bug #760: Tabbing through multi-row fields requires hitting tab twice

• If tabbing to different fields on an input and you came to a text or alpha field that had multiple rows, you had to hit the tab button twice to get to the next field. This has been fixed in Java client release 4.2.2c.

Bug #774: Hard to Get Item Help - Impossible in Option 98

• It has alwyas been harder to get Item Help with the Java Client. In particular, in Inquire Mode and non-modifiable fields.
• Bug 1 - The Java ? does not seem to get Item Help when the fields are non-modifiable! The mouse method seems to work well on a modifiable field.
• Bug 2 - The work around, Turn off GUI Interface, still works on a simple scroller, but when you pop Audit Info (you can see this in the Process scroller) you cannot get the cursor over to a field to get Help!!
• The prior work around was to exit the GUI Mode and move the cursor around; that did not work any more!
• This has been fixed.

Bug #784: Keyboard Buffer does not work

• The old keyboard buffering problems have resurfaced. Looks like there is no keyboard buffered at all; typing very fast, lots of keystroke after each other, results in loss of arbitrary keystrokes...
• This has been tightened up significantly for 4.2.3. Please report any new instances as new bugs.

Bug #802: Convert Images Utility is virtually useless

• When you attempt to Convert Images, APPX requires that the target exist. Does this mean that I have to create all of my output processes first with dummy target images in order to be able to use this utility?
• Corrected in 4.2.3.

Bug #804: CNV PORT is missing from ILF Editor Statement SCAN

• This has been fixed.

Bug #835: 'This record already held by another user' unexpectedly encountered

• This occurred only in the DISAM environment
• When returning to the parent process from the child process, APPX encounters the following errors:
  • ERROR - Record Not in File
  • This record already held by another user
• When running with APPXIO instead of DISAM, these errors are not encountered. There were no other users or sessions running the same database.
• This has been fixed.

Bug #837: Output Image Editor displays row of = 's as gray bar

• A row of equal signs should display as such at design time, not as a gray bar (which is an auto-GUI feature at runtime for an input). It does print as a row of equal signs.
• This has been fixed.

Bug #842: DD Toolbox Missing 'Convert to Domain' & 'Copy'

• The toolbox options to convert a field to a domain and to copy fields are not available on the menu bar or buttons in the data dictionary.
• Fixed for 4.2.3.

Bug #851: 30 column scan fails

• When scanning on a field that uses NSCAN (30) the user receives an Appx ILF error on a DEFINE statement for --- ENTRY KEY FLD VAL ZI. This has been fixed.

Bug #863: REWRITE statement returns T but doesn't really rewrite

• This occurred only in the DISAM environment.
• REWRITE of PCF record in 'footer' frame of update process returns a T indicating success but the record is not really rewritten.
• This has been fixed.

Bug #882: 0SA APPL ALLOW DESIGN - No longer works

• In 4.2.2 the new feature allowing changing of modes at lower levels allowed changes to the design as well at lower level despite the setting of the 0SA APPL ALLOW DESIGN field!
• The application chooser now shows a READONLY icon in the left column of the scrolling display for applications that are locked from changes due to the Application 'Allow Design?' flag.

Bug #884: REFRESH TEMP 80 is broken

• This is fixed in 4.2.3 client.

Bug #891: Focus remains on date chooser button

• After using the date chooser button to select a date, the cursor focus remained on the button on returning to the input image. If the user then pressed RETURN, the date chooser popup box re-appeared rather than the expected result (i.e. processing of the RETURN option by the image). Even if the user didn't press RETURN, the cursor focus was not obvious to the user.
• This is fixed in 4.2.3 client.

Bug #892: FLEP Problem with Cache Priority 1

• When the cache priority was 1 when a new sessions starts, FLEP's didn't fire for the process. This was reported specifically happening in a Job with the first step being a Query. If the cache priority was changed, the FLEP's fired. If the cache priority was changed from 2-99 to 1, the FLEP's fire as expected. This only seemed to occur if the cache priority was initially set to 1 when the session started.
• For the record, this bug would only occur when a query process EM gets tossed out of the cache and is subsequently read back in. In the replication scenario, the query setup job step loads the query EM into memory, the next job step throws the query EM out of cache, and then the 'use query' job step loads the EM again.
• You could replicate this bug at priorities other than one, but it's not easy and depends on your USER CACHE LEVEL and which other EM's are in the cache.
• Fixed in 4.2.3.

Bug #898: Using a cached file as the PCF can cause crashes

• Using a cached file as the PCF for a scrolling input process could cause various crashes. You would have to use an OPEN or CREATE stmt. in the Start-of-process event point for this problem to appear.
• The symptom varied - on a Windows® platform, the appx.stk file grows for a very, very long time. On a Linux/Unix platform, you could see a huge number of [defunct] processes spawned by the engine when the error occurs.
• This has been fixed.

Bug #906: Mod logs don't display occurrences correctly

• If the PCF for a process contained any multi-occurrence fields, the modification log entries for a CHANGE operation were incorrect. The mod log seemed to skip every other occurrence, and the values shown were associated with the wrong occurrence numbers.
• This has been fixed.

Bug #907: Mod logs show deleted record values in wrong column

• The modification log entries generated for a DELETE showed the PCF values in the 'New' column instead of in the 'Old' column.
• This has been fixed.

Bug #914: Scanning on field name too restrictive

• When scanning on the source field name of an APPEND statement, the scan list did not include ALPHA fields that are defined by DOMAINS.
• Fixed for 4.2.3.

Bug #915: 'guilook' defaults differently, can't change it

• The 'guilook' parameter defaulted differently. It used to default to 'appx', but now defaulted to something else (java?). Even worse, you couldn't force it to what you wanted by specifiying it on the command line.
• This is fixed in the 4.2.3 client.

Bug #925: End of Process (Query Setup) EP does not always run

• If a query was executed with first having executed a QUERY step in the job, the End of Process (Query Setup) EP does not run. The Start of Process (Query Setup) EP does run.
• This has been fixed.

Bug #930: Access to Designer Rights

• Even though the message 'ERROR - No Application Designer Rights' was displayed, user was able to go to change mode and make changes to an application that was manually keyed in on the App Chooser screen.
• This has been fixed.

Bug #934: Constrained Read silently skips records

• NOTE: This was originally reported as just a problem with BEG READ/END READ, but in fact it happens with any kind of child constraint.
• If task 'A' has a hold on a record in file 1 (but not the first record) and task 'B' is doing a constrained Read with Hold on the same file (e.g., an UPDATE with child constraints), the record held by the other task would be completely skipped by the Read, with no warning, error or held condition indicated.
• The problem did not occur if the first record is held, or if the BEG AT/END AT is unconstrained.
• This is similar to ECR 5166 and 662, except those reference using an Alternate key. We have found that this occurred even when using the primary key.
• This was a fairly serious problem, as the Designer could no longer count on a constrained READ to read all the records with Hold in a multi user environment. This could cause all kinds of subtle application errors, e.g., orphan records, etc.
• Fixed for 4.2.3 - Appx will now wait for locked records rather than silently skipping them

Bug #935: Date Chooser Returns Blank Date

• Clicking on the Date Chooser Icon returned a blank date.
• This has been fixed for the 4.2.3 Java client.

Bug #947: HELP loses changes if you edit twice

• If you are a System Administrator or Designer/Documentor, you can edit the Help text on the fly.
• User edited one, pressed enter to redisplay, was not content with the edits, and pressed F12 again. The first edit was lost; it reverted to the pre-edit state.
• This has been fixed in the 4.2.3 0-apps.

Bug #950: REFRESH TEMP 80 in Output aborts Output

• In the Pre-Display EP of a record frame of an output process, the command "REFRESH TEMP 80" aborted the Output, sending it to the End of Process Event Point, the second time the statement was executed.
• This has been fixed in 4.2.3.

Bug #963: Can't select by keyboard on single-field-display file scans

• When scanning on a data lookup into a file for which only one field is defined as displayable, selecting with the mouse brought back the desired record, but trying to select by using cursor arrow keys and ENTER brought back no result at all.
• This has been fixed in the 4.2.3 client.

Bug #975: RESTORE statement hangs if scanning on 'DEFAULT RECORD' field

• In the ILF editor, when adding a RESTORE statement, tab to the last field (where you would to enter DEFAULT RECORD) in order to pick 'DEFAULT RECORD' from the scan list, and press F2. APPX hangs.
• This has been fixed in the 4.2.3 client patch.

Bug #976: F1-F12 not working on text fields

• F1-F12 were not working when cursor is positioned on a text field.
• This has been fixed in the 4.2.3 client.

Bug #978: -windowTitle= command line argument ignored

• Setting the startup option for -title= or -windowTitle= is ignored.
• This has been fixed in the 4.2.3 client.

Bug #997: PgUp and PgDn in SCAN for Process Name oversteps processes

• When scanning for a process name (e.g., in design transfer), pressing PageUp or PageDown scrolled more than one page. Therefore not all processes were visible.
• This may be because there is less than a full page of processes visible, and the PgDown scrolls for a full page.
• This has been fixed for 4.2.3.

Bug #998: GUI destroys alpha field content if multiple '= ' characters are contained

• If the content of an alpha field was a series of '=' characters ('========'), the GUI represented its content as NULL (empty). If the record was stored, the field content was blanked out. If the alpha field contained a substring of '=====' characters, that substring was replaced by blank characters.
• Fixed for 4.2.3.

Bug #1006: Print On Screen - Option 7 No longer works

• Option 7 to email a report, when a report was brought to the screen, was no longer working.
• This has been fixed in 4.2.3.

Task #111: Implement new Unix/Linux Connection Manager

• Implement a new connection manager (uappxd) for Unix/Linux systems that provides for easier installation and configuration and includes new features.
• This new feature is included in APPX 4.2.3 on an "experimental" basis. User feedback is welcome.

Refer to the APPX 4.2.0 Release Notes for all enhancements and corrections built into this major release. Also refer to the APPX 4.2.1 Release Notes and APPX 4.2.2 Release Notes for items addressed by those patch releases.