From: Kaye Ng <lists@...>
Date: 2012-08-04T01:21:20+09:00
Subject: Help with sqlite3 please

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/.