1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
<HTML><HEAD>
<TITLE>working with dbengine</TITLE>
</HEAD>
<BODY>
<A HREF="configuration.html"><IMG SRC="images/prev.gif" ALT="PREV"></A>
<A HREF="index.html"><IMG SRC="images/toc.gif" ALT="TOC"></A>
<A HREF="descdbase.html"><IMG SRC="images/next.gif" ALT="NEXT"></A>
<P>
<H2>Working with dbengine</H2>
For the following introduction in working with <B>dbengine</B> I assume that you've already installed and configured the CGI in your system. In addition you must have run <CODE>make test</CODE> which will result in some basic data beeing loaded into the default database [Oracle: the default user] you specified.<P>
Also you should have access to <B>dbengine</B> with the URL <A HREF="http://localhost/cgi-bin/dbengine/dbengine.cgi" TARGET="DBENGINE">http://localhost/cgi-bin/dbengine/dbengine.cgi</A> or you'll have to replace this part with whatever is valid on your system in the following text. (For your convenience you can also access our test database at <A HREF="http://cis-computer.com/cgi-bin/dbengine/dbengine.cgi" TARGET="DBENGINE">http://cis-computer.com/cgi-bin/dbengine/dbengine.cgi</A>)
<BR>
This link will create a seperate window with two frames, one of which contains a list of all the created tables in the default database [Oracle: the default user].
<P>
You can now click on either of these tables and <B>dbengine</B> will create a form on the fly that allows for entering values for the fields you've just assigned to these tables. By pressing selecting the "add" button you'll insert a new record into your database and since this is the first record it will be opened again.
<P>
<IMG SRC="images/article_edit.gif" WIDTH="778" HEIGHT="559">
If you now click on the <A HREF="http://localhost/cgi-bin/dbengine/dbengine.cgi?&table=articles&mode=plain" TARGET=body>articles link</A> on the left side of your window you'll get an empty dialog where you may enter search criteria and click on the "search" button afterwards.<BR>
<B>dbengine</B> will then come back to you and list all the records that match your request. You can choose among these records and open one by clicking on its entry to use it as a template for a new record, delete or change it.<BR>
To avoid simultaneous changes of the same record by several users <B>dbengine</B> compares the modification timestamp from the moment you've opened a record with what's in the database at the time you submit the update request. Your update wan't be done if someone else changed the record in the meantime.
<P>
Since we've defined a relation in our database cisinfo [Oracle: user cisinfo/zwerg] that connects an articles with its price records you will see an additional List with all prices of a choosen article. This list is also multi-updateable...
<P>
<A HREF="configuration.html"><IMG SRC="images/prev.gif" ALT="PREV"></A>
<A HREF="index.html"><IMG SRC="images/toc.gif" ALT="TOC"></A>
<A HREF="descdbase.html"><IMG SRC="images/next.gif" ALT="NEXT"></A>
</BODY>
</HTML>
|
