Skip to content

Commit 09b1875

Browse files
bmomjianbmomjian
committed
Install new 0.81 pgaccess release.
1 parent 2fb6437 commit 09b1875

File tree

7 files changed

+1321
-18
lines changed

7 files changed

+1321
-18
lines changed

‎src/bin/pgaccess/README.pga

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -24,7 +24,7 @@ PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
2424

2525

2626

27-
PGACCESS 0.76 , 12 January 1998
27+
PGACCESS 0.81 1 March 1998
2828
================================
2929
I dedicate this program to my little 4 year daughter Ana-Maria and my wife
3030
for their understanding. I hope they will forgive me for spending so many
@@ -126,7 +126,9 @@ Reports
126126
- table previews, sample postscript print
127127

128128
Forms
129-
- open user defined forms, form design module not yet available
129+
- open user defined forms
130+
- form design module available
131+
- query widget qlowing access to a recordset
130132

131133
Scripts
132134
- define, modify and call user defined scripts

‎src/bin/pgaccess/forms.html

Lines changed: 104 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,104 @@
1+
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
2+
<HTML>
3+
<HEAD>
4+
<TITLE></TITLE>
5+
<META NAME="GENERATOR" CONTENT="Mozilla/3.04Gold (X11; I; Linux 2.0.32 i586) [Netscape]">
6+
</HEAD>
7+
<BODY TEXT="#000000" BGCOLOR="#FFEBCD" LINK="#0000EF" VLINK="#51188E" ALINK="#FF0000">
8+
9+
<H1>FORMS</H1>
10+
11+
<P>
12+
<HR WIDTH="100%"></P>
13+
14+
<P>This version (0.81) of PgAccess introduce the visual form builder.</P>
15+
16+
<P>For the moment, it has only some basic widgets : labels, entries, buttons
17+
, listboxes , checkboxes and radiobuttons.</P>
18+
19+
<P>Also there is a query widget that allows you yo have access to a query
20+
results.</P>
21+
22+
<P>In a manner very similar with Visual Tcl or Visual Basic, the user must
23+
select a widget from the toolbar and drags on the canvas the rectangle
24+
that would define the widget. It can also specify some attributes in a
25+
separate window. Renaming, resizing items are possible modifying parameters
26+
in attribute window. Do not forget to press Enter in the edit field after
27+
changing a value in order to be accepted.</P>
28+
29+
<P>You can also move items by dragging them or delete them by pressing
30+
Del key.</P>
31+
32+
<P>In attribute window, there are some fields named <B><TT><FONT SIZE=+1>Command
33+
</FONT></TT></B>and <B><TT><FONT SIZE=+1>Variable</FONT></TT></B>.</P>
34+
35+
<P>The field <B><TT><FONT SIZE=+1>Command </FONT></TT></B>have meaning
36+
only for Button widgets and holds the command that will be invoked when
37+
the button is pressed.</P>
38+
39+
<P>The field <B><TT><FONT SIZE=+1>Variable </FONT></TT></B>have meaning
40+
only for EditField , Label widgets and checkboxes and it is the name of
41+
the global variable that will hold the value for that widget. For checkboxes
42+
the values are 1 or 0.</P>
43+
44+
<P>In order to make a simple test, put an entry field and set it's variable
45+
to <B>v1</B> and a button who's command is &quot;set v1 whisky&quot;. Press
46+
the button &quot;Test form&quot; and click on the button. In that entry
47+
should appear whisky. <BR>
48+
Another test is defining in Script module a script called &quot;My first
49+
script&quot; having the following commands:<BR>
50+
<TT><FONT SIZE=+1>tk_messageBox -title Warning -message &quot;This is my
51+
first message!&quot;<BR>
52+
</FONT></TT>and then define a button who's command is <B><TT><FONT SIZE=+1>execute_script
53+
&quot;My first script&quot;</FONT></TT></B>.</P>
54+
55+
<H2>Database manipulation</H2>
56+
57+
<P>Let's presume that our form have the internal name <B><TT>mf </TT></B>(my
58+
form). He wil be referred inside the Tcl/Tk source as <B><TT>.mf<BR>
59+
</TT></B>If you want to close the form in run-time you have to issue the
60+
command <B><TT>destroy .mf</TT></B></P>
61+
62+
<P>Also, any widget will have the name prefixed by <B><TT>.mf </TT></B>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;We
63+
will have <B><TT>.mf.button1</TT></B> or <B><TT>.mf.listbox1</TT></B> .</P>
64+
65+
<P>We can name the query widget <B><TT>qry</TT></B> for example. The complete
66+
name will be <B><TT>.mf.qry</TT></B> then.<BR>
67+
The <B><TT>Command </TT></B>property of the query widget must contain the
68+
SQL command that will be executed.<BR>
69+
When the form will be in run-time, automatically you will have acces to
70+
the following methods :</P>
71+
72+
<P><TT>.mf.qry:execute</TT> - opens the connection and execute the query
73+
(returns nothing)<BR>
74+
<TT>.mf.qry:nrecords</TT> - returns the number of records in the selected
75+
query<BR>
76+
<TT>.mf.qry:fields</TT> - returns a list of the fields in the result set<BR>
77+
<TT>.mf.qry:movefirst</TT> - move the cursor to the first record in the
78+
recordset<BR>
79+
<TT>.mf.qry:movelast , .mf.qry:movenext , .mf.qry:moveprevious </TT>- moves
80+
the cursor <BR>
81+
<TT>.mf.qry:updatecontrols</TT> - update the variables inside the designed
82+
form that have a particular name (I'll explain later)<BR>
83+
<TT>.mf.qry:close</TT> - close the connection (<B><FONT COLOR="#FF0000">if
84+
you don't close the query result, you will loose memory</FONT></B>)</P>
85+
86+
<P>If you want to bound some controls to the fields of the recordset, you
87+
will have to name their associate variable like that :</P>
88+
89+
<P><TT>.mf.qry.salary</TT> to get the &quot;salary&quot; field , or <TT>.mf.qry.name</TT>
90+
to get the &quot;name&quot; field.</P>
91+
92+
<P>It's simple, isn't it ? It's just like a new widget that have some properties
93+
and methods that can be accesed.<BR>
94+
Also, the name convention is just like in Tcl/Tk.</P>
95+
96+
<P>
97+
<HR WIDTH="25%"></P>
98+
99+
<P>Please feel free to send me your oppinion at <B>teo@flex.ro</B> on forms
100+
designing and usage.<BR>
101+
</P>
102+
103+
</BODY>
104+
</HTML>

‎src/bin/pgaccess/index.html

Lines changed: 124 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,124 @@
1+
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
2+
<HTML>
3+
<HEAD>
4+
<TITLE>PgAccess - a Tcl/Tk PostgreSQL interface</TITLE>
5+
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
6+
<META NAME="GENERATOR" CONTENT="Mozilla/3.04Gold (X11; I; Linux 2.0.32 i586) [Netscape]">
7+
</HEAD>
8+
<BODY BGCOLOR="#FFFFFF">
9+
10+
<H1>PgAccess - a database management tool for <A HREF="http://www.postgreSQL.org">PostgreSQL</A></H1>
11+
12+
<P>
13+
<HR></P>
14+
15+
<P>This program is protected by the following <A HREF="copyright.html">copyright</A>
16+
</P>
17+
18+
<LI><A HREF="pgaccess-0.81.tar.gz">Download the last version of Pgaccess
19+
(press shift and click this link)</A>.</LI>
20+
21+
<P>Latest version of PgAccess is 0.81 , 1 March 1998 ! </P>
22+
23+
<CENTER><TABLE BORDER=3 CELLSPACING=0 CELLPADDING=0 WIDTH="100%" BGCOLOR="#FFB6C1" >
24+
<TR>
25+
<TD>
26+
<CENTER><P><BR>
27+
<B><FONT SIZE=+2>PgAccess can now design <A HREF="forms.html">Forms</A></FONT></B>,
28+
<B><FONT SIZE=+2><A HREF="pga-rad.html">Reports and Scripts</A></FONT></B></P></CENTER>
29+
</TD>
30+
</TR>
31+
</TABLE></CENTER>
32+
33+
<P>I think that there were some problems loading libpgtcl library. <BR>
34+
I invite you to read a <A HREF="index.html#libpgtcl">special section concerning
35+
<B>libpgtcl</B></A> </P>
36+
37+
<H3><FONT COLOR="#191970">What does PgAccess now!</FONT></H3>
38+
39+
<P>Here are some images from PgAccess windows : <A HREF="pic-pga-1.gif">Main
40+
window </A>, <A HREF="pic-pga-2.gif">table builder </A>, <A HREF="pic-pga-4.gif">table(query)
41+
view </A>, <A HREF="pic-pga-3.gif">visual query builder </A>. </P>
42+
43+
<P><B>Tables</B> <BR>
44+
- opening tables for viewing, max 200 records (changed by preferences menu)
45+
<BR>
46+
- column resizing, dragging the vertical grid line (better in table space
47+
rather than in the table header) <BR>
48+
- text wrap in cells - layout saved for every table <BR>
49+
- import/export to external files (SDF,CSV) <BR>
50+
- filter capabilities (enter filter like (price&gt;3.14) <BR>
51+
- sort order capabilities (enter manually the sort field(s)) <BR>
52+
- editing in place <BR>
53+
- improved table generator assistant <BR>
54+
- improved field editing <BR>
55+
<B>Queries</B> <BR>
56+
- define , edit and stores &quot;user defined queries&quot; <BR>
57+
- store queries as views <BR>
58+
- execution of queries <BR>
59+
- viewing of select type queries result <BR>
60+
- query deleting and renaming <BR>
61+
- <B><BLINK><FONT COLOR="#FF0000">NEW !!!</FONT></BLINK></B> Visual query
62+
builder with drag &amp; drop capabilities. For any of you who had installed
63+
the Tcl/Tk plugin for Netscape Navigator, you can see it at work <A HREF="qbtclet.html">clicking
64+
here</A> <BR>
65+
<B>Sequences</B> <BR>
66+
- defines sequences, delete them and inspect them <BR>
67+
<B>Functions</B> <BR>
68+
- define, inspect and delete functions in SQL language <BR>
69+
<B>Reports<BR>
70+
</B>- design and display simple reports from tables<BR>
71+
- fields and labels, font changing, style and size<BR>
72+
- saves and loads report description from database<BR>
73+
- show report previews, sample postscript output file<BR>
74+
<B>Forms<BR>
75+
</B>- open user defined forms<BR>
76+
- form design module available<BR>
77+
- query widget available, controls bound to query results<BR>
78+
- <A HREF="forms.html">click here</A> for a description of forms and how
79+
they can be used<BR>
80+
<B>Scripts<BR>
81+
</B>- define, modify and call user defined scripts<BR>
82+
Here is <A HREF="pga-rad.html">a special section concerning forms and scripts</A>
83+
.</P>
84+
85+
<P>On the TODO list! <BR>
86+
- table design (add new fields, renaming, etc.) <BR>
87+
<BR>
88+
&nbsp; </P>
89+
90+
<P>If you have any comment, suggestion for improvements, please feel free
91+
to e-mail to : <A HREF="mailto:teo@flex.ro">teo@flex.ro&nbsp;</A> <BR>
92+
</P>
93+
94+
<P><B><FONT COLOR="#FF1493"><FONT SIZE=+2>Mailing list for PgAccess </FONT></FONT></B><A HREF="maillist.html">Here
95+
you will find how to subscribe to this mailing list</A>.</P>
96+
97+
<P>
98+
<HR></P>
99+
100+
<H1>More information about libgtcl</H1>
101+
102+
<P>Also, you will need the PostgreSQL to Tcl interface library, lined as
103+
a Tcl/Tk 'load'-able module. It is called libpgtcl and the source is located
104+
in the PostgreSQL directory /src/interfaces/libpgtcl. Specifically, you
105+
will need a libpgtcl library that is 'load'-able from Tcl/Tk. This is technically
106+
different from an ordinary PostgreSQL loadable object file, because libpgtcl
107+
is a collection of object files. Under Linux, this is called libpgtcl.so.
108+
<BR>
109+
You can download <A HREF="libpgtcl.so">from here </A>a version already
110+
compiled for Linux i386 systems. Just copy libpgtcl.so into your system
111+
library director (/usr/lib) and go for it. One of the solutions is to remove
112+
from the source the line containing <B>load libpgtcl.so </B>and to load
113+
pgaccess.tcl not with wish, but with pgwish (or wishpg) that wish that
114+
was linked with libpgtcl library! </P>
115+
116+
<P>If you have installed RedHat 5.0, you should get the last distribution
117+
kit of postgreSQL and compile it from scratch. RedHat 5.0 is using some
118+
new versions of libraries and you have to compile and install again at
119+
least <B>libpq </B>and <B><TT>libpgtcl </TT></B>libraries.</P>
120+
121+
<P>However, the application should work without problems! </P>
122+
123+
</BODY>
124+
</HTML>

‎src/bin/pgaccess/maillist.html

Lines changed: 43 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,43 @@
1+
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
2+
<HTML>
3+
<HEAD>
4+
<TITLE></TITLE>
5+
<META NAME="GENERATOR" CONTENT="Mozilla/3.04Gold (X11; I; Linux 2.0.32 i586) [Netscape]">
6+
</HEAD>
7+
<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#0000EF" VLINK="#51188E" ALINK="#FF0000">
8+
9+
<P>The mailing list for PgAccess is : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><TT>pgsql-interfaces@postgresql.org</TT></B></P>
10+
11+
<P>If you have some questions regarding PgAccess you should mail to this
12+
address. I will also answer to messages addresed directly to me but it
13+
would be better to post your messages here because it might be possible
14+
to get an answer quickly from another user of PgAccess.</P>
15+
16+
<P>
17+
<HR WIDTH="100%"></P>
18+
19+
<P>To subscribe please send a mail message to&nbsp;:</P>
20+
21+
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><TT><FONT SIZE=+1>pgsql-interfaces-request@postgresql.org
22+
</FONT></TT></B>&nbsp;</P>
23+
24+
<P>having a single line in the body message :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<B><TT><FONT SIZE=+1>subscribe</FONT></TT></B></P>
25+
26+
<P>In a couple of minutes , if everything is ok, you must receive something
27+
like that :</P>
28+
29+
<P>
30+
<HR WIDTH="100%"></P>
31+
32+
<P><TT>Welcome to the pgsql-interfaces mailing list!</TT></P>
33+
34+
<P><TT>Please save this message for future reference. Thank you.</TT></P>
35+
36+
<P><TT>If you ever want to remove yourself from this mailing list, you
37+
can send mail to &lt;Majordomo@hub.org&gt; with the following command in
38+
the body of your email message:</TT></P>
39+
40+
<P><TT>unsubscribe pgsql-interfaces yourname@yourdomain</TT></P>
41+
<TT></TT>
42+
</BODY>
43+
</HTML>

0 commit comments

Comments
 (0)