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

Neither I have luck with:

> int res = sqlite3_blob_open (dbPtr, "zDB1", "blb", "nm", Id, 1, &pBlob);

D:\Z\ is my actual (working) directory

Do is there some that I'm missing or misunderstood?

Thanks for any idea.

Adolfo.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to