On Dec 30, 2008, at 1:29 AM, schachtobi wrote: > >> Date: Mon, 29 Dec 2008 11:20:58 +0700 >> From: Dan <[email protected]> >> Subject: Re: [sqlite] sqlite3_get_table question >> To: General Discussion of SQLite Database <[email protected]> >> Message-ID: <[email protected] > > >> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
