Advanced Data Generator - Change Log

0001224: [General] Ability to use only a subset (percentage) of master rows in "For each in" (Martijn Tonies) 0001893: [General] Ability to select unique items from lookup, but reset this for each master item (Martijn Tonies) 0002092: [Firebird Edition] 'relation_name' not found can pop up on newer Firebird databases (Martijn Tonies) 0002093: [General] Date/time values from list accepted while entering, but raising issues when generating data (Martijn Tonies) 0002094: [Firebird Edition] Ability to select use of unicode client, yes/no (Martijn Tonies) 0002095: [InterBase Edition] Ability to select use of unicode client, yes/no (Martijn Tonies) 0002096: [General] Custom SQL based Lookup used as master item fails preparing (Martijn Tonies) 0002098: [General] "Wrap" attribute of SQL statement Data Lookup not stored (Martijn Tonies) 0002112: [General] Prefix/suffix on TEXT data type is not restored when reopening project (Martijn Tonies) 0002114: [General] "reset for each master" checkbox on "items from list" not enabled/stored properly (Martijn Tonies) 0002115: [General] Date/time values from list does not properly use 'reset for each master' attribute (Martijn Tonies) 0002116: [General] Ability to have a per paragraph prefix/suffix for TEXT data type (Martijn Tonies) 0002117: [General] Minor improvements (Martijn Tonies)

0001832: [Firebird Edition] Unknown datatype '23' (Martijn Tonies) 0001842: [InterBase Edition] Possible access violation when generating data for text blobs (Martijn Tonies) 0001843: [Firebird Edition] Possible access violation when generating data for text blobs (Martijn Tonies) 0001867: [General] 'Increasing values' template values not properly saved and used (Martijn Tonies) 0001873: [Access Edition] Small errors in sample database & project (Martijn Tonies) 0001874: [General] Adding a database item to the project by double clicking a column results in Assertion Failure (Martijn Tonies)

0001767: [General] Lookup of Int64 value fails with overflow error (Martijn Tonies) 0001766: [General] UI changes values from max int32, even on int64 columns (Martijn Tonies)

0001712: [Pro Edition] Query error in MS Access database with .accdb extension via ADO (Martijn Tonies)

0000086: [General] Ability to use lookup/master table values as input for stored procedure parameters (Martijn Tonies) 0000088: [General] Ability to use lookup/master table values in the macro value generator (Martijn Tonies) 0000203: [General] Ability to run multiple projects in a specified order and save these configurations (Martijn Tonies) 0000301: [MySQL Edition] TIMESTAMP datatype not recognized as "fill enabled" (Martijn Tonies) 0000302: [MySQL Edition] TINYINT(1) not recognized including length specifier: should be 'boolean' (Martijn Tonies) 0000554: [General] Ability to use one (random) of multiple macros instead of a single macro (Martijn Tonies) 0000555: [General] New macro: "take one random from given group" (Martijn Tonies) 0000734: [General] Ability to run custom SQL statements after connecting to database, eg for NexusDB table passwords (Martijn Tonies) 0001097: [General] Ability to use a table/procedure multiple times without custom SQL statement (Martijn Tonies) 0001225: [General] In "for each in", for date/time columns it should be possible to use a value from the master table (Martijn Tonies) 0001605: [General] Using large blob files or a large number of blobs no longer result in out-of-memory error (Martijn Tonies) 0001608: [General] Ability to repeat random char/digit/hex digit (Martijn Tonies) 0001624: [General] Remove required closing ';' from #S and #R command if no formatting available (Martijn Tonies) 0001629: [General] Grabbing a NULL from a 'master item' fails and defaults to data type dependent nil value instead (Martijn Tonies) 0001715: [Access Edition] Create a MS Access Edition (Martijn Tonies) 0001723: [General] HighDPI aware (Martijn Tonies) 0001724: [General] Add German last- and first names to data library (Martijn Tonies) 0001725: [General] Add French last- and first names to data library (Martijn Tonies) 0001726: [General] Add additional sample/useful data ready for use (Martijn Tonies) 0001728: [General] Ability to create a numerical value within range from previous value (eg for statistical data) (Martijn Tonies) 0001730: [General] Sample Project could raise error when loading on non-English locale (Martijn Tonies) 0001731: [General] Automatically create a monthly backup of the configuration and project data (Martijn Tonies) 0001732: [General] Ability to run project from the project editor without need to close/run separately (Martijn Tonies) 0001733: [General] Add JSON file format as target for the generated data (Martijn Tonies) 0001734: [General] Support binary data when generating data for XML and YAML files (Martijn Tonies) 0001736: [Access Edition] Add Access database script for sample project (Martijn Tonies) 0001738: [Pro Edition] Distinguish between (N)CHAR and (N)VARCHAR on ADO connections when possible (Martijn Tonies) 0001750: [General] Add Italian cities, street names, first and family names to data library (Martijn Tonies) 0001751: [General] Ability to create projects groups (Martijn Tonies) 0001729: [General] Memory leaks removed (Martijn Tonies)

