CGIWRKDBF CHANGE LOG 2022-09-30 - Now saved for V7R1 instead of V7R2. 2022-09-28 - Fixed error in displaying P fields when number of resulting digits not higher than decimal positions. 2022-09-22 - More information available on *PSSR error documentation page. 2021-12-31 - A large number of improvements on PFF-WRKDBF. 2021-12-28 - Provided an example of invoking PFF-WRKDBF from a CL program. 2021-12-11 - New Preset Filter Feature (PFF) allows to invoke WRKDBF from a WEB program in order to list database records matching a specifing field value comparison. Useful to find specific cases, like out-of-line records. 2020-08-03 - The Change Log can now be displayed as an HTML page from the online manual. 2018-12-18 - Added support for HTTPS environment. 2017-05-31 - Added parameter "ASP group" to the initial screen. 2016-11-24 - In pgm WRKDBF the call to module WARNLSTRLS is now monitored, in case the module fails when accessing service program LIBHTTP/HTTPAPIR4. 2016-07-02 - HTTP configuration directives now supporting also APACHE 2.4 2014-10-18 - A free trial version (file "wrkdbtry.zip") has been made available for V5R3 and subsequent releases. This version is "object code only" and can be used for 30 days. 2014-08-27 - A new command, FRCFILTER, allows to force a database filter for all users other than the originator. See http://www.easy400.net/cgiwrkdbf/html/userguide1.htm#11 . 2014-08-27 - All the calls to "ad-hoc" programs are now monitored. - In module XXXRTVMBRD set a patch on calling QUSRMBRD API (Retrieve Member Description) which in V7R1 may return error message MCH1210 thus causing WRKDBF problems. 2014-03-06 - Recreation of an existing "ad-hoc" program will no longer be forced when database creation/last-change dates do not match the ones recorded on file CGIWRKDBFD/ADHOCCTL . 2013-09-01 - Fixed external HTML /cgiwrkdbf/html/wrkdbf.htm. Reason was that "isChrome" and "isSafari" can no longer be used as JavaScript function names, as they seem to have become reserved names in Mozilla browser. 2013-07-11 - Fixed the case when a database file becomes no longer available while being processed by WRKDBF. 2013-07-02 - Fixed the installation procedure for the case when system value QCCSID is 420 (Arabic) 2012-10-10 - For performance reasons, the following changes have been applied: -- the maximum number of records per page has been set to 5000 (the previous limit was 9999 records per page) -- the Scrollable-Fixed-Header-Table feature is used only if the number of table cells (number of records per page * number of record fields) does not exceed 2500. 2012-03-05 - SQL tables (PFs) and SQL views (LFs) can now be updated. 2012-03-04 - Added ability to delete the selected database record when non-unique keys are used. - Fixed positioning after updating or adding a record. 2012-03-01 - Added ability to update the selected database record when non-unique keys are used. - Fixed ad-hoc program generation when null capable fields are involved. 2012-02-12 - Improved the way how user preferences are retrieved on the initial screen. 2012-02-02 - Fixed the way how initial parameters are stored and retrieved from user preferences file. 2012-01-30 - Documented product restrictions for Chrome and Safari. 2012-01-28 - The end user is now allowed to select the desired columns (feature of jQuery Fixed-Header-Table plugin). 2012-01-26 - Implemented jQuery Fixed-Header-Table plugin. 2011-12-16 - SQL View database files are now processed only in read-mode. 2011-12-10 - Positioning to the "bottom" of a file now provides a full page of records instead of a single record. - Fixed the editing of negative signed and packed key fields. 2011-12-07 - Improved initial closing of user database files. - Fixed "bottom" positioning for packed and for date key fields. 2011-12-03 - Character fields longer than 50 are now maintained as more friendly textareas. 2011-12-02 - Added support for *LIBL in command RUNWRKDBF. - Fixed the editing of numeric fields with some decimal positions. 2011-11-30 - Fixed "Set filter" processing when a filter field value is blank. 2011-11-26 - Provided support for field data type "G" (UCS-2 graphic fields). 2011-11-25 - Files CGIWRKDBFD/ADHOCCTL1 and CGIWRKDBFD/FLDLSTCTL now opened with RCDFMTLCK((... *EXCL)) WAITFILE(32767). 2011-11-03 - Fixed pgm INSTALL to dup file DNS to library CGIWRKDBF. 2011-09-26 - Changed names of variables in AD_HOC programs to avoid homonymies with user database field names. 2011-09-13 - Corrected a severe bug in the record filtering process for operator *LK (like). 2011-09-05 - Added new powerful operator *LK ("like") for record filtering. 2011-09-04 - Provided a User Guide. 2011-06-13 - Found that "Steady Headers" option did not work when direct call to http://.../cgiwrkdbfp/wrkdbf.pgm?xrequest=CMD&xfilename=aaa&xlibname=bbb That was fixed. However please note that option "Steady Headers" work with I.E. but is no longer supported by FireFox 4 (support dropped for TBODY and THEAD html tags). 2011-04-15 - Provided some support for database null capable fields. 2011-04-10 - Fixed the following bug in pgm WRKDBF: "when displaying a record for update, leading blanks of character fields used to be incorrectly trimmed off." 2010-10-09 - Updated module WARNLSTRLS. 2010-10-05 - Module WARNLSTRLS was causing a 3 minutes stop in connection to the Easy400 site not available. When this occurs to an user, now the user will never undergo such pain again. 2010-07-21 - Fixed the editing of DATE database fields: the ad-hoc RPG program always returns a 10 byte value, where the DATE database field length can be 6, 8 or 10. 2010-07-16 - Representation of signed and packed fields with a value lower than zero was wrong; now fixed. 2010-07-07 - Fixed the case where a character field contains "<" or ">" as the last character. 2010-07-01 - Fixed the following bug: if some of the service programs in library LIBHTTP is not available, WRKDBF would bump out. The fix is done by replacing the source used to compile module WARNLSTRLS. 2010-06-09 - Fixed the following bug: in updating records, only the first 1,000 characters of a field were made available in input. 2010-04-16 - Had to face the following problem: -- When pgm WRKDBF calls an ad-hoc program, a link to it is stablished in the HTTP CGI job. If for any reason (e.g. a change in the level ID of the related database file) the ah-hoc program is regenerated from pgm CRTADHPGM, WRKDBF calls it through the established link (instead of calling the the version of the same ad-hoc program), thus raising an exception because such previous version of the same ad-hoc program no longer exists. In order to overcome this problem, pgm CRTADHPGM has been changed. If for any reason the ad-hoc program for a given database file has to be recreated, it is now created with a different program name. The call to it from pgm WRKDBF will therefore be to a different program name and the established previous link is no longer used. 2010-03-15 - Fixed representation of numeric values lower than 0.1 . For instance, value 0.010000 was displayed as 10000 thus creating problems when updating the record, because that value would become 10,000 as input field. 2010-03-03 - Ad-hoc programs were issuing the wrong DLTOVR command (thus generating a lot of messages in the joblog). That was fixed by changing program CRTADHPGM and RPG sources ADHPGMA, ADHPGMAW and ADHPGMK. 2010-02-18 - Fixed error in displaying signed or packed fields with decimal. For instance, value 87.6000 was edited as 87.5999 . - Fixed error in creation of an AD_HOC program, when a field in the record format carries the same name as the record format. 2010-02-17 - Fixed filter compare routine: it was incorrectly working for signed and packed fields. Also fixed javascript validation for filter definition: it did not accept negative values for numeric fields. 2010-02-15 - New feature: "Add alike record". It allows to add a record similar to a given one. It operates as follow: -Select a record for update -Instead of the "Update" button, click the "Add alike record" button -The screen "Add record" appears. Fix the field data and add the record. 2010-02-14 - Added one more control on the need to re-generate ad-hoc programs: record format level ID. 2010-02-13 - New "Record-Marker" feature: the first column now contains a clickable icon for marking all the record fields. This feature is expecially useful when a record format has fields that can be shown only by scrolling the page to the right. 2010-02-12 - Field characters convertion to uppercase is now implemented on exiting from a field ("onBlur" condition), if the "Uppercase" checkbox is checked in. - Alternate background colors now provided for record rows. - Ad-hoc program is now regenerated not only when the file creation_date/time has changed, but also when the file change_date/time has changed. 2010-02-04 - If input variable "xfilembr" or "m" not specified, member *FIRST is now assumed. 2010-02-02 - If API QUSRMBRD (Retrieve Member Description) fails, number of records returned is now zero instead of blanks. 2010-01-21 - WRKDBF was recognizing only the first five keys of a database file record format. That was fixed. 2009-12-12 - The fix performed on 2009/12/02 had to be improved. When the first character of a field was < or >, it was displayed twice. 2009-12-02 - Database record field data characters "<" and ">" are converted to their character entities before being inserted into the output HTML, thus avoiding possible horrible HTML effects. 2009-11-24 - Added feature to keep table headers steady while scrolling the table. Always available for I.E.. For Firefox available only when the database record format fits in the screen width. 2009-11-18 - HTTP instance Apache configuration /cgiwrkdbf/conf/httpd.conf got corrupted by mistake, now restored. 2009-11-17 - A numeric field of file FLDLST was found to be too small, thus impairing the ability to complete the mapping of long record formats. - Fixed a small bug in module CGIWRKDBF/CRTADHOCPY. It was preventing the ad-hoc program created via command CRTADHOCP to be used by WRKDBF. 2009-10-16 - Fixed filtering for variable length fields. 2009-10-12 - Command RUNWRKDBF now allows to start WRKDBF from a green screen emulator session (iSeries Access for Windows required). Use command prompt for operation details. - Some aesthetics changed on WRKDBF navigation (suggestions from Jim Rothwell, NBC Universal). 2009-10-10 - Short aliases 'xr', 'l', 'f' and 'm' can now be used instead of input variable names 'xrequest', 'xfilelib', 'xfilename', 'xfilembr' . This makes it easier to build a STRPCCMD when initiating CGIWRKDBF from an emulation session (suggested by Jim Rothwell, NBC Universal). 2009-10-08 - In program WRKDBF added parameter ASPDEV(*ALLAVL) to a DSPOBJD command, in order to be able to include in a list of files also those on an ASP. 2009-09-30 - Added FAQ for sysval QCCSID 65535. See page http://www.easy400.net/cgiwrkdbf/html/faq.htm#1 - Added *PSSR to WRKDBF. Program errors from WRKDBF are now shown in a special WEB page. 2009-09-29 - Editing of variable length fields now supporting zero-length fields. - According to today Scott Klement's suggestion, an HTTP directive was added to the HTTP config file needed to run WRKDBF (/cgiwrkdbf/conf/httpd.conf). That will fix LIBHTTP problems previously reported. 2009-09-28 - If LIBHTTP already installed, module WARNLSTRLS may fail when calling some LIBHTTP procedure. Fixed module WARNLSTRLS by adding an "addlible libhttp" instruction. (It was found later that this does not fix the LIBHTTP problem, one needs to specify "At runtime, use *LIBL to find HTTPAPI? N (Y=Yes, N=No)" during LIBHTTP installation.) 2009-09-23 - Fixed bug in file display when a variable length field contains nothing. 2009-09-22 - Added diagnostics in case of AD-HOC program failure during execution. 2009-09-21 - Fixed a potential /copy problem within WARNLSTRLS source. 2009-09-19 - Added support for floating point fields. - Added communication (LIBHTTP) to inform users about new releases of this tool. 2009-09-16 - Fixed a bug on "position" (allowed length for numeric key fields). 2009-09-15 - Provided support for binary fields with more than 9 digits: example B (18 0). 2009-09-12 - In the blue bar, added icons linking to the manual and to the change log. - Fixed a bug in one of the modules used by command CRTADHOCP . - Added an FAQ page http:/www.easy400.net/cgiwrkdbf/html/faq.htm - AD-HOC programs now support the case where a database field name has the same name as the database file. This generally happens when CRTPF FILE(...) RCDLEN(...) . - Upper/Lowcase option now retained at database file level. 2009-09-11 - Provided tools and documentation on recovering an AD-HOC program generation failure (command CRTADHOCP) 2009-09-10 - Fixed html size and maxlength values when the length of an input field exceeds 1 thousand. - Fixed minus sign editing on S and P fields. - Fixed some problems related to excessive large values in binary fields B (9,0). 2009-09-09 - Added error messages on inability to retrieve database file record format name or database file record format field descriptions (usually a security problem). - Added command CGIWRKDBF/RELEASED to display the timestamp of the installed version. 2009-09-08 - Improved performance by about 5 times, reducing the number of %trim and %trimr instructions. 2009-09-04 - More validation on date, time and timestamp input fields. 2009-09-03 - Fixed bug on variable length character fields. - Fixed bug on numeric fields (1 1). 2009-09-01 - New feature: Add/remove a filter on database records. 2009-08-26 - New feature: select from database relations. - Fixed the following bug: when a new record to be added with recno='*LAST', instead of calling the ad-hoc pgm ending with 'W', SRKDBF was calling the other one without final 'W', record could not be added, but user was told that the record was added. - Fixed the following bug: when a database rcfmt changed, ad-hoc pgm regenerated, but WRKDBF would bump out finding that the pointer to the previous ad-hoc pgm refers to a deleted object. 2009-08-18 - Added RPG control statements to the source of pgm WRKDBF in order to have different statements according to the OS/400 release level (see for instance variable "largeSNum"). 2009-08-18 - Changed the installation procedure so that sources are converted to the hosting CCSID (job DFTCCSID) even when job CCSID is 65535. 2009-08-18 - Fixed HTTP Error 500 when returning to home page via the orange icon after working with an arrival file. 2009-08-17 - User database file now CLOSED after any significant transaction. 2009-08-17 - Forced pgm WRKDBF to change job CCSID if found to be 65535. This must be done, otherwise some special characters in javascripts (like ^ | \ ) gets corrupted. 2009-08-16 - Added feature to optionally force uppercase on input fields 2009-08-15 - Now suppoting record addition, deletion and update. 2009-08-08 - Added files OPENFILES ans OPENFILES1. Added code that allows the CGI job to close files that the same CGI job might have left open for at least one hour. 2009-08-07 - Compile output for ad-hoc programs is now *NONE.