On Jul 11, 2008, at 1:45 PM, Gregor Brandt wrote:
> I get and SQLITE_ERROR code form sqlite3_get_table. Upon checking
> sqlite3_errcode and sqlite3_errmsg I get 0 and 'not an error'.
Quoting from the documentation:
"The sqlite3_get_table() interface is implemented as a wrapper
around sqlite3_exec(). The sqlite3_get_table() routine does not have
access to any internal data structures of SQLite. It uses only the
public interface defined here. As a consequence, errors that occur in
the wrapper layer outside of the internal sqlite3_exec() call are not
reflected in subsequent calls to sqlite3_errcode() or sqlite3_errmsg()."
>
>
> The command SELECT * FROM `alarm_history` ORDER BY `alarm_id`; is very
> simple and most of the time it workswhy am I getting an error
> occasionally?
>
Maybe you could use the pzErrMsg parameter of sqlite3_get_table() to
find out?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users