"A.J.Millan" <[EMAIL PROTECTED]> wrote: > Hello all: > > Using Windows XP: > > D:\Z\Zator5>sqlite3 zdb1 > SQLite version 3.5.4 > Enter ".help" for instructions > sqlite> .tables > AgEfHolder AgEfemer AgVtHolder AgVtos Usr lnk > AgEfIDt AgPdHolder AgVtIDt Block atm prm > AgEfKlv AgPdIDt AgVtPre FreqUse blb > > sqlite> .schema blb > CREATE TABLE 'blb' (ID INTEGER PRIMARY KEY, Nm INTEGER); > sqlite> > > I'm having troubles with this pseudo code: > > > begin transaction > > > some successful operations on tables atm and blb > > > sqlite3_blob* pBlob; > > > // open Blob for read/write access > > int res = sqlite3_blob_open (dbPtr, "D:\\Z\\zDB1", "blb", "nm", Id, 1, > > &pBlob); > > Here res = 1, and I get the following error: > > SQL error: no such table: D:\Z\Zator5\zDB1.blb >
The "database name" is not the same thing as the name of the file tht contains the database. The database name is the name assigned to the database when you ATTACH it. Or, for the original database, then name is "main". Or for TEMP tables, the name is "temp". -- D. Richard Hipp <[EMAIL PROTECTED]> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
