Re: [SLUG] Question: Linux for Business

From: Ronan Heffernan (ronan.heffernan@mindspring.com)
Date: Tue Jan 15 2002 - 21:20:43 EST


>
>
>Access is harder, for it is a VB environemnt, and a reporting
>tool, and does form layout --
>
If you are using Postgres as a backend, there is a tool called
"pgaccess". It pops-up a window with several tabs (ala MSAccess):
Tables, Queries, Views, Sequences, Functions, Reports, Forms, Scripts,
Users, Schema. It does have a built-in form editor (I haven't really
tried to use it), and a Query-By-Grid SQL generator (haven't used it
either). Double-clicking on a table opens an Access-ish grid that you
can edit in-place just by clicking and typing. Interestingly, pgaccess
creates ~6 tables in your Postgres database (all called pga_something),
where it stores your forms, reports, queries, etc. This way, you don't
have to drag these definitions around from machine to machine as files.
 Yes, the purist is vomiting at having these GUI-tool tables polluting
their bright, shining schema, but if you use the GUI tool, this is a
neat solution.
--ronan



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:58:25 EDT