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 <[email protected]> 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/. > -- You received this message because you are subscribed to the Google Groups ruby-talk-google group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at https://groups.google.com/d/forum/ruby-talk-google?hl=en
