> 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)
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
