I have figured out where the problem is
In one place I forgot to call sqlite3_finalize(ppStmt);
Anyways, thanks a lot for your time.
Thanks once again.
mithin wrote:
>
> Thanks for replying.
>
> Here is what I do
>
> Open Database
>
> int err = 0
Thanks for replying.
Here is what I do
Open Database
int err = 0;
sqlite3_stmt *ppStmt;
if(sqlite3_open(dbPath.toUtf8().data(),) != SQLITE_OK){//It opens the
database correctly
sqlite3_close(db);
db = 0;
return false;
}
//set the restore point
//I thought this could
Hi,
In my application I am using SQLite 3 c++ API. Everything works fine till my
application is open. While doing any transaction a journal file is created.
Once I close the app, the journal file is not getting deleted. Also, when I
close open the application again, all the newly added data is
Hi,
I am importing a CSV file into a SQLite database. While doing the import i
am enclosing the insert statements between
"BEGIN TRANSACTION;" and "COMMIT TRANSACTION;"
The first time i do the import, everything is fine (its fas enough).
Performance decreases drastically when I try to import
True, I forgot to tell the size to QByteArray.
It works fine now.
Thanks a lot.
--
View this message in context:
http://www.nabble.com/BLOB-help-please-tf2573627.html#a7176466
Sent from the SQLite mailing list archive at Nabble.com.
Hi,
I have a CSV file that needs to be imported into a SQLite database and the
contents of the CSV file should be inserted into various tables of the
database.
1. Will using transaction speed up this opeartion of import?
2. Is the following method of using transaction correct or am I missing
Hi,
I want to find if the difference between the days of two dates is less than
or greater than some number. The year is not in the picture and it can be
anything. I gave the following query but it is not working.
SELECT * FROM date_details WHERE (date(date_details.value,%j) -
date('now',%j) <
7 matches
Mail list logo
