Newbie in Ruby...Issues while connecting Ruby with Sqlite3

M

Manish Kalra

Hi,

I am a newbie in Ruby. Its very interesting language. Now, my problem is
with the below code.

require 'rubygems'
require 'sqlite3'
db = SQLite3:atabase.new( "test2.db" )
db.execute("create table t1 (id INTEGER PRIMARY KEY,data TEXT,num
double,timeEnter DATE)")
db.execute( "insert into t1 (data,num) values ('This is sample
data',3)")
rows = db.execute( "select * from t1" )
end

I am receiving this error: "database.rb:7: syntax error, unexpected
kEND, expecting $end"

Please help.

I have installed the sqlite3 gem.

Please help. Thanks!
 
M

Michael Libby

Hi,

I am a newbie in Ruby. Its very interesting language. Now, my problem is
with the below code.

require 'rubygems'
require 'sqlite3'
db = SQLite3:atabase.new( "test2.db" )
db.execute("create table t1 (id INTEGER PRIMARY KEY,data TEXT,num
double,timeEnter DATE)")
db.execute( "insert into t1 (data,num) values ('This is sample
data',3)")
rows = db.execute( "select * from t1" )
end

I am receiving this error: "database.rb:7: syntax error, unexpected
kEND, expecting $end"

This error message is telling you the filename, then the line number
where the error is to be found. It is also telling you that it's a
syntax error, and what kind of syntax error. In this case it found an
unexpected kEND (an END keyword), like the "end" on the last line of
your program. That "end" doesn't match any starting keyword (like
"if", "while", "begin", "def", or "class", to name a few), so it's a
problem. Just remove it. The program will end on its own.

If you need to ensure that the program exits, use Kernel.exit instead.

-Michael Libby
 
D

_-_ Daniel _-_

This error message is telling you the filename, then the line number
where the error is to be found. It is also telling you that it's a
syntax error, and what kind of syntax error. In this case it found an
unexpected kEND (an END keyword), like the "end" on the last line of
your program. That "end" doesn't match any starting keyword (like
"if", "while", "begin", "def", or "class", to name a few), so it's a
problem. Just remove it. The program will end on its own.

If you need to ensure that the program exits, use Kernel.exit instead.

-Michael Libby

FYI: db = SQLite3:atabase.new( "test2.db" )

atabase.new ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top