From: ashbb <ashbbb@...>
Date: 2012-04-28T17:00:44+09:00
Subject: Re: ruby/shoes GUI - sqlite, how to isert a variable key in table?

--e89a8ffba9551ce8e104beb89eb0
Content-Type: text/plain; charset=ISO-8859-1

Hi Danilo,

Try out the following again.

require 'sqlite3'
Shoes.app do
  @name = "Danilo"
  db = SQLite3::Database.new "test.db"
  db.execute "create table test (test VARCHAR(25))"
  db.execute "insert into test (test) values ('#{@name}')"
  rows = db.execute "select * from test"
  rows.each{|name| para "#{name}"}
end

ashbb

--e89a8ffba9551ce8e104beb89eb0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Danilo,<br><br>Try out the following again.<br><br>require &#39;sqlite3&=
#39;<br>Shoes.app do<br>=A0 @name =3D &quot;Danilo&quot;<br>=A0 db =3D SQLi=
te3::Database.new &quot;test.db&quot;<br>=A0 db.execute &quot;create table =
test (test VARCHAR(25))&quot;<br>
=A0 db.execute &quot;insert into test (test) values (&#39;#{@name}&#39;)&qu=
ot;<br>=A0 rows =3D db.execute &quot;select * from test&quot;<br>=A0 rows.e=
ach{|name| para &quot;#{name}&quot;}<br>end<br><br>ashbb<br><br>

--e89a8ffba9551ce8e104beb89eb0--