SQLLITE

[castironpi at gmail.com]

On Mar 1, 11:54 am, "Diez B. Roggisch" <de... at 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'.