SQLLITE

Diez B. Roggisch deets at nospam.web.de
Sat Mar 1 18:54:24 CET 2008


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



More information about the Python-list mailing list