On Dec 30, 2008, at 1:29 AM, schachtobi wrote: > >> Date: Mon, 29 Dec 2008 11:20:58 +0700 >> From: Dan <danielk1...@gmail.com> >> Subject: Re: [sqlite] sqlite3_get_table question >> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >> Message-ID: <65fa0cc6-4248-4675-8100-f069423e0...@gmail.com > > >> Why (ncol+2)? > > > I make the following select statement: > > SELECT fname, dsize, data, ABS(red-%d)+ABS(green-%d)+ABS(blue-%d) err > FROM ch ORDER BY err LIMIT 1; > > If I want to have the data then this would be 2 + the number of > heading > columns (ncol)
Right. Obviously. Note that sqlite3_get_table() won't work for data with embedded 0x00 bytes. It will truncate each value at the first one encountered. That could be the problem. > > > The database structure is like the following: > > CREATE TABLE IF NOT EXISTS ch( > fname TEXT UNIQUE, > red INTEGER, > green INTEGER, > blue INTEGER, > dsize INTEGER, > data BLOB); > > Does anybody sees a possible solution for accessing the data (blob) > for > indexes (rgb) higher than 4k Pixels? > > Regards, > Tobias > > _______________________________________________ > 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