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
