How can we help you today? How can we help you today?

does not handle ".." notation

we have a set of databases that are inter-related and as such many queries and stored procedures access more than one of the databases

because everything is owned by dbo, we tend to use the .. notation such as

select * from DatabaseName..Table t where t.ID = 12345

The old version of promptSQL used to work fine with the ".." and it would popup the list of tables/objects for the database

With the new version not only does it not pop up anything, this also breaks everything and no words will autocapitalise and popups will not show up again etc

the only way i can fix it is to close query analyser and re-open it :(
rgribble
0

Comments

1 comment

Sort by
  • Bart Read
    Hi there,


    Thanks for reporting this. We did patch quite a few bugs from PromptSQL 1.4 in SQL Prompt 2, but it looks like here one of our patches has broken something. Unfortunately the parsing model in the current version of SQL Prompt is fairly simplistic, however in the new version we'll be providing a much more robust model that will handle things like this. All being well this should be available sometime in September.


    Many thanks,
    Bart Read
    0

Add comment

Please sign in to leave a comment.