Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You almost got it right. You need to escape each surrounding ". Instead of escaping a space, windows requires you to wrap the string in quotes. But vim interprets the quote as a comment. So you need to escape the double quote. You also need a backslash to escape the space.</p> <p>See an example in <code>:h 'shell'</code> (note the single quotes around shell is necessary to get help on the shell option. Otherwise you get help on the shell ex command.)</p> <pre><code>:set shell=\"C:\Program\ Files\Git\bin\sh.exe\" </code></pre> <p>You can check the value by typing:</p> <pre><code>:echo &amp;shell </code></pre> <p>As a side note though - I recommend not using bash/sh inside the win32 gvim. Many plugins test for <code>has("win32")</code> and construct shell commands for <code>cmd.exe</code> rather than the &amp;shell value. As a result, these plugins will fail if the shell is not <code>cmd.exe</code>. Ideally these plugins would test the <code>&amp;shell</code> value rather than using <code>has("win32")</code>. So even though I call win32 gvim from inside cygwin, I always set the shell back to <code>cmd.exe</code> or better <code>$COMSPEC</code> using this snippet in my vimrc.</p> <pre><code>if has("win32") || has("win64") || has("win16") "I do other stuff in here... "Then only inside this if block for windows, I test the shell value "On windows, if called from cygwin or msys, the shell needs to be changed to cmd.exe if &amp;shell=~#'bash$' set shell=$COMSPEC " sets shell to correct path for cmd.exe endif endif </code></pre> <p>Edit: As @LucHermitte mentions in the comment, plugins that don't work on win32 gvim when shell is set to bash or sh should be fixed. I agree... but in my experience this was not always feasible. So I always set the shell back to $COMSPEC (cmd.exe usually). If you don't have any issues with your plugins, then that's great and ignore my side note.)</p>
    singulars
    1. This table or related slice is empty.
    1. POSetting Cygwin shell path on Vim for Windows
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USdarcyparker
    1. USdarcyparker
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSetting Cygwin shell path on Vim for Windows
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI do use the win32 version of vim with cygwin, and bash as the &shell, and I have no problems so far. Faulty plugins can be fixed, and the authors shall be notified of the corrections they have to operate to have their plugins portable.
      singulars
      1. PO
      1. USLuc Hermitte
    2. CO@LucHermitte - You're right that faulty plugins should be fixed. I have reported issues in the past, but could not get the author to accept my pull request. If you have no issues with your plugins, then using cygwin bash as the shell inside win32 gvim is nice. I was just saying that my experience was that I had to reset the &shell.
      singulars
      1. PO
      1. USdarcyparker
    3. COThanks both for your input. @darcyparker I'm selecting your answer as the correct one, purely because it addresses the specific problem I had with escaping spaces, but it's an interesting point raised about the correctness of using `has()` for detecting the shell.
      singulars
      1. PO
      1. USJon Cairns
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload