I''ve been using ruby sqlite on windows 7 64 bit with out any problem.
Here's a copy of the program you can use as an example
I'm using ruby 1.93. It wouldn't work on earlier versions of ruby
···
#================================================
#
# Create dxcc_diamond sqlite data base
#
#================================================
ctable = false #true to create new tables and database. (delete previous database if starting over)
require 'sqlite3'
db = SQLite3::Database.new( "dxcc.sq3" )
db.execute("create table if not exists dxid(dpfx primary key unique, country, continent,ditu,dcq,call)")
db.execute("create table if not exists callid(cpfx primary key unique,dxpfx, citu, ccq)")
if ctable
fdx = File.new("dxcc_list2.txt")
fdx.each do |l|
l.gsub!("\'","-")
d = l.chomp.split("\t")
db.execute("insert into dxid values('#{d[0]}','#{d[1]}','#{d[2]}','#{d[3]}','#{d[4]}','#{d[5]}')")
end
fdx.close
p "============================="
fdx = File.new("call_list2.txt")
fdx.each do |l|
l.gsub!("\'","-")
d = l.chomp.split("\t")
db.execute("insert into callid values('#{d[0]}','#{d[1]}','#{d[2]}','#{d[3]}')")
end
fdx.close
end
#SELECT Call_list.DM_PFX, Dxcc_list.PFX, Dxcc_list.COUNTRY, Dxcc_list.CONTINENT
#FROM Call_list INNER JOIN Dxcc_list ON Call_list.PFX = Dxcc_list.PFX
#WHERE (((Call_list.DM_PFX) Like [call_prefix]));
#WHERE (((callid.cpfx) = 'CO'))
#db.execute("select callid.cpfx from callid") {|x| p x}
db.execute("SELECT callid.cpfx, dxid.dpfx, dxid.country, dxid.continent \
FROM callid JOIN dxid ON callid.dxpfx = dxid.dpfx \
WHERE (((callid.cpfx) like 'X%'))") {|x| p x}
#db.execute("insert into callid values( '4UTAR', '4U1U', '88', '99')")
#db.execute("insert into rlog values (2,'N4ddn','2/3/04')")
#db.execute("insert into rlog (call,cdate) values ('zk5rd','2/3/4')")
#db.execute("select * from rlog sort order by call") {|x| p x}
Kaye Ng 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 ";"
> SQL
...> CREATE TABLE people (
...> id integer primary key,
...> name varchar(50),
...> job varchar(50),
...> gender varchar(6),
...> age integer);
Error: near "SQL": syntax error
>
I didn't have this problem with my other machine, windows 7 32-bit.
Help pls?
Thanks much!
