March 15, 2009 (2009-E for GoldBox-7, GoldBox-SQL, GoldBox-5)
ENHANCED: Dedupe 1 GoldMine Table (GoldBox-7 and GoldBox-SQL only). When choosing to COPY OUT the Dupes instead of deleting them, you can now select to include the Survivors (checkmarked). Ideal as a Preview listing to open in GXBrowser.
ENHANCED: Config Screen for GoldBox-7. You can select the Color and Highlight for all List Boxes in the system, including Global Selector, Query and Expression Builders. You can also select the Left-Handed Mouse adjustment, which causes selector buttons to appear down the left side of the screen instead of the right side.
ENHANCED: CONTACT2 field type / conversion for Setups. Logic was added to correctly handle fields added AFTER the RECID (typically RECID is the final Contact2 field), and to include conversion of some of the more exotic MSSQL field types, such as TINYINT, LONGVARCHAR, BIGINT, VARBINARY, SMALLDATETIME. Please Note: The BDE Administrator is unable to fetch fields of the type NCHAR, NTEXT, NVARCHAR, SQL_VARIANT, UNIQUEIDENTIFIER and XML.
ENHANCED: Import / Update. For Source table Write-Back at the Mapping screen, you can now choose to Add new fields without having to use a Q-file entry to Modify the Structure.
ENHANCED: Import / Update. As a Write-Back entry, you can COPY OUT the Source table when the operation ends, without a Q-file entry. For GoldBox-7 and GoldBox-SQL: Additionally, when auto-converting an ASCII / CSV / SDF file at the Import Setup screen for GoldMine, you can define an option to copy it out.
ENHANCED: Import / Update into GoldMine and Export from GoldMine. At the Mapping screen, you can define direct SQL Queries into the GoldMine database to populate fields. Ideal for including linked values in an Import/Update or Export, or for fetching Totals, Counts, Minimum/Maximum values. A QUERY button will appear at the Expression Builder. See Help panel {DIRECT-MAP a GoldMine SQL Query}.


