On Sat, 04 Oct 2014 10:44:20 -0400, Mark Halegua
wrote:
> self.cdata.execute('insert into publishers(publisher_name,
>remarks) values("test", "remarks");')
Are you sure this is correct?
In SQL, string literals are delimited by single quotes.
Double
> > > >of capturing/redirecting the stderr output and using an except there.
> > > >
> > > >On Friday, October 03, 2014 11:35:08 PM you wrote:
> > > >> the sqlite3 command line doesn't require a commit, it gave an error
> > > >>
> > > >of capturing/redirecting the stderr output and using an except there.
> > > >
> > > >On Friday, October 03, 2014 11:35:08 PM you wrote:
> > > >> the sqlite3 command line doesn't require a commit, it gave an error
> > > >>
e3
> >>> sqlite3.sqlite_version
>
> '3.8.7'
>
> >>> sqlite3.version
>
> '2.6.0'
>
>
> sqlite3.version is the version number of pysqlite ...
>
> >-Original Message-
> >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>
-
> >boun...@sqlite.org] On Behalf Of Mark Halegua
> >Sent: Saturday, 4 October, 2014 10:11
> >To: General Discussion of SQLite Database
> >Subject: Re: [sqlite] passing error messages to pysqlite
> >
> >and now the windows version, with sqlite 3.8.6 and a local databa
on number of pysqlite ...
>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Mark Halegua
>Sent: Saturday, 4 October, 2014 10:11
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] passing
and now the windows version, with sqlite 3.8.6 and a local database and local
code in the
same directory is doing the same, database locked. And yet, at the command
line I could
do an insert no problem.
Mark
On Saturday, October 04, 2014 12:00:59 PM Mark Halegua wrote:
> Kieth,
>
> the
sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> >boun...@sqlite.org] On Behalf Of Mark Halegua
> >Sent: Friday, 3 October, 2014 20:58
> >To: sqlite-users@sqlite.org
> >Subject: [sqlite] passing error messages to pysqlite
> >
> >I have a sqlite3 database. In
nge?
>
> >-Original Message-
> >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> >boun...@sqlite.org] On Behalf Of Mark Halegua
> >Sent: Friday, 3 October, 2014 20:58
> >To: sqlite-users@sqlite.org
> >Subject: [sqlite] passing error messages to
Kieth,
the database is not locked. It is a copy residing on the local hard drive in
the same
directory as the python code and that version of sqlite3. I was able to do an
insert with the
same sqlite3 in that directory as the code, so this behavior is somehow wrong.
The two systems I've
lite requires one?
> > >>
> > >> Mark
> > >>
> > >> On Friday, October 03, 2014 09:06:56 PM Keith Medcalf wrote:
> > >> > Are you committing the change?
> > >> >
> > >> > >-Original Me
and using an except there.
>> >
>> >On Friday, October 03, 2014 11:35:08 PM you wrote:
>> >> the sqlite3 command line doesn't require a commit, it gave an error
>> >> after the attempted insert command.
>> >>
>> >> pysqlite requires o
>> > Are you committing the change?
> >> >
> >> > >-Original Message-
> >> > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> >> > >boun...@sqlite.org] On Behalf Of Mark Halegua
> >> > >Sent: Friday,
Friday, October 03, 2014 09:06:56 PM Keith Medcalf wrote:
>> > Are you committing the change?
>> >
>> > >-Original Message-
>> > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> > >boun...@sqlite.org] On Behalf Of Mark Halegu
ers-boun...@sqlite.org [mailto:sqlite-users-
> > >boun...@sqlite.org] On Behalf Of Mark Halegua
> > >Sent: Friday, 3 October, 2014 20:58
> > >To: sqlite-users@sqlite.org
> > >Subject: [sqlite] passing error messages to pysqlite
> > >
> > >I hav
Are you committing the change?
>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Mark Halegua
>Sent: Friday, 3 October, 2014 20:58
>To: sqlite-users@sqlite.org
>Subject: [sqlite] passing error messages to
I have a sqlite3 database. In the networkied are I have the db is locked
(wee've
discussed this before, and I'm using it mostly on a local machine, but I need
to
test certain conditions, networking being one).
In the sqlite3 command line, when I try to insert new info I get a dabase
locked
17 matches
Mail list logo