Hi,

I am trying to use sqlite_trace and sqlite_profile to trace what SQL
statements have been executed.

In the callback function of sqlite_trace/profile I simply print out the SQL
statement which triggers the callback. And in sqlite_open_v2() I have:
sqlite3_trace(*ppDb, print_sql_callback, *ppDb);
sqlite3_profile(*ppDb, print_sql_callback, *ppDb);


However, it seems like not every SQL statement is captured. As I also
instrumented sqlite_step(), sqlite_bind_*(), and sqlite_clear_binding(),
sqlite_reset() to print out log. And some sql statements which are shown in
these logs do not seem to be printed out by sqlite_trace or sqlite_profile.

Does anyone have an idea about what went wrong here?

Thanks a lot!

Suli

-- 
Suli Yang

Department of Physics
University of Wisconsin Madison

4257 Chamberlin Hall
Madison WI 53703
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to