Thanks for all your responses. MS Access was tried before my time and didn't work out so well (not sure why.) OpenOffice sounds like a great idea (I use it quite often for typical office tasks) but we do use some views. WaveMaker looks very interesting. Thanks for the reference.<br>
<br>- John<br><br><br><br><div class="gmail_quote">On Thu, Aug 5, 2010 at 12:59 PM, Randall, Eric <span dir="ltr"><<a href="mailto:ERandall@eriecountygov.org">ERandall@eriecountygov.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
<div><font color="#0000ff" face="Arial" size="2"><span>John,</span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div><font color="#0000ff" face="Arial" size="2"><span>For
the web solution I use WaveMaker with but haven't done anything too fancy
with it yet. <a href="http://www.wavemaker.com/" target="_blank">http://www.wavemaker.com/</a></span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span>SQL
Workbench might be another option. <a href="http://www.sql-workbench.net/" target="_blank">http://www.sql-workbench.net/</a> </span></font></div>
<div><font color="#0000ff" face="Arial" size="2"><span></span></font> </div>
<div><font color="#0000ff" face="Arial" size="2"><span>Eric</span></font></div>
<div><font color="#0000ff" face="Arial" size="2"></font> </div>
<p><font size="2">Eric Randall<br>GIS DB Admin/Analyst<br>County of Erie<br>140 W
6th St<br>Room 111<br>Erie, PA 16501<br><br>ph. 814-451-6063<br>fx.
814-451-7000<br></font></p><div><div></div><div class="h5">
<blockquote>
<div dir="ltr" align="left"><font face="Tahoma" size="2">-----Original Message-----<br><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>]<b>On Behalf Of </b>John
Callahan<br><b>Sent:</b> Thursday, August 05, 2010 9:54 AM<br><b>To:</b>
PostGIS Users Discussion<br><b>Subject:</b> [postgis-users] postgres data
tables package (ORACLE Formsreplacement?)<br><br></font></div>Brief
background: We're currently using Oracle for our main database. Nothing
too big, 15 - 20 tables and the largest table has about 100K
records. We use Oracle Forms as a web-based option for inserting
and updating records.<br><br>I am using Postgres/PostGIS for a couple of other
projects. I would like to use Postgres for our main database as
well. However, I would need to come up with a solution for
inserting/updating the data tables within our group (a replacement for Oracle
Forms). Preferably, a web-based solution (PHP, Python, etc...) but it
could be a Windows desktop solution installed on each staff members
machine. Something that maintains the data integrity (e.g., forcing
users to enter a date when Date is required, etc...)<br><br>Does anyone know
of a FOSS package that can be used to manage data tables within a Postgres
database? Updating data records is the highest priority since the
built-in Admin tool can be used for managing users, creating new tables,
etc..., and will be done only by a database manager. Thanks for any
advice or guidance you can provide.<br><br><br>-
John<br><br></blockquote></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>