GSDS Home

Introduction

What's new in WellSim

FAQ

What is WellSim ?

Tutorials

Getting familiar with WellSim

Entering well geometry

Entering well data

Discharge simulations

Improving a discharge simulation

Output simulations

Tips for using WellSim

Changing how WellSim looks

Reservoir drawdown simulation

Injection simulations

Injectivity simulations

Advanced simulations

Reference

How WellSim works

Managing databases

Graphs

Exporting data

Importing data

Units

Preferences

References

Glossary

Installing WellSim

For evaluation

Setup with a key

On another PC

Upgrading WellSim

Registration

Single-user dongle

Network dongle

Uninstalling

w# Making ad hoc queries of the database

You can make ad hoc queries on any tables in the database. Ad hoc queries let you:

• do more than you can do in WellSim

• do what you can already do in WellSim, but do it faster.

Warning

This lets you you can change and delete parts of the database, which might delete some of your data or cause WellSim to crash.

• Only use this if you know what you are doing.

• Before you start, back up the database.

Making queries

To query an SQL server database you must have Administrator permission.

From within WellSim, click Tools in the menu bar, then click Database Administration to display:

The left has a list of all tables in the currently-open database and the right is to type SQL queries.

After you have finished:

1. Close this window.
2. If you made any changes to the database, close WellSim and restart it again, to ensure the database is refreshed.

Note

• The formats for SQL queries for Access and SQL server differ slightly; these examples use the sample database, and so are for Access.

• Here, table names are all capitals (WELL) and column names are first letters capital (Well).

• Data in the database is in SI units.

• Complex queries can take a long time to run.