Hi,
I've choosen sqlite 3.6.11 for a small purpose in my organisation.
The software runs on a proprietroy OS.
SQLite is used by a single process, there are no other threads using SQLite,
hence SQLITE_THREADSAFE = 0.
I have written the memory and OS functions.
My Schema table is very simple, as under.
static char NVDataTable[] =
"CREATE TABLE NVDataTable( "
"iDataId INTEGER PRIMARY KEY, "
"iVoidData INTEGER, "
"iDefaultData INTEGER,"
"cStringId VARCHAR(32) DEFAULT '' NOT NULL,"
"iSize INTEGER, "
"iReadOnly INTEGER, "
"iCiphered INTEGER )";
I was able to successfully Open database - using sqlite3_open().
I was able to successfully create table - using sqlite3_exec().
Ofcourse, I struggled a LOT to achive the above two ... (even though i had
worked on 3.2.2 long ago)
I'm NOT able to INSERT a record into the database using - sqlite3_mprintf() and
sqlite3_exec()
*z = sqlite3_mprintf("INSERT INTO NVDataTable VALUES(NULL, '%d', '%d', \"%s\",
'%d', '%d', '%d' )",
iVoidData, iDefaultData, stTmp, 1u, iReadOnly,
iCiphered);
I get a return error as - 1
And, an error message as - [Error:= no such table: NVDataTable ]
I'm not getting any clue. How do I verify the table after I've created the
table.
I just need to achive INSERT and SELECT.
The SELECT is just a simple fetch of record based on id, there are no complex
or conditional queries.
Please help me.
Thanks in advance.
Mayura S.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
