From: Zachary Scott <zachary@...>
Date: 2012-04-27T15:35:29+09:00
Subject: Re: ruby/shoes GUI - sqlite, how to isert a variable key in table?

Hi Danilo, How are you enjoying shoooes?

Make sure to interpolate those instance variables!

db.execute "insert into db.table (column-name) values (#{@ivar})"



On Thu, Apr 26, 2012 at 10:47 PM, Danilo L. <lists@ruby-forum.com> wrote:
> Hello, I am struggling to insert a variable into a table, for example:
>
>
> @name = edit_line
>
> db = SQLite3::Database.new "test.db"
> db.execute "create table teste (teste VARCHAR(25))"
> db.execute "insert into teste (teste) values (@name)"
>
>
> How can I add what has been written in edit line in table?
>
> --
> Posted via http://www.ruby-forum.com/.
>