Activity overview
Latest activity by geophphrie
Format SQL issues with views
I am finding that SQL Prompt 4 does not correctly do Format SQL on create/alter view statements. It may be that this primarily happens if there is a comment in the view text. I frequently place com...
Cannot turn off automatic trigger / objects
Unless I'm really confused, I cannot successfully set SQL Prompt 4 to use manual (Ctrl-Space) triggering as I used on SQL Prompt 3. I uncheck the "Automatically trigger suggestions" and "Display ob...
Even assuming that syntax error highlighting will work perfectly, it is the sort of thing I wouldn't want on all the time. I code quickly and accurately most of the time, and would find the underlines visually distracting whilst I am crafting a new query for the first 95% of the time it takes to figure out how the view/proc/fn is going to work, during which time of course there will be some "errors" since the code is incomplete. I would likely turn it on for the 5% effort of fixing any latent brokenness in what I wrote. Might be nice to have a hotkey to kick on the "spellcheck"...
Note that turning off auto spell and grammar checking is pretty much the first thing I do after installing OpenOffice... / comments
Even assuming that syntax error highlighting will work perfectly, it is the sort of thing I wouldn't want on all the time. I code quickly and accurately most of the time, and would find the underli...