Aaron Brady
3/1/2008 6:02:00 PM
On Mar 1, 11:54 am, "Diez B. Roggisch" <de...@nospam.web.de> wrote:
> nexes schrieb:
>
> > Hello All,
> > 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.
>
> Diez
There's a number of things it could be-- narrow it down a little more
(for the reader). Beginner stuff is usually forgetting 'use
moviedata'.