Preview SQL query result?

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Preview SQL query result?

Post by onoehring » 2019-05-22 12:36

Hi,

when I define a SQL query for the "advanced lookup option" - is there a way to test that query?
I would like to see a button that executes that query (maybe asking to variables first), that I can be sure it's correct, without creating the php code first.

Olaf

User avatar
landinialejandro
AppGini Super Hero
AppGini Super Hero
Posts: 126
Joined: 2016-03-06 00:59
Location: Argentina
Contact:

Re: Preview SQL query result?

Post by landinialejandro » 2019-05-22 16:15

hi! you can use phpMyadmin to test result
Alejandro.
AppGini 5.98 - Linux OpenSuse Tumblewweed.

Some of my posts that may interest you:
:arrow: Landini Admin Template: Template for Appgini like AdminLTE
:arrow: Profile image plugin: add and changue image user profile
:arrow: Field editor in table view: Configurable fast edit fields in TV
:idea: my personal page

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Preview SQL query result?

Post by onoehring » 2019-05-22 16:18

Hi landinialejandro,
well, yes, but that's quite complicated for testing a simple select ...
I thought there would/must be an easier way directly from AppGini.

PS: Instead of phpmyadmin I suggest checking out this tool: https://www.adminer.org

Olaf

User avatar
landinialejandro
AppGini Super Hero
AppGini Super Hero
Posts: 126
Joined: 2016-03-06 00:59
Location: Argentina
Contact:

Re: Preview SQL query result?

Post by landinialejandro » 2019-05-22 16:23

if you use vcode or netbeans as code aeditor you can test the query whith the plugin without exit from the editor.
inside appgini i don'tknow
Alejandro.
AppGini 5.98 - Linux OpenSuse Tumblewweed.

Some of my posts that may interest you:
:arrow: Landini Admin Template: Template for Appgini like AdminLTE
:arrow: Profile image plugin: add and changue image user profile
:arrow: Field editor in table view: Configurable fast edit fields in TV
:idea: my personal page

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Preview SQL query result?

Post by onoehring » 2019-05-22 16:35

Hi landinialejandro,

could you please provide links to vcode and aeditor so I can check them out.
Of course MySQLWorkbench ( https://www.mysql.com/products/workbench/ ) is worth a look :-)

Olaf

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Preview SQL query result?

Post by onoehring » 2019-05-24 12:29

Hi again,
I found the free SQLLeo as visual query designer as well ( http://sqleo.sourceforge.net) and the (basically) free Flyspeed Query designer ( https://www.activedbsoft.com/overview-querytool.html )

Olaf

User avatar
landinialejandro
AppGini Super Hero
AppGini Super Hero
Posts: 126
Joined: 2016-03-06 00:59
Location: Argentina
Contact:

Re: Preview SQL query result?

Post by landinialejandro » 2019-05-27 22:05

onoehring wrote:
2019-05-22 16:35
Hi landinialejandro,

could you please provide links to vcode and aeditor so I can check them out.
Of course MySQLWorkbench ( https://www.mysql.com/products/workbench/ ) is worth a look :-)

Olaf
Hi yes of course
vcode : https://code.visualstudio.com/
net beans : https://netbeans.apache.org/download/index.html

and aeditor it's my mistake... :D

then in visual code intal the nexts extensions
https://marketplace.visualstudio.com/it ... code-mysql
and
https://marketplace.visualstudio.com/it ... sql-syntax

in netebeans i dont remeber wich extension are needed
Alejandro.
AppGini 5.98 - Linux OpenSuse Tumblewweed.

Some of my posts that may interest you:
:arrow: Landini Admin Template: Template for Appgini like AdminLTE
:arrow: Profile image plugin: add and changue image user profile
:arrow: Field editor in table view: Configurable fast edit fields in TV
:idea: my personal page


Post Reply