0000941: [Firebird Edition] Firebird client library setting not saved (Martijn Tonies) 0000987: [MySQL Edition] Sample project fails on "delivery_date" look up being case sensitive (Martijn Tonies) 0001123: [General] Access Violation when using "Create Custom SQL for Table" while not on a table (Martijn Tonies)

0000768: [Pro Edition] On Oracle, columns can be retrieved for the wrong schema table on same named tables in different schemas (Martijn Tonies) 0000769: [Pro Edition] Add schema filter to avoid long waits and lists of irrelevant metadata on large (Oracle/multi-schema) systems (Martijn Tonies) 0000770: [General] Add visual feedback when opening/creating projects (Martijn Tonies) 0000771: [Pro Edition] Possible ODBC error on fetching metadata can block normal running of application (Martijn Tonies) 0000772: [General] Possibly no metadata available when creating new project (Martijn Tonies) 0000773: [General] Saving a project can take a long time when not all field metadata is fetched, especially on Oracle (Martijn Tonies) 0000778: [General] Add Italian street/city/name data to the data library (Martijn Tonies) 0000780: [General] Add Italian postal code and telephone number templates (Martijn Tonies) 0000781: [General] Macro: random value with boundaries generates over upper boundary (Martijn Tonies)

0000760: [General] Cannot start due to GDI+ error after certain Windows XP update (Martijn Tonies)

0000723: [General] Cannot load ADG v2 project file (Martijn Tonies) 0000721: [General] WHERE clause of table/view lookup not stored? (Martijn Tonies) 0000722: [General] Don't show stored procedures options doesn't do anything (Martijn Tonies) 0000724: [General] Saving a project to file doesn't use the latest general settings (Martijn Tonies)

0000560: [General] List the projects that use a database registration if deleting a database registration fails (Martijn Tonies) 0000642: [General] Ability to quickly generate an INSERT statement for a table as "custom SQL" (Martijn Tonies) 0000657: [General] Add progress information when preparing a lookup (Martijn Tonies) 0000661: [General] Date/time format in INSERT script invalid (Martijn Tonies) 0000693: [General] Order of items to fill can have gaps when reviewing/editing the project (Martijn Tonies) 0000694: [General] Wrong image for "Project" in Import/Export window (Martijn Tonies)

0000204: [General] Make the time part of the log have an accuracy to the millisecond (Martijn Tonies) 0000222: [General] No longer use the Windows Registry for Settings or other things (Martijn Tonies) 0000231: [General] Increase possible integer values to 64 bit. (Martijn Tonies) 0000374: [General] Make a filter in the log view to filter on "warnings", "errors" etc (Martijn Tonies) 0000087: [General] Ability to use a custom SQL-select statement as the lookup source (Martijn Tonies) 0000206: [General] Renewed user interface (Martijn Tonies) 0000207: [General] ADG unicode enabled (Martijn Tonies) 0000210: [General] Ability to run a project on multiple databases at the same time (Martijn Tonies) 0000221: [General] Ability to use lookups from a different database (Martijn Tonies) 0000379: [General] Ability to modify a preset (Martijn Tonies) 0000438: [General] When the data-target is "script", "empty table" should end up in the script, not executed on the database (Martijn Tonies) 0000441: [General] New preset datatypes and new preset value types (Martijn Tonies) 0000528: [General] CSV text delimiter not properly preserved (Martijn Tonies) 0000529: [General] Support GUID in XML files (Martijn Tonies) 0000538: [General] "R" Macro ignores options behind it when no top is given (Martijn Tonies) 0000546: [Pro Edition] ADO: BLOB Text and NUMERIC metadata not always properly fetched (Martijn Tonies) 0000550: [General] Better error reporting (Martijn Tonies) 0000551: [General] Support for CSV data lookups with embedded CR/LF in text (Martijn Tonies) 0000561: [General] Custom SQL statement does not load "from lookup" name (Martijn Tonies) 0000562: [General] Possible Access Violation when using a custom SQL statement with "no fill" parameter (Martijn Tonies) 0000559: [General] Renewed and much improved documentation (Martijn Tonies) 0000565: [General] New data libraries, ready-to-use data and sample data (Martijn Tonies) 0000591: [MySQL Edition] Ability to fetch list of available databases from server when registered a database for use with the ADG (Martijn Tonies) 0000595: [MySQL Edition] Non-root user cannot read Stored Procedure metadata (Martijn Tonies) 0000596: [MySQL Edition] Protocol error when connecting to newer versions of MySQL (Martijn Tonies) 0000598: [General] Ability to generate a value based on the metadata of a blob value (Martijn Tonies) 0000599: [General] Log say it's clearing an item even when "Empty table..." is not checked (Martijn Tonies)