0.0.6 is a good start.
The popup help for fields after the table has been selected needs extending to also work when a table alias is used. eg.
select * from table1 t where t.
at this point I would expect to get the field popup for table1.
Dave.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I agree, and it would seem many others do too! There have been many comments on the popup help - (we call it the SqlHelper), which we want to make truly usable.
<p>
It is difficult to work out how to do though. Firstly, SqlBuddy has to *understand* sql in order to be able to show popups with the most useful information at the right time. Examples below...
<br>
<ul>
<li>it should know that an alias maps to a given table
<li>if in a nested statement it should show outer and innter tables
<li>if in a script ( multiple statements) it should only show info related to the current statement
<li>when doing group by clauses it should show columns in the statement.
</ul>
<p>I'm wondering whether I should write an sql interpreter that understands the syntax of the language. Does anyone know if where we can get the BNF for SQL?
Any thoughts/suggestions welcome.
Tobin Harris
SqlBuddy Founder/Developer
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
0.0.6 is a good start.
The popup help for fields after the table has been selected needs extending to also work when a table alias is used. eg.
select * from table1 t where t.
at this point I would expect to get the field popup for table1.
Dave.
I agree, and it would seem many others do too! There have been many comments on the popup help - (we call it the SqlHelper), which we want to make truly usable.
<p>
It is difficult to work out how to do though. Firstly, SqlBuddy has to *understand* sql in order to be able to show popups with the most useful information at the right time. Examples below...
<br>
<ul>
<li>it should know that an alias maps to a given table
<li>if in a nested statement it should show outer and innter tables
<li>if in a script ( multiple statements) it should only show info related to the current statement
<li>when doing group by clauses it should show columns in the statement.
</ul>
<p>I'm wondering whether I should write an sql interpreter that understands the syntax of the language. Does anyone know if where we can get the BNF for SQL?
Any thoughts/suggestions welcome.
Tobin Harris
SqlBuddy Founder/Developer