[sqlite] Appending Text to a Column

I am trying to append text to a field within my database - sothat if a user has stored 'search, tools' into the Tags column of tblEntry, they can add more tags later like: update tblEntry set Tags = Tags + ' new text' where RowID = 13 But whenever I try to do this I end up with 0 in the

[sqlite] C++ Samples

I am new to c++ (I know php, c# etc), and thanks to this list I've gotten sqlite3 to open a db connection without failing to find its libraries. But now that I have an open db connection I am lost, I can work my way through the c++ itself but I'm having a hard time finding c++ sqlite3 samples,

[sqlite] Library Linking Issues on Ubuntu

> >#include > >#include > >#include > >#include > >#include > > > >int main() > >{ > >// create the database > >sqlite3 *db; > >int rc; > > > >rc = sqlite3_open("cmx.db", ); > >} > > This code will not create a database file, because there is > no schema to store. > You have

[sqlite] Library Linking Issues on Ubuntu

I keep getting: undefined reference to `sqlite3_open' Errors. I have seen forum posts etc on this but none of the suggestions are helping. I've tried including the sqlite3.c file in my compile but I get tons of errors and it won't build. I've tried adding -lsqlite3 to my compile code, then I