Hi !
I have this code in my program. Before this I use APSW, but that
project's connection object doesn't have close method...
.... crs.execute(*'' 'create table files
(*f_id integer not null primary key, f_name varchar(255), f_size long,
f_attr integer, f_crtime varchar(20), f_mdtime varchar(20), f_hash long
)*''') ...
crs=connection. cursor()
crs.execute('in sert into files
(f_crtime,f_mdt ime,f_attr,f_id ,f_hash,f_size, f_name)
values(?,?,?,?, ?,?,?)',('1','1 ',1,1,1,1,'a')) ... *
So: I create a table in the first, and later I want to push some
elements to it. Before this example code I use special method to create
insert sql with tuple of values. But everytime it have been failed with
this message: SQL error or inaccessible database. Then I simplified the
code with hand maded SQL. And then I got same error message. The
database file removed and rebuilded with every execution.
When I tired by this error, I returned to APSW, and then I don't got
error messages.
What is the problem in this package ?
http://initd.org/pub/software/pysqli...in32-py2.4.exe
With Py2.3 I use pysqlite package in my CD organizer program, and then I
does not exp. same problems.
Please help me: dd