[sqlite] Can this be done in SQLite?

You should be able to concatenate the first and last name in a subquery and then use group_concat to output the single column you describe. For example: select group_concat(clientname, ';') from (select FirstName || ',' || LastName from yourtable); On Thu, Oct 8, 2015 at 4:54 PM, K. P. wrote:

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

014 at 11:08 PM, Hody Crouch <hody.cro...@gmail.com> > 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 (

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

TRACE: SELECT val1, val2 from t where val2 = 'A%' $ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread $ ./a.out TRACE: SELECT val1, val2 from t where val2 = 'A%' $ On Fri, Sep 26, 2014 at 10:06 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Sep 26, 2014 at 6:44 PM, Hody Crouch

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

NULL); sqlite3_bind_text(statement, 1, "A%", -1, NULL); sqlite3_step(statement); sqlite3_close(db); return 0; } On Fri, Sep 26, 2014 at 6:20 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Sep 25, 2014 at 5:58 PM, Hody Crouch <hody.cro...@gmail.com> > wrote: > &g

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

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