GoldBox 2009-Q Released

RotaryTable() added as a new Function.  Effectively replaces RoundRobin(), PushField(), Generate() and GX_Long_Expression().  You can test this one out directly from the Expression Builder.

SmoothQuote() added as new Function.  Used in Merge Field expressions for SQL Queries, when the field you are evaluating may contain an apostrophe or single-quote, such as a Last Name, Contact Name, Street Name  or Company Name.

Merge-Purge now allows your Duplicate Expression RESULT to be a maximum of 250 characters, an increase from 99.

The freeware BR7 Utility is enhanced to allow a customized data entry screen, including field labels, mouse tips, screen title, on-screen scrollable instructions and lookup lists.  That final item - lookups - is huge, and why?  Because you can either hardcode in lookup lists or, query ANY accessible table on your system to generate them.  Used in conjunction with RotaryTable() and a Q-file, you now have an effective method of capturing user input for customized Merge Field values in downstream GoldBox operations.  Or, basic data entry for any queried data on your system.

Q-file Acknowledgment event, whereby the automation script is paused and then resumed by the User, is enhanced to NOT resume if a specific Windows application (such as BR7 Utility for data entry) is still open.

The Query Builder for GoldBox-7 and GoldBox-SQL now allows you to double-right-click the ODOMETER icon at the top corner of the screen, and generate a Fields List in the Query instead of the asterisk * character.  This is handy when you wish to select a block of fields - perhaps most of the fields in a table.  Prior to this, you had to key them in, or select them one by one from the Fields List.  Now you can have GoldBox auto-generate the Query’s Fields List, and then quite easily remove those you wish to exclude.