title: Creating sqlite3 files/database
body: <p>I am struggling to create a database using SQLite3 using Windows 7.</p>
  
  <p>SLite3 is currently installed:</p>
  
  <pre><code>C:\Program Files (x86)\Development\
  </code></pre>
  
  <p>and has sqlite3.def, sqlite3.dll and a sqlite3 (.exe) file.</p>
  
  <p>I have also updated the environment variable of Path to:</p>
  
  <pre><code>C:\Program Files (x86)\Development\
  </code></pre>
  
  <p>When I double click:</p>
  
  <pre><code>sqlite3.exe
  </code></pre>
  
  <p>It opens up the command prompt with the address at the top as:</p>
  
  <pre><code>C:\Program Files (x86)\Development\sqlite3.exe
  </code></pre>
  
  <p>It opens up and is:</p>
  
  <pre><code>"Connected to a transient in-memory database."
  (transient in-memory database) is in red text
  </code></pre>
  
  <p>Looking around this means that it saves to memory and not hard disk but if you specify:</p>
  
  <pre><code>.save testDB
  </code></pre>
  
  <p>Then all should be good, but not for me. I have tried:</p>
  
  <pre><code>sqlite3 testDB.db
  .save testDB
  create table tbl1(one varchar(10), two smallint);
  </code></pre>
  
  <p>But I get the error:</p>
  
  <pre><code>Error: near "sqlite3" syntax error
  </code></pre>
  
  <p>Any ideas what I'm doing wrong? I have SQLite manager installed too but I assume I can't use that until a database is saved to disk?</p>
  
  <p>Thanks.</p>
  
  <p>Would changing my Path variable to:</p>
  
  <pre><code>C: \Program Files (x86)\Development\
  </code></pre>
  
  <p>Make any difference i.e. a space between : and the \?</p>