3 votes0 comments · Feature Requests and Feedback » Developer portals & programs · Flag idea as inappropriate… · Admin →Rodger Beard shared this idea ·
429 votesUnder review · 24 comments · Feature Requests and Feedback » Office Developer Tools · Flag idea as inappropriate… · Admin →Rodger Beard supported this idea ·Rodger Beard commented
Most of all, I would like to see a migration path from MS Access using SQL Server to VB 6. Starting with some sort of integration of MS Access into Visual Studio.
But within the current VBA UI, how about style sheets to apply color coloring, auto indenting, etc. according to customizable rules? Redgate does this very well with their SSMS addin SQL Prompt.
How about applying above to those super ugly, almost impossible to read SQL statements that display when you click RecordSource or RowSource in a form's properties or the SQL view of saved queries?
When I want to debug anything complex,especially queries I've developed with the Design UI but need to debug in a SQL syntax window, the first thing I do is copy the source into NotePad++. Then clean it up so it's actually readable. Of course when I save my easy to read code back Microsoft usually does what it does, and the formatting gone.
Lately I've been saving my queries in text files until I know whatever I've working on actually works right in all conditions.
I've been a developer a long, LONG time and can't believe this is still necessary.