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}
