# Ruby SHOES - Transation SQL GET/PUT

**URL:** <https://www.ruby-forum.com/t/ruby-shoes-transation-sql-get-put/253678>\
**Category:** Uncategorized\
**Created:** [January 28, 2020, 6:46pm UTC](https://www.ruby-forum.com/t/ruby-shoes-transation-sql-get-put/253678 "2020-01-28T18:46:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dandrade](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ce7236/32.png) [@dandrade](https://www.ruby-forum.com/u/dandrade)\
**Post date:** [January 28, 2020, 6:46pm UTC](https://www.ruby-forum.com/t/ruby-shoes-transation-sql-get-put/253678/1 "2020-01-28T18:46:24Z")

</div>

CREATE TABLE ` products` (  
`id` INT NOT NULL AUTO\_INCREMENT,  
`name_prod` VARCHAR(40),  
`cod_prod` INT(14),  
PRIMARY KEY (`id`)  
);

----------- READ to put in drop\_list ---------------  
resultSet=client.query(“SELECT name\_prod FROM products”)

```
resultSet.each do |row|
    #@nove.items = [row['name_prod']]
	@nove = list_box :items => [row['name_prod']]
	@nove.move(260,170)
	
end

```

My problem is how to READ from element edit\_line and WRITE in element list\_box

In general I want to understand how to transfer the variables