|
Advanced Queries And Formulas 2.0 |
What is the Advanced Queries And Formulas
2.0?
Installation
Loading
Calculating a field's values
Making queries
Contact me
This extension can store user formulas for calculating values fields of tables and users queries for tables and themes of views in ArcView project and extends the standard Field Calculator and QueryBuilder for ArcView Tables and Views.
This extension deliver you from onerous work.
Copy advcalc2.avx file to the ArcView extension drectory.
To use the Advanced Queries And Formulas extension, you load first it into ArcView - just like you load any other ArcView extension.
Once you load the extension, you'll notice a new buttons 
(Advanced Query Builder) and 
(Advanced Queries And
Formulas) in the Table user interface, and (Advanced Query Builder) in the View user
interface.
Load the Advanced Queries And Formulas 2.0 extension.
Your actions to calculate a value for a field in the table.
1. Choose Start Editing from the Table menu.
2. Click on the name of the field you wish to calculate.
3. Click the Advanced Field Calculator button .
In the Advanced Calculator dialog you can additionally to
action in standart Field Calculator:
- choose by double-clicking a formula from the Formulas
list for the active field. Then the formula will be
placed in the input area;
- switch the Formulas list mode to display all
project formulas (check box Display all project formulas
is checked), or to display only binded formulas to selected field
of current table (unchecked);
- store the result expression from the input area into the Formulas
list by Add button;
- remove unneeded formula from the Formulas list
for the active field by pressing the Delete button.
Also when the Formulas list display all
project formulas (check box Display all project formulas
is checked) you can:
- delete unbinded formulas by Garbage button;
- export project formulas from the Formulas list into
DBF table by Export button;
- import formulas from DBF table into the Formulas list
by Import button.
The calculation applies to the selected set of records. If no records are selected, the calculation applies to all records.
The user formulas and queries are stored in the ArcView project.
Your actions to make query for the table.
Click the Advanced Query Builder button .
In the Advanced Query Builder dialog you can:
- use standart Query Builder dialog to make query expression in
input area (button with hammer);
- choose by double-clicking a query from the Queries list;
- switch the Queries list mode to display all
project queries (check box Display all project queries
is checked), or to display only binded queries for the table
(unchecked);
- store the result querie from the input area into the Queries
list by Add button;
- remove unneeded querie from the Queries list for
the table by pressing the Delete button.
Also when the Queries list display all project
queries (check box Display all project queries
is checked) you can:
- delete unbinded queries by Garbage button;
- export project queries from the Queries list into
DBF table by Export button;
- import queries from DBF table into the Queries list by
Import button.
Title of Advanced Query Builder dialog is table name.
Your actions to make query for the theme of the view.
Click the Advanced Query Builder button .
In the Advanced Query Builder dialog you can:
- use standart Query Builder dialog to make query expression in
input area (button with hammer);
- choose by double-clicking a query from the Queries list;
- switch the Queries list mode to display all
project queries (check box Display all project queries
is checked), or to display only binded queries for the theme and
view (unchecked);
- store the result querie from the input area into the Queries
list by Add button;
- remove unneeded querie from the Queries list for
the table by pressing the Delete button.
Also when the Queries list display all
project queries (check box Display all project queries
is checked) you can:
- delete unbinded queries by Garbage button;
- export project queries from the Queries list into
DBF table by Export button;
- import queries from DBF table into the Queries list by
Import button.
Title of Advanced Query Builder dialog is view name + " - " + theme name.
The user formulas and queries are stored in the ArcView project.
Send enhancement requests, feedback, or bug information about it on bvasily@mail.ru
Reverie Group, 1999