This script creates a new virtual table (VTAB). It was created to store data on the drop structures in a sewer network. The table created is empty, but has fields titled Node, Branch, Height, and Tailwater. The new table created is called drops.dbf
The field Node refers to the node at which the drop occurs. A drop occurs when a branch feeding into the node is at a higher elevation than the node. The difference in elevation is the height of the drop. The field Branch refers to the branch feeding the node.
The script CREATETAB is to be run in jointly with DROPDATA. This is done by creating a button in the tool bar. The Apply event is DROPDATA and the Click even is CREATETAB.
Key Avenue commands used: