|
Build Query |
|
|
You can build in this screen either the QBE queries or the Mass Update ones
Depending on which is used will open or not the EXPRESSION field
To check if your EXPRESSION or CONDITION is good and valid simply use the "TAB" key and an icon on the right will show the result
Mass Update Queries :
In Mass Update when you are working on a column, it's NAME will be displayed for your visual help like in this screen :
Here you had selected the Column 'FIRSTNAME' and are building a query to convert to UPPERCASE if the STATE field contains 'AL'
When you have defined such a COLUMN query you can save it for further use BUT you have to save ONLY when ALL columns expressions and eventual conditions are defined
You can click on "Cancel" to revert o the previous screen.
You can click on "Apply" to add these to the Mass Update and you will then be shown this screen :
As you can see in the column FIRSTNAME your expression and condition have been added and evaluated : it this case the return a SUCCESS showing with the Green Icon AND the AFTER column value has changed to what you will get.
Carry on building your Mass Update queries and conditions till you are satisfied with them For example this other one on LASTNAME column.....
QBE Query :
In QBE's there is no expression field and only the QBE field is open for input
Build the query like described here
Again using the TAB key will tell you if the QBE is valide or not with the appropriate icon
For example we want to list only CUSTNUMBER > 4 AND CUSTNUMBER < 6
You can Save this QBE like this
You click on "Apply" to process this query and obtain the result set (or on "Cancel" to revert to previous screen)
The query is displayed onscreen for your information
You can use the ReInitialize button to reset all data to original sate
You can then apply another stored QBE or create a new one and Apply it .....
You can EXPORT this subset to CSV - XML or any of the SendTo possibilities also at this stage without tampering with your Table
|