Skip site navigation (1) Skip section navigation (2)

PgAccess 0.90 new version released - user input query parameters available

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: PgAccess 0.90 new version released - user input query parameters available
Date: 1998-09-18 16:46:36
Message-ID: 36028E6C.4DA0964E@flex.ro (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Hello everybody,

I just discovered today a quick hack in order to allow user input
variable parameters in queries.
This new version 0.90 implements this feature. As much as I have tested
it, it works fine and gives you more flexibility in handling variable
queries.

To use this feature, you must replace the value that you are searching
in a query with the function :

[parameter "Here goes the message"]

When opening this kind of query, PgAccess will popup a new window,
allowing you to enter the value that would be replaced in the query
definition.

Examples :
Go to Query Tab, hit "New" and enter the following query :

select * from invoices where year=[parameter "Enter the year for invoice
selection"]

Presuming you have a "invoices" table with a "year" field :-) this one
should work fine.
Another one :

select * from phones where company ~* '[parameter "Please enter the
company name"]'


BUGS
====
Query opening would probably fail if you are using a query where it can
be found by mistake a construction of [ .... ] form.
This will cheat Tcl who will try to execute the script between [ and ].
Try this :

select * from invoices where year=[bell] 

You will hear a beep, and of course, nothing will be selected.

The new version, as always at :
http://www.flex.ro/pgaccess
ftp://ftp.flex.ro/pub/pgaccess


All the best,
-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

pgsql-interfaces by date

Next:From: Matthew ListeDate: 1998-09-19 01:55:04
Subject: postgres process grows.
Previous:From: Byron NikolaidisDate: 1998-09-18 13:23:26
Subject: Re: [HACKERS] Re: [INTERFACES] Odbc parser error

pgsql-general by date

Next:From: PostgresDate: 1998-09-18 16:48:09
Subject: improving performance with more -B buffers?
Previous:From: Thomas GoodDate: 1998-09-18 16:27:00
Subject: Re: [GENERAL] slow queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group