Re: [sqlite] sample code in C++ to get the data from sqlite database loop thru the record set

2007-12-18 Thread John Stanton
Here is a code fragment in C. You add the C++. Joanne Pham wrote: Hi All, If you have the sample code in C++ to run the command "Select column1, column2 from tablea" from C++ code and able to loop thru the record set to get each rows please share with me. Thanks in Advance, Joanne __

[sqlite] sample code in C++ to get the data from sqlite database loop thru the record set

2007-12-18 Thread Joanne Pham
Hi All, If you have the sample code in C++ to run the command "Select column1, column2 from tablea" from C++ code and able to loop thru the record set to get each rows please share with me. Thanks in Advance, Joanne

Re: [sqlite] sample code

2007-12-11 Thread Clay Dowling
Tom Parke wrote: > Where can I find some sample C code for stepping thru a result set and > for binding variables to columns? I am just beginning to experiment > with Sqlite3 and I am having a hard time getting aquainted. http://www.lazarusid.com/sqlite3 >From a Linux Journal article several ye

[sqlite] sample code

2007-12-11 Thread Tom Parke
Where can I find some sample C code for stepping thru a result set and for binding variables to columns? I am just beginning to experiment with Sqlite3 and I am having a hard time getting aquainted. Thanks, Tom

Re: [sqlite] Sample code

2005-10-26 Thread Alfredo Cole
El Miércoles, 26 de Octubre de 2005 16:17, John Stanton escribió: > Alfredo, this simple example may may help > (...) This is good! Thank you and regards. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Sample code

2005-10-26 Thread John Stanton
Alfredo, this simple example may may help /*These global definitions are the uncompiled SQL for accessing the database.*/ static char *dbst_cart_wt_in_ins = "INSERT INTO CART_WT_IN VALUES (?, ?, ?, ?)"; static sqlite3_stmt *dbcmp_cart_wt_in_ins; static const char *dbend_cart_wt_in_in

Re: [sqlite] Sample code

2005-10-26 Thread Alfredo Cole
El Miércoles, 26 de Octubre de 2005 08:53, escribió: > On 10/26/05, Alfredo Cole <[EMAIL PROTECTED]> wrote: > > I have searched, but have not found samples of actual uses of > > sqlite_compile, sqlite_step and sqlite_finalize. Could anybody point the > > way to where I can find samples with sou

Re: [sqlite] Sample code

2005-10-26 Thread Jay Sprenkle
On 10/26/05, Alfredo Cole <[EMAIL PROTECTED]> wrote: > I have searched, but have not found samples of actual uses of sqlite_compile, > sqlite_step and sqlite_finalize. Could anybody point the way to where I can > find samples with source code to use these functions? It's c++ but here's some:

[sqlite] Sample code

2005-10-26 Thread Alfredo Cole
Hi: I have searched, but have not found samples of actual uses of sqlite_compile, sqlite_step and sqlite_finalize. Could anybody point the way to where I can find samples with source code to use these functions? Thank you. -- Alfredo J. Cole Grupo ACyC

Re: [sqlite] Sample code

2004-10-29 Thread Paul Pigott
Thanks, this is just what I was looking for. Paul - Original Message - From: "Clay Dowling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 29, 2004 9:27 AM Subject: Re: [sqlite] Sample code > > Paul Pigott said: > > I'm putting

Re: [sqlite] Sample code

2004-10-29 Thread Clay Dowling
Paul Pigott said: > I'm putting together a small test program based on some code I found in > "C/C++ Users Journal". The original code was in sqlite2, and I'm using > sqlite3. I'm having a couple of issues with the sqlite3_stmt definition > and its use in sqlite3_prepare and sqlite3_step. Does

Re: [sqlite] Sample code

2004-10-29 Thread Ulrik Petersen
Paul, You wrote: > Greetings all, > > I'm putting together a small test program based on some code I found in > "C/C++ Users Journal". The original code was in sqlite2, and I'm using > sqlite3. I'm having a couple of issues with the sqlite3_stmt definition > and its use in sqlite3_prepare and s

Re: [sqlite] Sample code

2004-10-29 Thread Ulrik Petersen
Paul, > Greetings all, > > I'm putting together a small test program based on some code I found in > "C/C++ Users Journal". The original code was in sqlite2, and I'm using > sqlite3. I'm having a couple of issues with the sqlite3_stmt definition > and its use in sqlite3_prepare and sqlite3_step.

Re: [sqlite] Sample code

2004-10-29 Thread Christian Smith
On Fri, 29 Oct 2004, Paul Pigott wrote: >Greetings all, > >I'm putting together a small test program based on some code I found in >"C/C++ Users Journal". The original code was in sqlite2, and I'm using >sqlite3. I'm having a couple of issues with the sqlite3_stmt definition >and its use in sqli

[sqlite] Sample code

2004-10-29 Thread Paul Pigott
Greetings all, I'm putting together a small test program based on some code I found in "C/C++ Users Journal". The original code was in sqlite2, and I'm using sqlite3. I'm having a couple of issues with the sqlite3_stmt definition and its use in sqlite3_prepare and sqlite3_step. Does anyone h