Обсуждение: PgAccess 0.90 new version released - user input query parameters available
PgAccess 0.90 new version released - user input query parameters available
От
Constantin Teodorescu
Дата:
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