Mark Hessling wrote: > Before I try and implement SQLGetData using the incremental BLOB I/O I > need to know if the approach I am taking is possible. > The major issue is with the API function sqlite3_blob_open(). It > requires: > const char *zDb - according to documentation this could be set to > "main" > const char *zTable - this can be obtained from > sqlite3_column_table_name() > const char *zColumn - this is supplied in the call to SQLGetData() > sqlite3_int64 iRow - requires the rowid of the table - how is this > obtained???
Usually with something like "select rowid from mytable where ...; ". If your ids are declared INTEGER PRIMARY KEY, then they are just aliases for rowid, and you can use their values directly. Otherwise you would have to retrieve the rowid with a separate query, or add it to your query as an extra column. > Remember this is a generic wrapper for the SQLite API. I cannot force > the user to code their SQL in a certain way (eg include rowid in each > query) You could try and rewrite the statement automatically to add an extra column. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
