I have solved my problem below
------------------------
I am trying to add an index to my database, but the following code is
failing in CREATE INDEX with error 14 (unable to open Database file).
rc = sqlite3_open(OurDataBaseName, &db);
if (rc)
{
fprintf(stderr, "sqlite3_open returned %d\n",rc);
return -1;
}
rc = sqlite3_exec(db, "CREATE INDEX leaves_index on LEAVES (leafID)",
0, 0, &errmsg);
the OPEN worked fine, so why is CREATE INDEX returning this error ?
---------------------
I had just updated to the SQLite 3.5.6 amalgamation and I was opening
a database created with 3.4.1. That was giving me this error.
So, I just tried downgrading the SQLite amalgamation to 3.4.1 and
suddenly the CREATE INDEX is working.
Anyone have an explanation for this ?
Thanks
Mark
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
