sqlite is not ruby, so you should look for a sqlite group ;)

However it looks like you  have 'SQL' at the beginning of your CREATE
command which is the problem

On Fri, Aug 3, 2012 at 12:21 PM, Kaye Ng <lists / ruby-forum.com> wrote:
> I'm on Windows 7 Ultimate, 64-bit
>
> Installed sqlite:
>
> C:\Users\Kaye>gem install sqlite3
> Successfully installed sqlite3-1.3.6-x86-mingw32
> 1 gem installed
> Installing ri documentation for sqlite3-1.3.6-x86-mingw32...
> Installing RDoc documentation for sqlite3-1.3.6-x86-mingw32...
>
> then did this:
>
> C:\Users\Kaye>sqlite3 test.db
> SQLite version 3.7.10 2012-01-16 13:28:40
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> SQL
>    ...> CREATE TABLE people (
>    ...> id integer primary key,
>    ...> name varchar(50),
>    ...> job varchar(50),
>    ...> gender varchar(6),
>    ...> age integer);
> Error: near "SQL": syntax error
> sqlite>
>
> I didn't have this problem with my other machine, windows 7 32-bit.
> Help pls?
>
> Thanks much!
>
> --
> Posted via http://www.ruby-forum.com/.
>