Settings slide up over the window when you press Ctrl+,. Every option applies the moment you change it, and Rowan remembers it; there's nothing to save.
How CSV is written when you export results, use Copy as CSV, and where the export wizard starts.
Delimiter
Tab, comma or semicolon.
Quote
If needed, Always ", Always ' or Never. NULL stays an empty field either way. With Never, a value holding the delimiter, a quote or a line break will break the file.
Line break
\n, \r\n or \r. Copy as CSV always uses \n.
Decimal
A period or a comma, for numbers. Excel in much of Europe wants a comma.
A saved query's file is written as you type, with no dot on its tab.
Results
For a run with more than one statement: Split into Tabs or Append in One Tab.
Return on error
Stops at the first statement that fails.
Key binding
Standard or Vim. See Vim mode. With Vim on, more options appear: Vim: use the system clipboard, Vim: Ctrl+D and Ctrl+U scroll, Vim: Ctrl+R redoes, and Vim settings file, whose Open rowan.vimrc button opens the file.
Indent width
2, 4, 6 or 8 spaces.
Indent with spaces
When off, Tab types a real tab.
Auto-close brackets
Quotes too. Typing the closing one steps past it.
Highlight current line
A faint band behind the line with the cursor.
Show invisible characters
Spaces, tabs and line ends, drawn faintly.
Suggest while typing
Opens suggestions as you type. Ctrl+Space shows them anytime.
Suggestion keyword case
UPPER, lower or As Typed.
Accept suggestions with
Enter or Tab, Enter, or Tab. A list that opens by itself always takes Tab.
Format SQL and Query Parameters, at the bottom of the Editor page.
Tints for staged edits, with a hex field and Reset for each.
Modified rows, New rows and Deleted rows set the tints for staged edits. Pick a swatch or type a hex color; Reset puts one back. Restore Defaults puts every font, size, padding and tint back, and leaves the theme and accent as they are.
Where the welcome window's connections come from. Local is this computer. Add Source… adds a folder, for example one in Dropbox or OneDrive that your team shares; its connections appear in the welcome list under a group with the source's name.
Rename a source in place, change its Folder…, or Remove it. Removing takes it off the list; its folder and files stay where they are.
A connection is kept in the file of the group it's in, so dragging a connection into or out of a source's group moves it between files.
The folder that holds your saved queries (its Queries folder), your history and your open tabs. Choose Choose…, or type a path and press Enter, to move them, for example to a synced folder. If the new folder has none of its own, what's there now moves along. Restore Default goes back to Rowan's own folder.
