Viewer > Mass Update & QBE

This feature will let you Mass Update your current Table.

The column PICTURE is displayed in a column on the RIGHT - use the Horizontal bar to access it

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.

dmc_viewer_mu_main_empty

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 if 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 !

If you work on Column CompanyName for example enter simply UPPER(CompanyName) and do NOT enter CompanyName = UPPER(CompanyName)

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) and this is the Query Builder you will see

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

dmc_viewer_mu_filled_col2

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 :

From version 1.6.0.3 you are offered a popup message when you hit the 'Apply' button to save the Query : enter a UNIQUE name and click 'Yes' or discard by clicking on 'No'

ONLY when all are properly defined can you Store them for further use by clicking on the "Stored Queries" Tab AFTER using the "Apply" button and FIRST giving it a Unique NAME

Applying the Mass Update :

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

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