Comments
Sort by recent activity
Well stopped ! I have added this bug to our bug tracking database and it will be fixed by the final version.
Lionel / comments
Well stopped ! I have added this bug to our bug tracking database and it will be fixed by the final version.
Lionel
That is definatly a bug. I have added it into our bug tracking system. I agree that some intelisense withing string would be useful when writing dynamic sql but it is unlikly that that feature will be in this version I am afraid as it is a very tricky problem to solve.
Lionel / comments
That is definatly a bug. I have added it into our bug tracking system. I agree that some intelisense withing string would be useful when writing dynamic sql but it is unlikly that that feature will...
This is not supported in the beta version but should be a feature that will be in the final version. One of the resons for the rewrite of Prompt SQL was so we could support things like this that was very had to do in the previous version. / comments
This is not supported in the beta version but should be a feature that will be in the final version. One of the resons for the rewrite of Prompt SQL was so we could support things like this that wa...
We are working hard on adding support for constructs like derived tables. In this new version of SQL Prompt we are using a new parser which should allow us to support these statments. I can't promise anything but I personally would like to see better support for these statments as I use them all of the time. They are the best thing sinced sliced bread.
Lionel / comments
We are working hard on adding support for constructs like derived tables. In this new version of SQL Prompt we are using a new parser which should allow us to support these statments. I can't promi...
Thanks for the feedback. This looks like it is being caused by our passer having problems with incomplete SQL. I have entered it into our bug tracking system for fixing.
Lionel / comments
Thanks for the feedback. This looks like it is being caused by our passer having problems with incomplete SQL. I have entered it into our bug tracking system for fixing.
Lionel
Unfortinatly I fixed the bug where it was only working with the first query window just before the beta and we didn't quite have time to add it. SQL Prompt does not support the use <DB> syntax in the beta but will definatly in the final version. Selecting a database using the drop down list should definatly always change to the correct database though.
Lionel / comments
Unfortinatly I fixed the bug where it was only working with the first query window just before the beta and we didn't quite have time to add it. SQL Prompt does not support the use <DB> syntax in t...
Thanks for the feeback. The generating of duplicate aliases is a bug and will be fixed by the finaly version. The reason it is not selecting a sensible alias for the ordersdetails table is that the table name is all uppercase. SQL Prompt takes the uppercase letters and uses the first one in each sequence to make the alias. So for example if you used OrderDetail as your table name you would get the alias od as expected. I realise you can't rename your tables just for SQL Prompt so I have added a sugestion to our list of features to let you specify the aliases for particular tables.
Lionel / comments
Thanks for the feeback. The generating of duplicate aliases is a bug and will be fixed by the finaly version. The reason it is not selecting a sensible alias for the ordersdetails table is that the...
This is actually how it is suposed to work. The reason it doesn't go straight to the tables list is because there is both a views and a tables list and both are sensible choices in this situation. I guess the All common objects is maybe a confusing name. The idea behine this list is it should list the relevent objects for where you are in the query. In this situation it should give you a list of views and tables. If it isn't then this is a bug. Does this sound sensible (We did consider opening on the tables list like you sugested but change our minds due to the reasons above) ? Also would this have made sense if that list had got a better name ? / comments
This is actually how it is suposed to work. The reason it doesn't go straight to the tables list is because there is both a views and a tables list and both are sensible choices in this situation. ...
This is what we are aiming for. It is sounds like we should find a better name for the all candidates list than the curent one though.
Lionel / comments
This is what we are aiming for. It is sounds like we should find a better name for the all candidates list than the curent one though.
Lionel
Thanks for the feedback. I have entered it into our bug tracking system. This will definatly get fixed in the final version as is most anoying.
Lionel / comments
Thanks for the feedback. I have entered it into our bug tracking system. This will definatly get fixed in the final version as is most anoying.
Lionel