Have you created the table? what is the name of your database? If the
database is available in the disk, open it using sqlite shell.
Then execute the query "select * from sqlite_master;"
If your table is present in the database, it will be returned by this query
On Sun, 22 Mar 2009 19:03:21 +0530, Mayura S. <s_may...@yahoo.com> wrote:
> 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
______________________________________
Scanned and protected by Email scanner
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
