History

version 3.10 (21/05/2014)

Fix: Support for Clarion 9.1

version 3.09 (25/02/2014)

Fix: Several minor fixes.

version 3.08 (17/01/2013)

Fix: The "run-time disable" feature were opening the file to read it in non-sharing mode.

version 3.07 (17/01/2013)

Fix: Chance to use the audit file without any Blob field (if used in "fullrecord" mode only). Previously it was requiring a blob field even if not in use.

version 3.06 (16/08/2012)

Fix: The "run-time disable" feature wasn't working for the "mixed" or "field" audit mode.

version 3.05 (1/12/2011)

Fix: Some libraries used by the template were not picked up automatically on Clarion 6.x.

version 3.04 (15/11/2011)

Change: Temporary files no longer created on program's folder. Now taking Windows's temporal folder.

version 3.03 (29/07/2011)

Change: All examples revised.

Fix: Automatic assignment for date, time and user, for added or changed record, were not working.

Fix: "View Record" in the inspect window was not showing the memo content if the memos were not the first fields in the file.

New: Guide to examples.

version 3.02 (12/05/2011)

New: Support for Clarion 8.

Fix: Auto numbering code were being generated to fields not existing on DCT.

Fix: Sample DCT was missing a variable.

version 3.01 (19/04/2011)

New: Run-time selective tables global now made optional

New: Documentation improved updated

Fix: Some duplicates names removed from Legacy template

version 3.00 (17/02/2011)

New: Support to store changed fields only.

version 2.25 (15/7/2010)

Fix: Thread local attribute removed (Detected by Clarion 7).

Fix: IMDD examples had wrong dct.

version 2.22 (3/7/2009)

New: The install process supports Clarion 7's folders structure.

New: All examples were migrate to Clarion 7; you'll have native C7 apps when working with C7.

Fix: In the ABC chain, the BrowseAuditFiled prototype was changed to compile with Clarion 7.

version 2.21 (22/1/2009)

New: PostgreSQL examples

Fix: Spurious Read operations were saved if you were using Clarion 6.1 or before.

version 2.20 (22/11/2008)

New: Local extension, now you can locally select which files to call for Record Audit Inspect (BrowseAuditRecord).

New: Several new embed points.

New: SaveAudit: Now it can add records in the audit and historical audit files when the datetime field type is used.  Set the Date and Time audit with the same field in global extension.

New: New examples using SQL Anywhere.

New: New examples for MSSQL and Firebird showing the use of Blob fields and without Blob as well.

New: Many examples were updated; also a new guide table for all the examples (See Installation)

Fix: CleanAudit now cut the Audit file correctly when the date field are datetime type (SQL).

Fix: CleanAudit was not working right with TPS AuditNew file.

Fix: CleanAudit, Legacy: Now it can add records to historical Audit even if starts from an empty Audit file.

Fix: CleanAudit: was not working right with MSSQL driver and Clarion 6.3 9057/9058. The file AuditNew is no longer necessary for SQL.

Fix: InspectField was not working right with no audit fields present.

Fix: If some operations in a file were not audited (by locally run-time disabling the auditing), and the user browses the field inspect from a Form so the last audited operation doesn't match the current record, the current value of the inspected field in the form were changed to the last audited value.

version 2.11 (31/8/2008):

Fix: Auto detection when there are no memos in the audit file (It was giving compiling errors, as it was expecting at least one memo).

Fix: Blob handling improved, there was a couple of compilation and run-time errors if there are Blobs and no memos.

Fix: GPF Error handling blobs when using the "View" button.

Fix: TXD Analyzer had a problem recognizing the proper size of fields longer than 32 Kb. You have to pick your TXD again with this new version if you already did it with a previous version of the Analyzer.

Workaround: A bug in Clarion's IDE was causing the global properties window to scroll down each time we change from our template to another. We changed the multi-row tabs by scrolling tabs to avoid it.

Fix: many help texts improved by Nardus Swanevelder (Thank you!).

version 2.10 (19/6/2008):

New/Fix: New feature Browse Audit "Advanced" now working properly (browse the fields changed without pressing the "view" button).

Fix: Some bogus "read" operations were improperly saved on change right after add.

version 2.09 (30/3/2008):

