Couldn't get SQL query to run

Hi..! Pete
you are right. it seems like it was minor bug. but don’t worry it solved now.
Please download the latest version of plugin[1.0.1],
and Thank you for your response, If any query do not hesitate

Hi Dhavel,

Thanks for the quick response, I can now both enter and build a select statement and that works great!

On a separate note, When I click the submit button, it clears the query box. Is there a way to re-populate when the screen return so that I can either reread my query (especially if it comes back with “500+ rows updates” and I thought it was only going to update one row, lol), or if I want to execute a query and then change it slightly for a different id instead of having to retype the whole thing?

Thanks again.

-Pete

Hi..! Pete
when you submit query like insert,update,delete[except from SELECT statement ]. it will display the how many rows are affected in top [of query box] even error also.
I have noted your request. I will include your requirement in next release of plugin version. it will be very soon.
Thanks..
-Dhaval Parekh

Hi..! Pete
Query box will now shows Last Executed query.
please check it new version[1.0.2].
Thanks..
-Dhaval Parekh

Hi Dhaval,

Thanks again for the help and making the changes so quickly, the functionality works great. One tiny observation is that if I enter a query like this:

UPDATE <tablename> SET value=’off’ WHERE id = 166;

It executes correctly but it redisplays as:

UPDATE <tablename> SET value=\’off\’ WHERE id = 166;

This is fine, as I can then change the query to this:

UPDATE <tablename> SET value=\’on\’ WHERE id = 166;

It again executes correctly but it redisplays as:

UPDATE <tablename> SET value=\\’on\\’ WHERE id = 166;

This is such a minor point as the functionality works great, and I appreciate your hard work to make such a great plugin, but I thought I would point it out.

Thanks again!

-Pete

Hi..! Pete
sorry for inconvenience.
i will resolve this problem in next version of plugin.
Thanks..

-Dhaval Parekh

Hi..! Pete
I have solved the problem in new version of plugin[1.0.3].
Please check it.
And sorry for delay.

Thanks..

-Dhaval Parekh

Hi Dhaval,

Thank you for the update, it works very well and the interface is a very interesting drag/drop way of creating the queries, I like it a lot.

One suggestion for some new functionality would be that when you click “Display Data” and get the popup window of all the records in a table, that you could then click on one row and it would pre-enter an update query in the “Custome Query” box so you could easily make an update to a particular row in that table. Typically, I want to look at the data, then update one row, or a series of rows, so having it automatically start an update query for me would be very useful.

BTW, should “Custome Query” be “Custom Query” or “Customer Query”?

Thank you for your help.

-Pete

Hi..! Pete
Thank you for your Suggestion. i will add this functionality in new Major version of plugin.

and, Yes that some spelling mistake its “Custom Query”.

-Dhaval Parekh