December 9th, 2009· New field with support of formatting (RTF). Store and edit full-fledged text with any fonts, highlighting, colour, pictures and so on.
· Graphs. Version 8 features a new system of making up graphs and reports, allowing you to display 9 different types of graphs, combine them, make up dynamic graphs and display all of them right on the main screen of the program.
· Reports. Now you can more easily get the total and subtotal for the selection of records, group it by any field and execute any operation or a script for the selection.
· Highlighting with colour by rules. It is now possible to specify different colour schemes depending on fields’ values for tables and reports. For example, you can highlight non-paid orders with red, and paid orders – with green.
· Entirely reviewed and simplified mechanism of importing data from external sources (Internet pages, Outlook, text documents and so on). To import, for example, actual currency rates to your database, you even do not have to write scripts.
· Possibility of work with external database. Now it is very easy to work with an external Access or Excel database. You can input data to the external database, as well as read it from there.
· Managing folders. You can block standard operations for every folder – manual dragging of records, creating or deleting records when pressing the Delete key and so on. You can also link every type of records to a specific folder so that when a record created from the Add menu, it is automatically placed to a necessary folder.
· Field for working with files. Now you can store files of any type right in the record, in a specific field. In contrast to usual attachments, using one or several fields will allow you to structure files.
· Managing work over the network with scripts. Using specific commands in scripts, you can send messages over the network, break connections, make a database available over the network.
· Mask for simple fields. For example, you can define the “###-XX” mask to allow entering only three digits and two letters in the specified field.
· A possibility to specify color, picture and transparency for table background (by, default, dark grey) is added
· Execution of queries for regular users (not administrators) is optimized
· A possibility to change passwords by regular users (not administrators) is added
· A possibility to specify a variant for opening a record from the "Find Records" dialog, either in a new window or in the main program window, is added (the "View > Advanced…" menu)
· A possibility to grey out text fields blocked for editing is added (the "View > Advanced…" menu)
· Work with huge forms with many tabs is optimized
· Reliability of program work by the network is significantly increased.
· Maximum number of queries to one database is increased to 1024.
· Support for formatting numbers of the "math #00.00" type is added, for adding leading zeros to a number.
· New Find/Replace dialog with AND/OR support.
· Predefined variable [$old_value] for the “On Change” script - it stores previous value of a field.
· Mathematics – new operator: % - returns residue of division.
· Improved backup.
· Printing – possibility to print each group on a new page.
· New actions palette.
· “Real Delete” action
· New “On software close” timer – allows executing a script then user tries to close the software.
· Text Button: An entered value can be copied to the [$input] variable.
· Restoring records from the recycle bin to the source folder.
· A possibility to specify a layout separately for every folder — a list of records, a list and form, only form — is added.
· New Query and Report wizard.
· Additional actions for fields are added that can be re-assigned (pressing Enter, right-click and so on).
· A possibility to mark fields as system is added. The fields become not available to the user at search, manual sorting and so on.
· Improved Report Style Editor
· Custom Export Templates are split into more convenient Send e-mail, Create a Web Page, Copy to Ms Word, Copy to Clipboard and Export to text file templates.
· New operations for formatting text are added to the existing 20 ones: MD5 – get hash of a string, and SIZE – get the length of a string.
· A possibility to clone folders is added.
· Fast static formulas (the same for all records) are added.
· A possibility to prohibit a database user to display or hide specific columns in a table is added.
December 9th, 2009· Complete support of Windows Vista.
· New interface and support of Windows XP/Vista styles
· New database engine. Queries are executed significantly faster comparing to the previous version, work with a remote database does not differ from work with a local database. Now you can add/remove file attachments, change images and perform any operations available at the local machine from the remote computer. The smart system of data buffering will help reduce net loading.
· New system of differentiating access to the database. Now you can create users and groups of users with different access levels for your database - reading/writing/administrator. You can specify a password for each user and set a greeting screen (at logon into the system) at your discretion. You can also set access levels individually for every folder or records.
· Only necessary tools for every group of users. Now you can easily set the appearance of the database and its options for different groups of users. You can specify users practically for all elements of the database (tools on the toolbar, fields, timers), for whom such elements will be visible. For example, you can create the Operators group and hide from it all fields with financial information and buttons for reports generation; or create the Managers group for whom the reports generation buttons will be accessible.
· Programming the fields behaviour. At present the fields behaviour can be predefined using standard templates or scripts. For example, you can open an image for editing by double-clicking an image fields instead of a standard pop-up menu, or start scanning. When the name of a client in a usual text field is changed, he or she can be searched for in the database.
· A new query editor allows you to create complex queries with several levels of conditions as easily as before using simple visual tools. Now you can group results of queries into collapsing subgroups and get subtotals; for example, you can group orders by countries or managers and get grouped sales sums.
A lot of other convenient changes:
· Dependent drop-down menus (lists) have been added. For example, you can create two fields: Counties and Cities, where the value of the second field will be changed at changing of the first field value.
· Support of scrolling in all editors of the application and in the main window has been improved.
· The maximum size of files stored within the database (attachments) has been increased. Now you can attach to records files sized up to 64 Mb.
· A new component of spell checking allows you to automatically correct errors.