New: Option to workaround Btrieve memo property assignation bug - Using Btrieve driver memo fields sometimes adds "garbage" to the memo field (Acknowledged by SV as #30485).

Fix: ABC Template: "Audit" file name no longer hard coded inside a global procedure.

Fix: Supress "previous" error message when inspecting first "change" record without previous read.

Fix: Some "read" operations, required for changes, were not saved on a fresh audit file.

version 2.08 (24/2/2008):

New: Procedure Name now can be recorded in "source" type procedures.

Fix: ABC Template: was not compatible with Clarion 6.1 and before.

Fix: Procedure Name generation moved to first priority on Init code section.

Fix: Read buffer was incorrectly saved when a change operation was taken place right after an insert.

version 2.07 (27/1/2008):

New: TXDAnalyzer now can import file selection from FullRecord.Fil file.

New: Legacy template: option to keep Audit file opened to improve performance.

Improvement: Record buffers optimized on GenerateSearchKey procedure.

Fix: Inspect field windows was messing with file buffer when called from Form windows.

Fix: Installer were wrongly linking the shortcuts.

Fix: Threading problem with inspect field list (Field list were mixing if opening from concurrent inspect windows).

Fix: ABC template: Inspect window was improperly closing related files.

version 2.06 (12/1/2008):

Improvement: Increased speed of code generation.

version 2.05 (18/11/2007):

Fix: Memo number was incorrectly generated upon call Field Browse inspect.

New: Auto-check for previous record in audit trail, if previous buffer does not exist (because for example is a new Audit file) a "read" operation is added prior to the "change" one.

version 2.04 (13/11/2007):

Enhancement: Template Run-time disable tweaked to improve the performance.

Fix: Some portions of code were still being generated when the template were totally disabled.

New: Example process procedure in ABC and Legacy examples for measuring performance, with and without template activation.

version 2.03 (10/11/2007):

Fix: Alias files were not supported

version 2.02 (03/11/2007):

Fix: Installer were not retrieving serial and maintenance key for next revision.

Fix: Legacy templates: BrowseAuditRecord was not ranging using the proper record.

Fix: Legacy templates: Inspect Procedure and Recover procedures were not properly opening/closing files, leading to Error 37 or Logout errors depending on how they were called.

Fix: Files with more than one blob were auditing only first blob.

Change: "Read" record is now saved when the key information is changed, the "read" record is still necessary to determine how was the key before the change.

Change: "View" button on "Inspect" window modified to look for the "read" record if it exists, or the previous operation if there is no "read".

version 2.01 (29/10/2007):

Fix: Legacy templates: were not generating BrowseAuditField calls.

version 2.00 (28/10/2007):

New: From version 2.x on FullRecord is compatible con Clarion 6 and later (Clarion 5.x no longer supported).

New: Now only one record is stored per operation, always. One per insert, one per change and one per delete ("read" type records are not longer necessary and were deprecated). (See revisions 2.02 and 2.05).

New: Every insert, update or delete operation is automatically audited, even if it is in source code, so you can rely that any deep hidden or lost operation will be saved to the Audit file. You don't need to add any code by yourself! And for both ABC and Legacy.

version 1.84 (14/8/2007):

New: Global checkbox for disabling Audit Record and Audit field features.

Fix: Cleanup procedure; properly find true last ID number using ID key instead of Date key.

Fix: Proper defaults for "Message" global tab on new app.

Fix: Handling error on third and fourth parameter in arrays, produced a GPF in Inspect procedure if third of fourth array index had less range than first or second index (i.e. 2,2,4,4 produced no errors, 4,4,2,2 produced GPF).

Fix: Call code for Browse Record and Browse Field were generated even if the file were not in the Audit file global list.

version 1.82 (15/4/2007):

New: Record Inspect feature (Inspects changes for a particular record from a button, or Hot key, on a Browse or Form).

New: Local disable of code generation for calling Audit Inspect Browse.

New: New "version" field on Audit structure, on preparation for incoming feature.

Improvement: "Field" inspection window now uses the field picture to show the data.

Change: Global "Variables" moved from "General" Tab to a Tab on their own (Advanced interface)

Fix: On Update procedure for upgrading record structure inside Audit file, proper support for audit record stored in blob field, with or without compression.

Note: On multi-dll systems a full recompilation is needed.

version 1.81 (11/3/2007):

New: Advanced/Basic Settings interface, to hide the clutter out of the template options.

Improvement: Some template options rephrased for better understanding.

Fix: Multi-dll example for C6 - parameter list for BrowseAuditField procedure was wrongly taken from previous beta.

version 1.80 (05/3/2007):

New: Field Inspect feature.

New: Multi-dll Clarion 6 ABC example.

Change: Replaced all LOC: prefixed variables by JAL: prefix to avoid possible conflicts with user variables.

version 1.72 (12/1/2007) (limited release):

Fix: A field name from the Messages file were still hard coded in the template.

version 1.71b (06/12/2006):

Fix: Undefined symbol found when you delete and repopulate the global extension in a dll of a multi-dll system.

version 1.71 (02/12/2006):

New: In the MSSQL C6 example, a new inspect browse showing how to use a SQL query to find the data on the Audit file.

New: German TRN file.

New: MSSQL Legacy example for C6.

Improvement: "Messages" file name and fields are no longer hard coded.

Change: Audit and storage routines related with user messages were moved from the FullRecord Template to the NeatMessage template.

Change: Remove of external name in "group" fields of the MS-SQL example to prevent warnings from FM3.

Change: Rename of external name in keys of the audit files of the MS-SQL example to prevent warnings from FM3.

Change: in the audit.txd file, changed the name of the "GlobalData" area to "FRGlobalData" to avoid common conflicts when importing.

version 1.70 (16/10/2006):

New: FAQ section and several enhancements in the documentation.

New: Full Blob fields support for both Audit and Recover now for C55 as well as for C6.

New: Now you can see the stored Blob size in the Inspect Window.

New: Global option to allow to skip specific fields from the inspect window (two methods - either by the "NoPopulate" option or by adding a "FRSkip=True" option in the DCT).

New: "Recover" control template now generates global procedures, being able to support up to any number of files (tested with 960+ files).

New: Global option to "Suspend" the template action, so the template is disabled but you still can compile your program without errors (even if used manual calls).

New: "Cleanup" process now available for MSSQL files.

New: "Cleanup" process now can handle completely erasing of the Audit file more than once.

New: Now you can optionally frame the "Cleanup" process within a transaction.

New: Portuguese translation file.

New: Install generation of .ini file compatible with Clarion Desktop (http://www.clariondesktop.com/)

Fix: Were some problems with server-side autonumbering of the Audit file.

Change: MSSQL example now shows how to set server-side autonumbering for the Audit file.

Fix: Error found in processing file with Blobs.

Fix: In the Multi-dll example, the "process" procedure was declared in the wrong module (from the caller exe).

Fix: Installation program, now you can set the install path (missed feature).

version 1.62 (23/8/2006):

Fix: TXD Analyzer 1.02: former version file name limit of 30, proven to be too short. Expanded to 40 characters.

Fix: TXD Analyzer 1.01: former version was not taking ALIAS files into account.

version 1.61 (11/8/2006):

Improvement: The message showing the "memo" information now will have the field name as Title.

Improvement: From this version on, your installer settings will be memorized in the registry (i.e. no longer look for your original e-mail to get the serial and code again!).

Improvement: In the "recover" control template, an automatic window refresh was added after the recovering (to immediately see the recovered entry log in the browse).

version 1.60 (7/8/2006):

New: TXD Analyzer, a new companion program that will let you analyze your dictionary and easily pick the correct values for FullRecord's variables. It will also generate a "file list" for you to pick it up from your template global settings. Source code included.

New: Now pressing a "View memo" button in the "Inspect Window" you can see the full contents of the memo fields.

New: Now global option to select if group fields are skipped from Inspect window.

New: Embed for manually handling events inside the inspection window.

New: Example auditing IMDD 2.2 files (IMDD driver required).

Improvement/Fix: The name of the procedures is now handled in a global threaded queue, to avoid loosing the name when a lookup is performed. This way, the recorded name of the procedure is completely accurate. You have to change the DCT and global properties if you are migrating from a previous version of FullRecord (See the Installation over previous versions chapter).

New: Global option to disable or enable the new "View memo" button inside the "Inspect Window".

Change: Several changes in the documentation to reflect the new features. Pay special attention to the changes in the General Tab, Inspect Tab, Files to Audit Tab, Translation options and the inspection window chapters, and the whole new Using TXD Analyzer chapter.

Change: Window structure changed to hold a new "View memo" button to "view" the full contents of the memo fields.

Change: Translation files changed to add a new equate text for the "View memo" button .

Change: The local procedures generated associated with the "View record" control, are now deprecated. The inspect procedures are now only global.

Note: A full recompilation of your system is needed if you upgrade from previous versions.

version 1.55 (12/7/2006):

New: Extended support for saving assorted information to the Audit file (See the new chapter Manual save of custom information in the documentation).

New: Global switch to show only changed data in the Inspect window.

New: Embeds points before and after queue generation for the Inspect Window.

New: Group fields now skipped from Inspect window.

version 1.54 (05/7/2006):

Fix: When you have a GROUP with some field dimensioned and others not dimensioned, all were treated as dimensioned.

version 1.53 (02/6/2006):

New: Local override to avoid to track unwanted procedure names (like for example Report Previewer).

New: Global setting to avoid the declaration of the zlib library (for compatibility with other templates that also uses it).

Fix: Some local code from extension templates were generated anyway when the template was globally disabled.

version 1.52 (23/5/2006):

Change: Autodetect NeatMessage and avoid the procedure name to take the name of the "message" window; thus the recorded message now shows the name of the calling procedure.

Fix: When storing record in Blob field was not clipping the data, therefore occupying more space than  necessary on the file.

version 1.51 (18/5/2006):

New: New example, for MS-SQL Server (Clarion 6.x).

Fix: Some operations where not compressed/uncompressed when the Stored Record were stored in a Blob type field (Clarion 6.x only).

version 1.50 (15/5/2006):

New: Compression scheme for all read/write operations on the Audit file.

New: Compression flag in the Audit file, allows the storing of mixed compressed and uncompressed records.

New: New layout for the Audit file, now stores the record in a memo field and add information about the workstation and calling procedure.

New: New global variables and new audit variables referenced in the template global extension.

Note: If you want to use the new features, changes need to be made for the audit files. You will have to convert your existing audit files to the new format.

Improvement: Examples and documentation updated to include new fields and compression support.

Improvement: New default names for all fields in the Audit files (Set in DCT and TXD files).

Improvement: New default values for operation codes (Set in TRN file).

Note: If you want to use the new operation codes, you will have to convert your existing codes in your audit files to the new values.

Improvement: "Search key" now named as a more descriptive way of "search key"; changed in documentation, dictionary and all the examples.

Improvement: New default names for all global settings to allow a quick-start implementation.

Change: Cosmetic; populated "view" and "recover" buttons no longer Flat.

Fix: "Messages" file name were hard coded as "Mensajes" in one place in the Legacy FullRecord template.

Fix: Recover control template were referring to global audit file, preventing to recover a record from a  subsidiary audit file (local declared).

version 1.33 (28/4/2006):

Improvement: Now you can choose how many global inspect procedures will be generated by module, making the compilation way faster! Prior to this change was one procedure per module, now the default is 20.

Improvement: Now you can set up globally the name of the external translation file, thus your file is safe for future upgrades. Also, because of this you no longer need to externally rename the appropriate file to the default filename.

Improvement: Now you can set up globally the name of an external file to hold the "view" windows definitions, therefore your custom windows will be safe against future upgrades.

Change: The two new entries in the TRN file (From version 1.31) are now also in the Spanish and in the French translation files.

Fix: Dimensioned GROUPs were generating an error when using global inspect procedures instead of local (incomplete implementation of improvement from version 1.32).

version 1.32 (23/4/2006):

Improvement: Dimensioned GROUPs were not considered; now fields inside dimensioned groups inherits the dimensions of the group and the group itself is skipped from processing.

Change: When storing the record in a memo field, a memo-to-record comparison in clarion 6.2 produced a GPF. It was changed to avoid the error and the new method is compatible with any version.

New: Search engine in the on-line reference.

version 1.31 (09/4/2006):

New: Better handling of undelete operations. Now if you try to recover a record which already exists, you may choose to renumber it to add the recovered record at the end of the file, instead of deleting the current record. See the updated Recover chapter.

Change: there are two new entries in the TRN file.

version 1.30 (22/3/2006):

New: Save recover information (what, who and when the record was undeleted)

Improvement: Better handling of Audit file open errors.

Improvement: The name of the global DCT variables is no longer hard coded.

version 1.25 (10/3/2006):

New: (Clarion 6.x only) Support for storing the audited record in a BLOB field; that's make possible to use Firebird as audit file database.

New: (Clarion 6.x only) Example app using ODBC and Firebird as storing audit file.

Fix: For the "inspect" button, now you can see the content of a "message" record (UM) when browsing an audit file different from the main one.

version 1.21 (19/1/2006):

New: Extension template to automatically manage record updates in a process (See Changing record layout).

New: Example .app and .dct to show how to implement the record update in the audit file.

New: TRN French file (Merci to Jean-Pierre GUTSATZ)

Fix: Audit message wasn't properly generating Search key.

version 1.20 (15/1/2006):

New: Support for recovering records using direct SQL syntax for ODBC (mySQL) and Pervasive SQL.

New: Support for FinalStep 2.x template in the Inspect window, so it will have the same dynamic wallpaper than the rest of your app.

New: New chapter in the help file, about changing the record layout of your files.

New: Debug option for assisting remote support.

Imp: Recover control template - now no longer requiring that the primary key were the first key.

Imp: Extended information on record recover error (native errors for SQL drivers).

Imp: For global procedures, now will generate them with full long names (instead of short 8.3 ones). Delete the old .clw and .obj files prior to recompile to clean up the garbage.

Chg: Embed name after open internal inspect window changed (See Installation over previous versions).

Chg: Inspect window - Wallpaper was mandatory, now its optional.

Fix: Global tabs were not showing when trying to use the control templates in the exe of a multi-dll system.

Fix: Key-in input picture @k is now supported for Search-key generation and inspect window display.

version 1.19 (14/12/2005):

New: A multi-dll example app.

Imp: Inspect window - Default inspect window wallpaper changed to blank instead of 'Fondo.gif'.

Fix: Inspect window - should not process message file when its name is not specified in the global extension of the template.

Fix: Inspect window - "Memo" fields memory buffer was assigned like file variable with a fixed name. It should refer to global variables to allow for not-uniform databases field names.

Fix: Internal automatic control to handle the use of a "Memo" field to store the record in the audit file.

Fix: Inspect window - Global inspect control template generating compile error in the export list when used in a main data dll in a multi-dll system.

Fix: Inspect window - Module and pragma definitions were incorrectly generated in non-data dll in multi-dll system.

Fix: Inspect window - Global queue not generating export list when used in a main data dll in a multi-dll system.

Fix: Inspect window - Not referenced global queue to data dll when used in a main data dll in a multi-dll system.

Fix: Inspector window - global option - not properly showing or comparing memo fields with previous value.

Fix: Global extension - Auditing Tab should be active for multi-dll apps to specify files to inspect.

version 1.18 (12/12/2005):

Imp: User variable in the audit file no longer hard-coded (Was USOPER). See Installation over previous versions.

Imp: Record variable hard-coded in a couple of messages (Was DERECO).

Imp: Memo variable in the audit file no longer hard-coded (Was DEMEMO).

version 1.17 (12/12/2005):

Fix: some "Operation" codes were left hard coded.

Fix: Inspector window - Column options not working (compiler error) when generation set to local instead of global.

Fix: Inspector window - local option - not properly showing or comparing memo fields with previous value.

version 1.16 (12/12/2005):

Imp: FullRecord.TRN - "Operation" equates were added to translation file; they are no longer hard-coded.

Fix: Rsa55 Example - Windows background changed to supplied .GIF

Imp: Rsa55 Example - dct path removed from example app

Imp: Fra55 Example - dct path removed from example app

Imp: Fra55 Example - Example message keyword filled in global extension

Chg: FullRecord.DCT - field comments translated from spanish to english

Imp: FullRecord.DCT - Reference from unknown SNC file changed to AUD file.

version 1.15 (5/12/2005):

New: Local alternative to global generation for "Inspect" control template (If global option is not active, then local generation will take place, instead of issuing an error).

Fix: In global "inspect" control template: Support for inspecting other audit files than the global declared one (for example the historic audit file).

version 1.10 (5/11/2005):

New: "Inspect" control template completely recoded to avoid the "segdef" error with any DCT/file size. Tested with 1700+ fields files, with a DCT of 150 files. New global options to handle the generation.

New: Run-time deactivation of the auditing is now possible.

New: Quick translation option. New TRN file outside the template for translating all messages and buttons. See "Translation options".

New: Inspection window now described in the manual.

Deprecated: "Big dct" control templates and extensions, no longer neccesary as the new "inspect" control template can handle much more then the "big dct" one. Important: If you were using these controls, you have to read Installation over previous versions and Generator: Unknown template type.

Imp: New embeds and better description on old ones.

Imp: Fields with array elements now handled inside a loop instead of field by field (code optimized).

Imp: Retry on error 83 (Record Is Already Held) saving audit record.

Chg: Global options now available to use control templates on multi-dll apps.

Chg: Some variables and internal names were in spanish, now they are in english. You should change a few variales in your DCT. Please see Installation over previous versions.

version 1.02 (11/10/2005):

Fix: Missing "primary file" on ABC english version of the template on RecoverAudit control template.

New: Documentation improved and on-line reference.

version 1.01 (9/10/2005):

Fix: Missing "primary file" on ABC english version of the template on ConsultaAudit control template.

Imp: Better handling of error 86 on audit file.