AppGini Community Forums

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

hi! you can use phpMyadmin to test result

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

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

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 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

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...

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

Hi,

thank you.
Olaf