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
Preview SQL query result?
Preview SQL query result?
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
- landinialejandro
- AppGini Super Hero
- Posts: 126
- Joined: 2016-03-06 00:59
- Location: Argentina
- Contact:
Re: Preview SQL query result?
hi! you can use phpMyadmin to test result
Alejandro.
AppGini 5.98 - Linux OpenSuse Tumblewweed.
Some of my posts that may interest you:
Landini Admin Template: Template for Appgini like AdminLTE
Profile image plugin: add and changue image user profile
Field editor in table view: Configurable fast edit fields in TV
my personal page
AppGini 5.98 - Linux OpenSuse Tumblewweed.
Some of my posts that may interest you:
Landini Admin Template: Template for Appgini like AdminLTE
Profile image plugin: add and changue image user profile
Field editor in table view: Configurable fast edit fields in TV
my personal page
Re: Preview SQL query 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
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
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
- landinialejandro
- AppGini Super Hero
- Posts: 126
- Joined: 2016-03-06 00:59
- Location: Argentina
- Contact:
Re: Preview SQL query result?
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
inside appgini i don'tknow
Alejandro.
AppGini 5.98 - Linux OpenSuse Tumblewweed.
Some of my posts that may interest you:
Landini Admin Template: Template for Appgini like AdminLTE
Profile image plugin: add and changue image user profile
Field editor in table view: Configurable fast edit fields in TV
my personal page
AppGini 5.98 - Linux OpenSuse Tumblewweed.
Some of my posts that may interest you:
Landini Admin Template: Template for Appgini like AdminLTE
Profile image plugin: add and changue image user profile
Field editor in table view: Configurable fast edit fields in TV
my personal page
Re: Preview SQL query result?
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
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
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: Preview SQL query result?
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
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
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
- landinialejandro
- AppGini Super Hero
- Posts: 126
- Joined: 2016-03-06 00:59
- Location: Argentina
- Contact:
Re: Preview SQL query result?
Hi yes of courseonoehring wrote: ↑2019-05-22 16:35Hi 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
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
Alejandro.
AppGini 5.98 - Linux OpenSuse Tumblewweed.
Some of my posts that may interest you:
Landini Admin Template: Template for Appgini like AdminLTE
Profile image plugin: add and changue image user profile
Field editor in table view: Configurable fast edit fields in TV
my personal page
AppGini 5.98 - Linux OpenSuse Tumblewweed.
Some of my posts that may interest you:
Landini Admin Template: Template for Appgini like AdminLTE
Profile image plugin: add and changue image user profile
Field editor in table view: Configurable fast edit fields in TV
my personal page
Re: Preview SQL query result?
Hi,
thank you.
Olaf
thank you.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view