Re: [sqlite] Trace callback is not called in a specific case

2014-09-27 Thread Hody Crouch
Well that's embarrassing. There wasn't a binary in the current directory, but I think the linker picked up the 3.8.5 binary from elsewhere (confirmed by checking the sqlite3 version in the test app, which returned 3.8.5). I retested (linking correctly this time) against both the 3.8.6 amalgamatio

Re: [sqlite] Trace callback is not called in a specific case

2014-09-27 Thread Stephan Beal
On Sat, Sep 27, 2014 at 11:08 PM, Hody Crouch wrote: > $ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread > $ ./a.out > TRACE: SELECT val1, val2 from t where val2 = 'A%' > What is -l sqlite3 supposed to do? It's not a valid linker flag (-l and its argument should have no spaces between them). It lo

Re: [sqlite] Trace callback is not called in a specific case

2014-09-27 Thread Hody Crouch
Thank you for looking into this. In my test, I linked against sqlite3 using '-l sqlite3' in the gcc command line. I see that you compiled sqlite3 into an object file first. If I build using your command, the trace works as expected. When I link against the source directly, I see the unexpected

Re: [sqlite] Trace callback is not called in a specific case

2014-09-26 Thread Richard Hipp
On Fri, Sep 26, 2014 at 6:44 PM, Hody Crouch wrote: > Test code is provided below. If you change the sql query to include 'val2 > = ?' rather than 'val2 LIKE ?', you will see trace output. > It works fine when I try it: drh@bella:~/sqlite/bld$ gcc -g -I. x1.c sqlite3.o -ldl -lpthread drh@bella

Re: [sqlite] Trace callback is not called in a specific case

2014-09-26 Thread Hody Crouch
Test code is provided below. If you change the sql query to include 'val2 = ?' rather than 'val2 LIKE ?', you will see trace output. #include #include #include "sqlite3.h" static void trace_callback( void* udp, const char* sql ) { printf("TRACE: %s\n", sql); }; int main(int argc, char* argv

Re: [sqlite] Trace callback is not called in a specific case

2014-09-26 Thread Richard Hipp
On Thu, Sep 25, 2014 at 5:58 PM, Hody Crouch wrote: > While using sqlite3 with node, I used trace and found that a specific query > did not result in a callback invocation. I have only seen this behavior if > all of the following conditions are met: > - sql query includes 'LIKE ?' > - prepare th

[sqlite] Trace callback is not called in a specific case

2014-09-26 Thread Hody Crouch
While using sqlite3 with node, I used trace and found that a specific query did not result in a callback invocation. I have only seen this behavior if all of the following conditions are met: - sql query includes 'LIKE ?' - prepare the query - bind a parameter - execute the query If I change the

Re: [sqlite] SQLite Trace Log

2013-02-11 Thread Patrik Nilsson
Hello, Not exactly the program language you asked for, but here it is how I have it in C for gtk: Call this function after opening the connection: sqlite3_trace ( sqliteconnection, sqlite_trace, NULL ); static void sqlite_trace ( void *arg, const char *query ) { FILE *file = fopen ( "/tmp/

[sqlite] SQLite Trace Log

2013-02-10 Thread Winston Brummer
Hi I saw in the version history that SQLite makes use of trace listeners. Could anyone give me an example of how to attach a trace listener to an application that uses System.Data.SQLite? Specifically related to the compact frame work version for Windows Mobile and Pocket PC. Any help would be gr

[sqlite] Trace

2008-02-10 Thread Mahalakshmi.m
Hi , I am working in 3.3.6. If I want to use the "TRACE" what steps I have to follow. Thanks & Regards, Mahalakshmi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users