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

What is the Advanced Queries And Formulas 2.0?

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.

Installation

Copy advcalc2.avx file to the ArcView extension drectory.

Loading

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.

Calculating a field's values

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.

Making queries

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.

Contact me

Send enhancement requests, feedback, or bug information about it on bvasily@mail.ru


Reverie Group, 1999