Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later
> > Mensaje original > De: Pavel Ivanov > Para: a...@zator.com, General Discussion of SQLite Database > > Fecha: Wed, 09 Jan 2013 16:08:51 +0100 > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.75 version and > later > > > Did you type error message by hand (please don't do that) or you indeed > forgot the "g" at the end of db name? I'm sorry: The error message is Ok; the original sentence is really without the "g"; I've added it only for clarity purpose (the content of the "original" -attached- table is used to populate the "foreing" one). Regards. -- Adolfo J. Millan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later
On Wed, Jan 9, 2013 at 6:06 AM, wrote: > > > > > Mensaje original > > De: Clemens Ladisch > > Para: sqlite-users@sqlite.org > > Fecha: Wed, 09 Jan 2013 14:25:31 +0100 > > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version > andlater > > > > > > > >a...@zator.com wrote: > >>int resp = sqlite3_prepare_v2 (dbPtr, "SELECT ky,id,lev,pwd FROM > dbOrig.usr", -1, &pStmt1, 0); > > > > if (resp != SQLITE_OK) > > printf("error message: %s\n", sqlite3_errmsg(dbPtr)); > > > > > >Regards, > >Clemens > > error message: no such table: dbOri.usr Did you type error message by hand (please don't do that) or you indeed forgot the "g" at the end of db name? > > sqlite> .tables > AgEfHolder AgPdIDtBlockcoco ftsm_segments > AgEfIDt AgVtHolder FreqUseemail ftsm_stat > AgEfKlv AgVtIDt Usr ftsm lnk > AgEfemer AgVtPreatm ftsm_content prm > AgPdHolder AgVtos blb ftsm_segdir > > > Regards > Adolfo J. Millan > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later
> > Mensaje original > De: Clemens Ladisch > Para: sqlite-users@sqlite.org > Fecha: Wed, 09 Jan 2013 14:25:31 +0100 > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version > andlater > > > >a...@zator.com wrote: >>int resp = sqlite3_prepare_v2 (dbPtr, "SELECT ky,id,lev,pwd FROM >> dbOrig.usr", -1, &pStmt1, 0); > > if (resp != SQLITE_OK) > printf("error message: %s\n", sqlite3_errmsg(dbPtr)); > > >Regards, >Clemens error message: no such table: dbOri.usr sqlite> .tables AgEfHolder AgPdIDtBlockcoco ftsm_segments AgEfIDt AgVtHolder FreqUseemail ftsm_stat AgEfKlv AgVtIDt Usr ftsm lnk AgEfemer AgVtPreatm ftsm_content prm AgPdHolder AgVtos blb ftsm_segdir Regards Adolfo J. Millan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later
a...@zator.com wrote: >int resp = sqlite3_prepare_v2 (dbPtr, "SELECT ky,id,lev,pwd FROM > dbOrig.usr", -1, &pStmt1, 0); if (resp != SQLITE_OK) printf("error message: %s\n", sqlite3_errmsg(dbPtr)); Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version and later
Hi list: I've an application who from a long time, worked in Windows 98; XP; Vista; W7, and now in W8. The things go fine until now, but with SQLite versions 3.7.15 and 3.7.15.1, sqlite3_prepare_v2() fails and return 1. Here is a brief of the situation: 1.- The application is running in a (local) directory, and there is a dBase -say: D:\local\dB-, who has a table: "CREATE TABLE usr (ky INTEGER PRIMARY KEY,id CHARACTER UNIQUE,lev INTEGER,pwd TEXT)" 2.- Use:"PRAGMA page_size=4096" 3.- Create a dBase (same name) in a distinct (foreing) directory. Say: D:\someplace\dB 4.- Add the same table design to the "foreing" dbase: "CREATE TABLE usr (ky INTEGER PRIMARY KEY,id CHARACTER UNIQUE,lev INTEGER,pwd TEXT)" In a process to populate the foreing table with the "local" values: 5.- Attach the local dBase: "ATTACH dB AS dbOrig" (without pathname -is local-) 6.- Prepare to a read statement in the "foreing dBase: sqlite3_stmt* sTmt1 = NULL; int resp = sqlite3_prepare_v2 (dbPtr, "SELECT ky,id,lev,pwd FROM dbOrig.usr", -1, &pStmt1, 0); Here, resp = 1, and by the way, all previous opperations returned Ok, and the mentioned code, works fine with SQLite version 3.7.11. If I have not inadvertently broken something, perhaps it may be a bug. HTH. -- Adolfo J. Millán Zator Systems ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users