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
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
Go to Query Tab, hit "New" and enter the following query :
select * from invoices where year=[parameter "Enter the year for invoice
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
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 :
All the best,
FLEX Consulting Braila, ROMANIA
pgsql-interfaces by date
|Next:||From: Matthew Liste||Date: 1998-09-19 01:55:04|
|Subject: postgres process grows.|
|Previous:||From: Byron Nikolaidis||Date: 1998-09-18 13:23:26|
|Subject: Re: [HACKERS] Re: [INTERFACES] Odbc parser error|
pgsql-general by date
|Next:||From: Postgres||Date: 1998-09-18 16:48:09|
|Subject: improving performance with more -B buffers?|
|Previous:||From: Thomas Good||Date: 1998-09-18 16:27:00|
|Subject: Re: [GENERAL] slow queries|