From: Brian Candler <b.candler@...>
Date: 2009-06-08T21:35:10+09:00
Subject: Re: SQLite3 and ruby / shoes gui

Please try to post a *complete* program which demonstrates the problem. 
Try to make it not depend on shoes (e.g. use puts for output)

Then there's a good chance that someone will be able to run it, see the 
error in detail, and help you to fix it.

At the moment the only error you've shown is this:

> the error i get is /usr/local/lib/shoes/ruby/lib/sqlite3/errors.rb line
> 62
> library routine called out of sequence.

which isn't very much detail.

> now i'm only shown you the db.execute part as i think we can safely
> assume that the database is open and my db variable is a valid handle or
> i get more errors talking about the that database isn't open or some
> such messages.

"routine called out of sequence" sounds like you *might* have forgotten 
to open the database properly. That's why it's important to show a 
complete, minimal program that replicates the problem.

> also what is the correct way to do things with sqlite - 1 table per
> database file or can you have multiple tables within 1 database file?

You can have multiple tables within one file - this is how Rails sets 
things up anyway. If you didn't have them in one file, I'd be surprised 
if you could join between them.

Brian.
-- 
Posted via http://www.ruby-forum.com/.