pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPGAccess Question
10+ messages / 7 participants
[nested] [flat]
* PGAccess Question
@ 1998-11-10 03:04 Richard Reyes <llestat@ibm.net>
0 siblings, 1 reply; 10+ messages in thread
From: Richard Reyes @ 1998-11-10 03:04 UTC (permalink / raw)
To: pgsql-interfaces
Can I run PGAccess in windows or is it using the libpqtcl library in linux.
Reason I'm asking is because the way pgaccess is set up It basically stores
everything in the database making pg access a quick an easy client/server setup.
I believe that storing Forms and other objects in Access isn't that straight
forward including VBA forms.
Richard Reyes
llestat@ibm.net
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] PGAccess Question
@ 1998-11-10 14:52 Tom Lane <tgl@sss.pgh.pa.us>
parent: Richard Reyes <llestat@ibm.net>
0 siblings, 1 reply; 10+ messages in thread
From: Tom Lane @ 1998-11-10 14:52 UTC (permalink / raw)
To: llestat@ibm.net; +Cc: pgsql-interfaces
Richard Reyes <llestat@ibm.net> writes:
> Can I run PGAccess in windows or is it using the libpqtcl library in linux.
PGAccess depends on the libpgtcl library.
The 6.4 version of libpq can be compiled for Win32. So (in theory)
it ought to be pretty easy to build libpgtcl for Windows as well.
I don't have the tools or interest to do that, but perhaps someone
on the list can prepare Windows executables for libpq and libpgtcl,
and we could make them available for download from postgresql.org.
There is also a pure-Tcl client-side library available at the PGAccess
site, IIRC. It's somewhat slower than libpgtcl/libpq but should run
almost anywhere. I don't know how closely it duplicates the
functionality of libpgtcl ... close enough for PGAccess, presumably.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] PGAccess Question
@ 1998-11-10 16:25 Sebastian Meyer <meyer@mevis.de>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 10+ messages in thread
From: Sebastian Meyer @ 1998-11-10 16:25 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: llestat@ibm.net
On Tue, 10 Nov 1998, Tom Lane wrote:
> Richard Reyes <llestat@ibm.net> writes:
> > Can I run PGAccess in windows or is it using the libpqtcl library in linux.
>
> PGAccess depends on the libpgtcl library.
> [...]
> There is also a pure-Tcl client-side library available at the PGAccess
> site, IIRC. It's somewhat slower than libpgtcl/libpq but should run
> almost anywhere. I don't know how closely it duplicates the
> functionality of libpgtcl ... close enough for PGAccess, presumably.
We use this "pure-Tcl client-side library" (pgsql.tcl, availiable on
Constantin's ftp site ftp://ftp.flex.ro/pub/pgaccess) to run Postgres apps
unmodified on Unix and Macs and really love it!
The only drawbacks are the missing support for large objects and for
crypted authentication. If you don't need these features (or feel you
could improve pgsql.tcl here) you might go this way.
sebastian
--
__o Sebastian Meyer Tel: (0421)218-7702 | "Everything should be
_ \<,_ meyer@mevis.de http://www.mevis.de | made as simple as possible,
(_)/ (_) MeVis an der Universitaet Bremen | but not simpler."
~~~~~~~~~~~ Universitaetsallee 29, D-28359 Bremen | - Albert Einstein
^ permalink raw reply [nested|flat] 10+ messages in thread
* PGAccess Question
@ 1999-01-24 19:42 Adam Williams <awilliam@whitemice.org>
0 siblings, 0 replies; 10+ messages in thread
From: Adam Williams @ 1999-01-24 19:42 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
Wow! This pgaccess thing actually seems to work, great work.
My question is wether it is possible to have a script or some command sequence
execute when a form is created, so that a user does not have to push a button
to have some defualt values loaded in the fields?
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] PGAccess Question
@ 1999-01-24 22:23 Adam Williams <awilliam@whitemice.org>
0 siblings, 0 replies; 10+ messages in thread
From: Adam Williams @ 1999-01-24 22:23 UTC (permalink / raw)
To: Stan Brown <stanb@awod.com>; +Cc: pgsql-interfaces@hub.org
On Jan 24, 5:00pm, Stan Brown wrote:
> Subject: Re: [INTERFACES] PGAccess Question
> >
> >Wow! This pgaccess thing actually seems to work, great work.
> >My question is wether it is possible to have a script or some command
sequence
> >execute when a form is created, so that a user does not have to push a
button
> >to have some defualt values loaded in the fields?
> >
>
> Couldn't you just make these fileds have default values?
The defaults of the field depend on contents of certain tables. One problem I
have is the very scant documentation for pgaccess. I haven't been able to tie
commands to the selection of radio buttons, so that depending on what one is
clicked the contents of a list box change either, radio buttons seem to execute
commands even if they are defined. Also ALL radio buttons start unselected,
whereas I should define one as the intial or default selection. I could do
all this if I could execute and initial script.
^ permalink raw reply [nested|flat] 10+ messages in thread
* pgaccess question
@ 1999-02-03 19:33 blabla <linux@blabla.8m.com>
0 siblings, 0 replies; 10+ messages in thread
From: blabla @ 1999-02-03 19:33 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
there goes the question - how can I use procedures that
reside inside another script?
Let's say I make script "Library" with few procedures in it.
And I want to call those procedures from a form / button
click... How?
tnx,
--
Alen
^ permalink raw reply [nested|flat] 10+ messages in thread
* pgaccess question
@ 1999-12-13 10:53 Michael Meskes <meskes@postgresql.org>
0 siblings, 1 reply; 10+ messages in thread
From: Michael Meskes @ 1999-12-13 10:53 UTC (permalink / raw)
To: pgsql-interfaces
I just used pgaccess for the first time and i have to say I'm impressed. But
there is one problem I have encountered. Why isn't it possible to create a
report from a view? I defined the query I like to be reported as view so I
can see the date even when using psql. But I cannot create a report from it
without doubling my effort.
Or did I miss something obvious?
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] pgaccess question
@ 1999-12-13 12:17 Hans Matzen <hans@tm.informatik.uni-frankfurt.de>
parent: Michael Meskes <meskes@postgresql.org>
0 siblings, 1 reply; 10+ messages in thread
From: Hans Matzen @ 1999-12-13 12:17 UTC (permalink / raw)
To: Michael Meskes <meskes@postgresql.org>; +Cc: pgsql-interfaces
hi Michael,
it is possible but you have to type the viewname manually in the
datasource field of the report generator. the views are not
listed but its there, believe me :-))
hans
Am Mon, 13 Dez 1999
schrieb Michael Meskes: > I just used pgaccess for the first time
and i have to say I'm impressed. But > there is one problem I have
encountered. Why isn't it possible to create a > report from a
view? I defined the query I like to be reported as view so I >
can see the date even when using psql. But I cannot create a
report from it > without doubling my effort. >
> Or did I miss something obvious?
>
> Michael
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] pgaccess question
@ 1999-12-13 14:40 Michael Meskes <meskes@postgresql.org>
parent: Hans Matzen <hans@tm.informatik.uni-frankfurt.de>
0 siblings, 1 reply; 10+ messages in thread
From: Michael Meskes @ 1999-12-13 14:40 UTC (permalink / raw)
To: Hans Matzen <hans@tm.informatik.uni-frankfurt.de>; +Cc: Michael Meskes <meskes@postgresql.org>; pgsql-interfaces
On Mon, Dec 13, 1999 at 01:17:06PM +0100, Hans Matzen wrote:
> it is possible but you have to type the viewname manually in the
> datasource field of the report generator. the views are not
> listed but its there, believe me :-))
Yup, that works. I never even thought about manually typing anything. :-)
However, I found some missing questions quite annoying. For instance it
would be nice if pgaccess asked me if I really want to close and throw away
the unsaced changes.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] pgaccess question
@ 1999-12-13 16:21 Hans Matzen <hans@tm.informatik.uni-frankfurt.de>
parent: Michael Meskes <meskes@postgresql.org>
0 siblings, 0 replies; 10+ messages in thread
From: Hans Matzen @ 1999-12-13 16:21 UTC (permalink / raw)
To: Michael Meskes <meskes@postgresql.org>; +Cc: pgsql-interfaces; Constantin Teodorescu" <teo@flex.ro>
hi,
> However, I found some missing questions quite annoying. For instance it
> would be nice if pgaccess asked me if I really want to close and throw away
> the unsaced changes.
>
it does but only in forms :-))
think we have to ask Teo if he wants to add this feature to the
report generator and maybe to others like views, tables
and so on ?
maybe this means a lot of work for him
hans
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~1999-12-13 16:21 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-10 03:04 PGAccess Question Richard Reyes <llestat@ibm.net>
1998-11-10 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
1998-11-10 16:25 ` Sebastian Meyer <meyer@mevis.de>
1999-01-24 19:42 PGAccess Question Adam Williams <awilliam@whitemice.org>
1999-01-24 22:23 Re: [INTERFACES] PGAccess Question Adam Williams <awilliam@whitemice.org>
1999-02-03 19:33 pgaccess question blabla <linux@blabla.8m.com>
1999-12-13 10:53 pgaccess question Michael Meskes <meskes@postgresql.org>
1999-12-13 12:17 ` Re: [INTERFACES] pgaccess question Hans Matzen <hans@tm.informatik.uni-frankfurt.de>
1999-12-13 14:40 ` Re: [INTERFACES] pgaccess question Michael Meskes <meskes@postgresql.org>
1999-12-13 16:21 ` Re: [INTERFACES] pgaccess question Hans Matzen <hans@tm.informatik.uni-frankfurt.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox