SQLLITE

[Daniel Fetchinson]

> > > I am having a minor problem when I try and do this:
> > > c.execute("insert into [tblTranscripts] (MovieID,Transcript)
> > > Values(" + movieID + ",'" + formatText + "');") (don't even bother
> > > commenting of the sql style I know its bad form but this is a simple
> > > script). Whenever I try and do the insert I get table not found,
> > > however when I perform the sql through sqlite's command line program
> > > (the sql is outputted via a print statement) it works fine. Any ideas?
> >
> > No, and without more context nobody will have. Does working with the
> > table with other statments work, how do you connect the DB, are you sure
> > you really use the same DB-file and so forth.
> >
> Beginner stuff is usually forgetting 'use moviedata'.

This is not needed for sqlite. The database is defined by the file the
sqlite executable is working on.