Breaking Access News - Monaco Editor
ฝัง
- เผยแพร่เมื่อ 1 มิ.ย. 2024
- The Microsoft Access engineering team shows the current development status of the new SQL editor for Access.
Access News Playlist: • Access News
Roadmap for Access www.microsoft.com/en-us/micro...
Access DevCon Vienna www.donkarl.com/devcon - วิทยาศาสตร์และเทคโนโลยี
Great work Karl. It's especially good to see direct communications with the Access Dev team after years of talking to a Closed Door!
For the dev team: if we can have it in Dark mode as well that would be amazing!
I forwarded it to the Access team. Reply: Yes, dark mode is supported. We'll support all themes like white, dark, grey, and colorful. You can control font style and size in the query designer options under the object designer.
I've been waiting for this for a long time and have even toyed with building my own using the Scintilla editor. Here are the features I would like you to include in the Monaco editor:
- Does the Monaco editor work along with the Query Designer? Can I jump back and forth between views? I expect that comments I make in the SQL view will not be lost when I make changes in the Query Deisign view.
- Parenthesis matching. When I select a parenthesis it should highlight the matching parenthesis. Provide a hotkey so I can jump to the matching parenthesis. (CTRL+B in Notepad++)
- Do comments have to be on their own line or can I add a comment to the end of a line?
- Support for /* block comments */ would be nice.
- SQL Formatting. Can you provide a hotkey or automatic SQL formatting? At a minimum can it put a carriage return before these statements: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, INSERT, VALUES, SET, UNION. Another nice to have formatting is putting each SELECT column on its own row. Some SQL formatters have configurable options so you can specify if the comma is before or after each column name. I have written my own SQL formatter in AutoHotkey if you want some cues: www.autohotkey.com/boards/viewtopic.php?t=107188
- The editor should support vertical selection of text. This comes in handy if you need to alias a bunch of coluimns
- Dark mode
Wish list
- Will I be able to embed the Monaco editor onto an Access form? I've got a form where users can edit SQL queries. It would be great if I could use this instead of large text control.
- It would be cool if it could convert Access SQL queries to T-SQL for pass-through queries. I created the rules behind a website that does this and I'd be willing to share code with the Microsoft Dev's. accessusergroups.org/sql-converter/
It was stated in the video that the Microsoft Team wanted feedback. Can we see some replies here to acknowledge you are listening? ⁉
I forwarded your questions to the Access team. Reply: It's too early to discuss comments and formatting retention in Monaco Editor. Yes, matching parenthesis is highlighted, you can jump between parentheses using Shift + Ctrl + . Yes, you can perform vertical selection using Shift + Alt + mouse movement. Yes, dark mode is supported.
Awesome - looking forward better SQL development! Request to the Microsoft Access team - Currently the SQL editor right-click popup menu has the standard Cut/Copy/Paste options. Please add: Execute (F5), Parse (Ctrl+F5) and Property Sheet (Alt+Enter). SSMS uses the name Property Window (F4) whereas Access uses Property Sheet - prefer the SSMS option. Thanks!
I forwarded it to the Access team. Reply: We're not sure about the right-click options yet, but we will discuss it.
Nice feature, and definitely needed. A great additional feature would be to have the editor be SQL Server aware for Passthru queries that connect to SQL Server. In orherwords bring as much as you can from SSMS Sql editor into the MS Access/Passthru query editor, so the autocomplete would be aware of SQL Server functions and keywords, and even tables of the initial catalog in the connection string.
yeah, we had 'Access Data Projects' for full SQL Server support for 15 years. I'm not gonna be happy with Access until they bring back ADP completely.
I forwarded it to the Access team. Reply: We plan to support this scenario. We will update you when those features are closer to completion.
@@aaronkempf506 And combine it with Access Web Apps 2013/2016
I'd mention that the Intellisense prompt referenced all tables, not just those in the FROM clause. It'd be very important for the prompt to be able to check that clause, so it could consider aliasing. i.e. typing an aliased table would also provide an Intellisense prompt for that table's columns.
I forwarded it to the Access team. Reply: It's too early to discuss/answer that. We will update you when those features are closer to completion.
Support for syntax indenting (i.e. the way the SQLTools works in VS Code)
Being able to reference aliased columns in calculations or in WHERE conditions would be cool too if possible. The only way to currently do this is through a subquery.
awesome, long overdue feature!!!
Wow! Been waiting for this for years!! :)
Good news! Thanks for sharing. 🤗
I'm glad if you find it informative. Organizing, making videos and moderating feedback is a lot of work. So it should be good for something.🧘♂
very good… Thanks microsoft and thanks Karl
You're welcome, Edwin. This new feature for Access will affect the daily development work of all of us this time. So I wanted to inform the wider community what the current situation is and provide an opportunity for feedback.
News flash for all Access devs: the year is 2024, mobile is king everywhere. Also we're still waiting for a proper SQL editor. In 2024.
Thanks for the vid, looking fwd to the Monaco sql improvements? Any news of them fixing all the bugs in the new Edge Bowser control our is it getting left to Daniel Pineault to come up with workarounds?
Super, wurde auch Zeit.
Sachin demonstrates adding two hyphen symbols to add a comment, which is presumably a single-line comment as it is in SSMS. Will the Monaco Editor support multi-line comments, using /* Multi-line comment entered here */ ?
Also, will the Monaco Editor please allow us to get rid of the visual clutter with the tablename.fieldname that Access is famous for adding? It is really only necessary if a query references > 1 table where two or more tables contain identical field (column) names and the query references that fieldname. The vast majority of queries do not require this additional disambiguation.
I forwarded it to the Access team. Reply: It's too early to discuss comments and formatting retention in Monaco Editor.
Great news. Will it work on linked tables- say to sql server?
No matter what, a great new feature, and the sql editor needed some love and care for a long time.
Yes, it will work with linked tables, as discussed in the comments at nolongerset.com/devcon-2024-monaco-sql-editor.
@@karldonaubauer6898
Thanks - I much thought it would, since the query builder always did work fine with linked tables. Including any odbc source.
Thank you for all your efforts on this New Feature, we truly appreciate your efforts on this. What I would strongly require is a feature where the editor could show me the End if for its If construction statement. This will visually make it easier for the programmer to get to the endif of a particular If statement if the connections are visually shown in the editor. I have seen this feature in some other editor's many years ago and I wish if Access would have the same. Also please work on the Responsive Forms feature and have it released at your earliest possible convenience. Its because nowadays we are working on modern hardware and we run into alot of resolution issues if its not a desktop that a user is working on. We usually have faced resolution issues running Access (Any version) on a Microsoft Surface Laptop/Tablet. Please help us also make the forms look like web forms. This would be of great help to us as developers and to our users of our implemented projects.
Note that this is a SQL editor not a VBA editor. Endif is not supported in Access SQL. The VBA IDE is not owned by the Access team so they can't do much about it. :(
Very cool
Dammit, Karl... now I've had your theme song playing in my head for the past half hour! EVERY time I watch one of your videos.... LOL
That's exactly how it should be, Richard! 😁
Finally: the did it! 😂😂😎😎