That work! Thanks a lot.
Adolfo. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, March 24, 2008 1:48 PM Subject: Re: [sqlite] Help with sqlite3_blob_open() > "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
