>
> Hmmm, OK, try:
>
> .dump symbols
>
> and see what you get.
I get the same queries and I am not seeing anything unusual with that.
I tried creating another database through the Sqlite command line tool
and executed the output got from ".dump symbols". In that DB, the
selects seems to be working fine.
So I am suspecting the way my application creates and inserts DB is
wrong. Here is what I am doing.
#define VSTGEN_SYMBOLS_STORE "symbols"
snprintf(sql, 500, "insert into %s values (?1, ?2, ?3, ?4, ?5);",
VSTGEN_SYMBOLS_STORE);
rc = sqlite3_prepare_v2( db, sql, 500, &stmt, NULL );
if( rc == SQLITE_OK )
{
/* .... */
rc = sqlite3_bind_text(stmt, 2, tok->pattern, VARNAM_SYMBOL_MAX,
NULL); /* debugged and tok->pattern doesn't have any extra
characters. strlen(tok->pattern) return 1 */
if(rc != SQLITE_OK) {
/* error reporting */
}
/* other parameter bindings */
rc = sqlite3_step( stmt );
}
Finally the transaction will get committed.
>
> Id the above dump doesn't help, email me the file directly and I'll have a
> look.
>
Thanks & Done!
--
Navaneeth
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
