Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-11 Thread Lloyd Thomas
September 10, 2006 1:32 PM Subject: Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program On Sun, 10 Sep 2006 13:02:58 +0100, you wrote: Thanks Teg, I have been trying to do using a basic example but still running into problems. Can you expand a little more on your example below. This is where

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-10 Thread Lloyd Thomas
details.cidn[0] = 0; details.cidt[0] = 0; strcpy(details.term, ""); break; default: // Any thing else ?? break; } break; ----- - Original Message - From: <[EMAIL PROT

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-10 Thread tls
On Sun, 10 Sep 2006 13:02:58 +0100, you wrote: >Thanks Teg, > I have been trying to do using a basic example but still >running into problems. Can you expand a little more on your example below. >This is where I am so far. >I am getting a bit closer bit still getting some errors. clearly I am st

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-10 Thread Lloyd Thomas
ntf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } sqlite3_close(db); --- Lloydie T - Original Message ----- From: "Teg" <[EMAIL PROTECTED]> To: "Lloyd Thomas" Sent: Sunday, September 10, 2006 12:47 AM Subject: Re[2]: [sqlite

Re: Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Lloyd Thomas
all_time)values('details.inout','details.statime)" Do you have any ideas? Lloydie T - Original Message - From: "Teg" <[EMAIL PROTECTED]> To: "Lloyd Thomas" Sent: Sunday, September 10, 2006 12:47 AM Subject: Re[2]: [sqlite] A lillte help addi

Re[2]: [sqlite] A lillte help adding sqlite to a c program

2006-09-09 Thread Teg
Hello Lloyd, You need to escape the quotes. Remember in C and C++ " means the beginning or end of a literal string so, when you want to embed quotes in a string you have to escape them. Probaby \". You'd be better off using the paramaterized version of the SQL std::string sql = "insert into call