[sqlite] File format changed !!

I am trying to open a database created in SQLite 3.3.1 in SQlite 3.1.2 and I get the following err when I try to see the sqlite_master table .. SQL error: unsupported file format I suppose the file format has been changed over the versions, but the reverse does work, i.e db created on 3.1.2 c

[sqlite] sqlite3_exec vs. sqlite3_prepare / sqlite3_step

Hi, sqlite3_exec is a wrapper function for sqlite3_prepare / step, but which one of these is faster, I mean in terms of execution. sqlite3_exec should still call a callback function and do all the string handling !! Also how do I use sqlite3_exec along with BLOB, I am currentl

[sqlite] Fwd: Help regarding insertion into database

-- Forwarded message -- From: pavan savoy <[EMAIL PROTECTED]> Date: Feb 8, 2006 5:22 PM Subject: Help regarding insertion into database To: [EMAIL PROTECTED] Hi, Inside C program I have a structure and want to store it into a database, isnt there any datatype w

[sqlite] Fwd: Does SQLite provide XML support

-- Forwarded message -- From: pavan savoy <[EMAIL PROTECTED]> Date: Jan 31, 2006 7:17 PM Subject: Does SQLite provide XML support To: [EMAIL PROTECTED] Hi, I searched through your FAQ's mailing list, but the answer nor the question is not this simple. H