Thanks, Rodrigo, but I put the \db\ directory into the Path and tried
the call in both the Ruby command line and a regular command line from
that directory where I have development.sqlite3, trying both "sqlite"
and "sqlite3" as the call at the beginning of the line, but I get the
same error that they still aren't recognized as a command. What else
could I be forgetting to do?
Barney
On Jul 12, 1:14 pm, Rodrigo <[email protected]> wrote:
> Barney,
>
> I think you have to enter the sqlite shell if you want to run those
> types of commands (e.g., select * etc...).
>
> Run sqlite on the "development" db, try this:
>
> $ cd [app_name]
> $ cd db/ # your development.sqlite3 file should be here...
> $ sqlite development.sqlite3 # now the sqlite shell should boot
>
> Now you can run your SQL commands:
>
> $ sqlite> select * from orders limit 1
>
> See generallyhttp://www.sqlite.org/sqlite.html
>
> -Rodrigo
>
> On Jul 12, 1:05 pm, Barney <[email protected]> wrote:
>
> > Hello,
> > I'm using the newest "Agile Web Development With Rails" book and
> > the Ruby command line call near the end of p. 267 is:
> > sqlite3 -line db/development.sqlite3 "select * from orders limit 1"
> > and this, (with my own table, which has data which was verified by
> > looking at the WEBRick output in a browser) gives the error:
> > sqlite3 is not recognized as an internal or external command, operable
> > program or batch file.
> > But, sqlite3 is installed and working (by Web verification) and also
> > the rails console works and shows me the column_names, etc. Also,
> > sqlite3.dll exists in c:\ruby192\bin\ and that path is in my
> > environment PATH variable. I'm using Windows XP.
> > What am I forgetting to do?
> > Thanks,
> > Barney
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
