Print Thread
Add a Toolbar Button that performs a SQL query
#37792 04/13/10 09:59 AM
Joined: Apr 2010
Posts: 3
V
Member
OP Offline
Member
V
Joined: Apr 2010
Posts: 3
Hi!
I have a sql query that displays locks (for example). I would like to add to toolbar button that would execute the query and displays the result in a new window. How can this be done using the "Tools" -> "Configure tools"?
Sorry for my English...

Re: Add a Toolbar Button that performs a SQL query
Viacheslav #37802 04/13/10 10:12 PM
Joined: Aug 2005
Posts: 65
San Diego, CA
J
Member
Offline
Member
J
Joined: Aug 2005
Posts: 65
San Diego, CA
I don't know about a tool button, but I use menu item TOOLS/SESSIONS for a few of those type of queries.

Re: Add a Toolbar Button that performs a SQL query
jrow #37803 04/14/10 04:09 AM
Joined: Apr 2010
Posts: 3
V
Member
OP Offline
Member
V
Joined: Apr 2010
Posts: 3
Well. smile
Let it be a sql query to my tables. Like this:
select *
from table1 t1
inner join table2 t2
on t1.fid = t2.id

Re: Add a Toolbar Button that performs a SQL query
Viacheslav #37814 04/14/10 09:33 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
You cannot add a toolbar button for this, but if you create a report it can be added to the menu, and you can assign a function key.

Invoking the report from the menu or with a function key will open a new Report Window and will execute it.


Marco Kalter
Allround Automations
Re: Add a Toolbar Button that performs a SQL query
Marco Kalter #37822 04/15/10 11:09 AM
Joined: Apr 2010
Posts: 3
V
Member
OP Offline
Member
V
Joined: Apr 2010
Posts: 3
Thank you!


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.051s Queries: 14 (0.025s) Memory: 2.5129 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 13:13:41 UTC
Valid HTML 5 and Valid CSS