This release is a bunch of small enhancements. These include added warning messages when formula used are not correct, some user interface improvements and some enhancements about formula settings.
Message for Update Data
Warning message is added when formula used to patch data is not correct. To accessing this function, press “Amend Data” button in Main Menu and a window will pop out in the bottom right part.
Inside the window, you can use SQL formula to update or patch data in the database. This feature is convenient when you need to update a number of records altogether, or you need to update some data fields that are not shown in the worksheets, for some special reasons out of your normal operations.
This enhancement is that when your formula applied is not correct, now there is a message notifying what’s wrong with the formula.
Processing of Data after Saving Record
The other two enhancements are related to data processing after record saving. In each worksheet, you can set up formulas for processing of data that are inside the worksheet or in the other worksheets, in order to fulfill your business automation and requirements.
You can find the formula setting in Main Menu -> Worksheet Setting -> Processing After Document Saved, which is near the bottom of the page of Worksheet Setting.
In the setting, there are Counter Formula and Update Formula. Counter Formula calculates some values which are then transferred and replaced in the corresponding Update Formula for updating records. To replace values in the Update Formula, these keywords are used : “value”, “value1”, “value2”, … and so on. Before this enhancement, only up to “value9” can be used in the Update Formula. Now, this update allows up to “value99” for replacing values, which should be more than enough for normal use cases.
Dummy Counter Formula
It is possible in some use cases to execute Update Formula only without running query in Counter Formula. Before, a dummy counter formula “Select Dummy from tblDummy” is required, even though no actual meaningful calculation or result is obtained from this expression. This update allows just to leave counter formula blank when there is no calculation or query required to supplement the update formula.
These enhancements are all small fixes that help the program better communicate with end users, and these updates let you get a glimpse of a few convenient features of Bau DB and why Bau DB is an interesting and fun tool 🙂 to create automated database solutions by yourself without much requirement of technical know-how.
How do I Update
As usual, to get the update, simply download from the download page and install it on top of your current installation.