From: Tom Reilly <w3gat@...>
Date: 2012-08-07T08:50:26+09:00
Subject: Re: Help with sqlite3 please

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 ";"
> 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!
>