RE: [sqlite] reseting primary key

:28:57 -0400, Jonathan Kahn wrote: >Hey all, > I have tried different things such as reindex and vacuum on my primary key >auto inc field but I cannot reset it so that things start from one. I >deleted everything from my table but it still keeps the amount that was >there beforehand

[sqlite] reseting primary key

Hey all, I have tried different things such as reindex and vacuum on my primary key auto inc field but I cannot reset it so that things start from one. I deleted everything from my table but it still keeps the amount that was there beforehand on the auto inc so anything new is appened to that

RE: [sqlite] Re: best performance

Thanks a lot to you both! - Jon -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 8:57 AM To: SQLite Subject: [sqlite] Re: best performance Jonathan Kahn <[EMAIL PROTECTED]> wrote: > In my application I currently perform a lo

[sqlite] best performance

In my application I currently perform a loop inside a recursive function and sqlite3_bind_* on various fields then call sqlite3_step and a reset inside my loop but it is fairly slow when inserting, is there a faster way of inserting inside a loop? Ie) while(whatever > 0) {

RE: [sqlite] Re: Re: stmt question

Thanks a lot -Original Message- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 6:00 PM To: SQLite Subject: [sqlite] Re: Re: stmt question Jonathan Kahn <[EMAIL PROTECTED]> wrote: > Ahh thanks a lot for clearing that up I wasn't sure if reset cle

RE: [sqlite] Re: stmt question

: Wednesday, May 02, 2007 5:48 PM To: SQLite Subject: [sqlite] Re: stmt question Jonathan Kahn <[EMAIL PROTECTED]> wrote: > If I prepare a statement can I bind variables as my value and then > set the variables in a loop and execute? Or in my loop would I bind > my values and step so

[sqlite] stmt question

Hi, I have a couple questions about using prepared statements with sqlite. If I prepare a statement can I bind variables as my value and then set the variables in a loop and execute? Or in my loop would I bind my values and step so each bind gets executed until it equals SQLITE_DONE then

RE: [sqlite] Need Help with SQL Statement

Use LIMIT 4 Thanks - Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 30, 2007 6:10 PM To: sqlite-users@sqlite.org Subject: [sqlite] Need Help with SQL Statement I have a file with the columns: StockSymbol, OptionSymbol, StockPrice,

RE: [sqlite] sqlite and borland c++ builder

++ builder Jonathan Kahn wrote: > > > When I try to use the header I get errors > > [C++ Error] sqlite3.h(1778): E2232 Constant member > 'sqlite3_index_info::nConstraint' in class without constructors > > > > Jonathan, This is indeed a bug in the Borland/

RE: AW: [sqlite] sqlite and borland c++ builder

che Nachricht- > Von: John Stanton [mailto:[EMAIL PROTECTED] > Gesendet: Sonntag, 29. April 2007 18:31 > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] sqlite and borland c++ builder > > Why not use gcc to compile your library, or use a precompiled DLL? >

RE: [sqlite] sqlite and borland c++ builder

, - Jon -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Sunday, April 29, 2007 12:31 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite and borland c++ builder Why not use gcc to compile your library, or use a precompiled DLL? Jonathan Kahn wrote: > Hi Ul

RE: [sqlite] sqlite and borland c++ builder

led with a compiler that emits code with C calling conventions. This enables calling C code from within C++. As you probably know, calling conventions have to do with, among other things, the way function parameters are put on the stack, and the way any return value is returned. HTH Regards,

RE: [sqlite] sqlite and borland c++ builder

PROTECTED] Sent: Sunday, April 29, 2007 2:12 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] sqlite and borland c++ builder --- Jonathan Kahn <[EMAIL PROTECTED]> wrote: > I really appreciate your response. What do you suggest I do? Is there > something else I need to include aside f

RE: [sqlite] sqlite and borland c++ builder

and borland c++ builder Hi Jon, is it not an option to build SQLite with a C compiler, then call it from within C++? Regards, Ulrik Petersen Jonathan Kahn wrote: > Even when I try to build a new dll I get errors with attach.c and it says > cannot convert 'void *' to 'Db *', no matter what route

RE: [sqlite] sqlite and borland c++ builder

Even when I try to build a new dll I get errors with attach.c and it says cannot convert 'void *' to 'Db *', no matter what route I take I always hit a bump. I'm just trying anything at this point - Jon -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sunday, April

RE: [sqlite] sqlite and borland c++ builder

I really appreciate your response. What do you suggest I do? Is there something else I need to include aside from sqlite3.lib? I am willing to try anything. Thanks a lot - Jon -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 29, 2007 1:59 AM To:

[sqlite] sqlite and borland c++ builder

This is my first post and it is out of desperation. I am using Borland c++ builder with Borland developer studio 2006 I can not for the life of me get anything sqlite functioning properly with this. I have relentlessly searched google as well as the mailing list and tried any information I have