MassUpdate

This feature will let you Mass Update your current Table.

For example you want to change to UPPERCASE all the fields 'FirstName' IF the field 'Title' is set to 'Mr' but you also want to convert to LOWERCASE all the fields 'LastName' IF the value of the field 'Title' is set to 'Mme'

This feature will easily let you achieve this.

You have in this list all COLUMNS then the sign '=' then the EXPRESSION to use (as update)

You can enter the Expression directly in Edit In Place mode you you want to - then use the "TAB" key to check it's validity and depending on the result an icon will appear in the next Column to let you know !

The Column 'Before' contains the data found in the last record of your Table

The Column 'After' contains the same data as it will show AFTER applying the EXPRESSION entered

You can also double-click on the icon on the right of the EXPRESSION field to build the EXPRESSION (and eventual CONDITION)

This is how the screen will show after entering your expressions and eventual conditions

When they are all defined you can save your mass Update queries for further use by selecting the "Stored QBE's" Tab :

Saving a Mass Update set of queries :

ONLY when all are properly defined can you Store them all for further use by clicking on the "Stored QBE's" Tab

Applying the Mass Update :

Use the "Apply" button and after process and progress bar the resulting new data will be shown

Before :

Look at LASTNAME column .....

And After :

The LASTNAME fields of customers where the condition matches have been changed to LOWERCASE .....

Visibly there are no customers from 'AL' in this table ....

ReInitialize the data :

Use the appropriate button to reset all data to it's original state

The "Save" button will be hidden as the current data is as original

NOTE : as the queries are still in memory after resetting the data you can simply click on "Mass Update" to have access to the stored queries for you to modify or change or extend....

Save to File :

If you are satisfied with your mass Update you can use this button to save all modifications to the table