Pressure Pipes

Pressure pipes
Changing the Material of a pipe.

You will need:
1. SQL Lite editor
2. Backup of pressure pipe catalog.

1. open you SQL Lite editor and open this catalog file . Imperial_AWWA_PushOn.sqlite

Find this database called WA_MATERIAL_TBD

1. Click on the left of the title the little arrow to expand the database, then right click on the 'Columns' and select 'Edit table'.
2. When the window opens the VALUE heading contains the materials you can use for pressure networks (push-on).
3. Change the value you want. I change the value of 'ductile iron' to just DIP to make my labels smaller. 
4. When you're done making your changes. click on the check mark 'commit changes' or hit Ctrl+Enter. Then go to the menu 'View' and select 'close selected window'. 
5. Disconnect the SQL database before closing SQLLiteStudio. It is the second button from the let on the top menu.
6. You can now close SQL LiteStudio.