From: Fred Parkinson <FredP@abag.ca.gov>
To: brooks.glenn@comcast.net
To: pgsql-admin@postgresql.org
Subject: Re: help with Postgres forms (Pfm)
Date: Fri, 20 Jan 2012 06:15:37 -0800
Message-ID: <4F190689020000A70001AF6F@gwia1.abag.ca.gov> (raw)
In-Reply-To: <1024253310.896552.1327038181121.JavaMail.root@sz0007a.emeryville.ca.mail.comcast.net>
References: <1024253310.896552.1327038181121.JavaMail.root@sz0007a.emeryville.ca.mail.comcast.net>
I have been using M$ Access for about 12 years now to create forms to update postgresql data.
I use the postgresql odbc driver to establish a connection
There were a few issues to be worked out, for example getting Access and postgresql to agree on how to handle boolean fields, how to fetch the key field from postgresql after it adds a record (I think that has improved since I started with ver. 7.x), but really not much else.
If you are interested I can post a few details.
Fred Parkinson
Application Programmer
Association of Bay Area Governments
510-464-7931
>>> <brooks.glenn@comcast.net> 01/19/2012 9:43 PM >>>
Am trying to come up with a forms based front end (windows 7 localhost) to enter and update a lot of data in several related tables within 9.1.
I have tried to install Postgres Forms (PFM), but the app won'tconnect to my DP instance, it gives me a message that it: " couldn't execute psql.exe; no such file or directory exists.'
Well of course it exists, I see the executable in the 9.1 directory.
so how could I get PFM to read the psql.exe file?
I suspect i could in some directory within the Postgres structure, but am hesitant to just blindly throw installs around in my production evironment.
Any suggestions would be greatly appreciated! even, is there another forms app I could use?
wavemaker doesnt work either- it wont import my 9.1 database
Thanks very much for any assistance you all could offer.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: FredP@abag.ca.gov, brooks.glenn@comcast.net
Subject: Re: help with Postgres forms (Pfm)
In-Reply-To: <4F190689020000A70001AF6F@gwia1.abag.ca.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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