Editor
Previous  Top  Next

The SQL Editor is quite comprehensive and appears in all Query and Script type folder windows. Settings and Options for the Editor can be found on the same folder's Properties window, i.e. right click the folder, ex. a query, then click Properties.

led-triangle-green To open and give focus or close the Editor (if available), press Ctrl+I

The Editor has the following features:
·Line numbering editorsyntax  
·Syntax highlighting - make it easy for you to read your SQL.  
·Book marking (Ctrl+Shift+# to set, Ctrl+# to goto) - So you can easily find your way back in huge scripts.  
·Scroll bar hints - so you know where you are scrolling to  
·Different selection modes - Normal (Ctrl+Shift+N), Lines (Ctrl+Shift+L) and Columns (Ctrl+Shift+C)  
·MySQL function AutoParameter hints (Ctrl+Shift+Space)  
· editorautoparam  
·MySQL AutoProposals (Ctrl+Space)  
·editorproposals  
·MySQL AutoCompletion (Ctrl+J)  
·editorautocomplete  
·AutoColumn- and Table name proposals (Ctrl+Space)  
·editorautofieldproposal You won't have to go in search of that column or tablename ever again.  
·AutoCorrection, ex. "selet" becomes "select"  



editormenuIf the Editor is available in a window, you will automatically have an Editor Menu as well as a Execute button on your main toolbar. You can use this menu to Execute your SQL (led-triangle-green Ctrl+E also still works to execute your SQL for backward compatibility with Mascon), Save your SQL to the default file for this folder, which is usually in the format of "Host"."Database"."Type"."Name".sql (see Storage for more information), so in our example's case the name would be "localhost.newdatabase.query.newquery1.sql" located in the MyCon directory. You can also Load Defaults for this folder, meaning delete any custom settings and sql and load the query/script/table editor and grid settings as if this is the first time you opened this folder. Save this SQL as a new query or a new script to appear in your folders. Open an external sql script to load into the Editor, or Save as the Editor's SQL to a custom external script file.

Of course you can use the normal Grid window functions as well to use your Editor SQL and generate a Backup script from it (optionally scheduling it) or to just Schedule running your Script. See Grid for more on these features.

editorautopropsYou can customize your Editor's Auto features, ex. AutoComplete, AutoParams, AutoCorrect, etc, in the folder's Properties window. led-triangle-amber these settings are stored in common configuration files stored in the MyLook installation directory, so even though you can change it on any folder with an Editor/Grid/Logger for displaying data and scripts, your changes will reflect for every Editor. In short, changes made here are not specific to any folder, but common to every place you can see and use the Editor.