<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta name="GENERATOR" content="Mozilla/4.61 [en] (X11; I; Linux 2.2.11 i586) [Netscape]"> </head> <body bgcolor="#FEFEDF"> <b>Tables</b> <br>- opening multiple tables for viewing, max. n records (changed by preferences menu) <br>- column resizing, dragging the vertical grid line (better in table space rather than in the table header) <br>- text wrap in cells - layout saved for every table <br>- import/export to external files (SDF,CSV) <br>- filter capabilities (enter filter like (price>3.14) <br>- sort order capabilities (enter manually the sort field(s)) <br>- editing in place <br>- improved table generator assistant <br>- improved field editing <br><b>Queries</b> <br>- define , edit and stores "user defined queries" <br>- store queries as views <br>- execution of queries with optional user input parameters ( select * from invoices where year=[parameter "Year of selection"] ) <br>- viewing of select type queries result <br>- query deleting and renaming <br>- visual query builder with drag & drop capabilities. For any of you who had installed the Tcl/Tk plugin for Netscape Navigator, you can see it at work <a href="qbtclet.html">clicking here</a> <br><b>Sequences</b> <br>- defines sequences, delete them and inspect them <br><b>Functions</b> <br>- define, inspect and delete functions in SQL, plpgsql and pgtcl languages <br><b>Reports</b> <br>- design and display simple reports from tables <br>- fields and labels, font changing, style and size <br>- saves and loads report description from database <br>- show report previews, sample postscript output file <br><b>Forms</b> <br>- open user defined forms <br>- form design module available <br>- query widget available, controls bound to query results <br>- <a href="forms.html">click here</a> for a description of forms and how they can be used <br><b>Scripts</b> <br>- define, modify and call user defined scripts <br><b>Users</b> <br>- define and modify user information <p><b><a href="api.html">PgAccess API</a></b> for developing small applications <br> </body> </html>
