Database Access "Classic"
Oil & Gas
to the SONRIS "Classic" Oil & Gas Information Database
Query Component? Here's what you need to start
a level 4 or better browser. DNR recommends the free Microsoft
Internet Explorer 5 web browser, which supports all
SONRIS components. Netscape only supports some SONRIS
components. Thus, internally, DNR uses Internet Explorer
5 for all SONRIS development and access.
a browser add-on from DNR called JInitiator. SONRIS
uses Oracle and Java technology to deliver information
to you via the Java JInitiator 188.8.131.52 (developed by
Oracle Corporation) which configures your browser to
insure proper performance. JInitiator is required to
access SONRIS database applications, and is available
from DNR as a free download or on CDROM. JInitiator is
9.29MB in size, so allow adequate download
time based on the speed of your Internet connection.
You can visit the JInitiator
page for more information.
that you have the right browser and JInitiator, link
to http://www.sonris.com for the SONRIS
When the SONRIS Home
Page is displayed as shown below, in the left frame click on either
General Reports to display one of the following screens that allow
access to the SONRIS Business Application's screens
Click on "Conservation"
to display the following screen.
Click on "Minerals"
to display the following screen.
Click on "General
Reports" to display the following screen.
the Applet has completed, the SONRIS Oil & Gas
Query Main Menu is displayed, like the following...
Items on each menu
represent a form, or screen, from which you can initiate queries into
the 40,000,000 records contained in the SONRIS Oil & Gas database.
A form is SONRIS terminology for a screen of information...when a form
is originally displayed for you, it is blank, and you need to tell SONRIS
via a query what information you want to appear on the form. As an example,
let's assume you are looking for information on a particular well, and
you already know that the Well Serial Number is 220083
Press the item that
blank form entitled Retrieve Well Profile is then
the Well Profile form, build your query by entering
your well serial number...
what is a query? A question...essentially,
you ENTER criteria about the information you want displayed,
then EXECUTE the query in order for SONRIS to obtain the
information. Perform a query as follows:
Under QUERY on the menu bar of a form you've displayed
are located both ENTER and EXECUTE.
Click on QUERY / ENTER
your query criteria, e.g., a Well Serial Number,
in our example 220083
Click on QUERY / EXECUTE (or press the F8 EXECUTE
you can follow this procedure...
the query buttons on the menu bar
on the Query Enter button
your query criteria, well 220083
on the Query Execute button
you press the EXECUTE query button, your information
will be displayed as follows...
few other important query tips!!
entered data to start the query, but I've changed my
mind. How do I cancel a query before I execute it?
On the menu bar, click QUERY / CANCEL, or click the Query
I completed a query. How do
I remove the information so I can make another query
using the same form?
On the menu bar, click on ACTION / CLEAR ALL
there a wildcard character that I can use in a SONRIS
Yes. The percent sign % is the wildcard
character. For example if you did a query on WOOD%,
you might get a response back that included WOODVILLE,
WOODBAYOU, WOODRIVER and WOODSTONE.
is a list of values and how do I do it?
fields or data elements on a SONRIS form have available
what is called a "list of values". With your cursor
in that field, pressing the F9 key will instruct SONRIS
to pop open a small window containing all of the valid
values from which you can choose.
tips about using the Oil and Gas Information Component
are available in the SONRIS
to other SONRIS Oil & Gas forms...
can continue to access information from one form multiple
times, as many times as you need. For example, you may
want to query several different well serial numbers. Once
finished with a specific form, you will need to exit back
to the SONRIS Oil & Gas Main Menu.
Press the "Exit Door" icon
(third icon from the left) or click on ACTION / EXIT on Menu Bar. You
will be returned to the SONRIS Oil & Gas Main Menu.
Once back to the Main
Menu, you can execute other forms as you need to.
out of the SONRIS Oil & Gas Application Component
you are finished accessing information, and you are on
the SONRIS Oil & Gas Main Menu, you have three options
to exit out of SONRIS:
- Press the "Exit
Door" icon ,
Press ACTION / EXIT on Menu Bar, or
the large "EXIT" button in the top right-hand corner
the following window is displayed, click on YES to exit
that you have a quick overview of how the Oil &
Gas Component works, where do you want to go next?
Frequently Asked Questions (FAQs)