RE: [sqlite] sqlite with Borland C++ 5.02

2004-10-18 Thread Pigott, Paul
My apologies for continuing to bring this up, but I feel like I'm chasing my tail on this. When I run my version of IMPLIB, I get the following command line options: = Borland Implib Version 3.0.1 Copyright (c) 1991, 1998 Borland International Syntax: IMPLIB [options]

[sqlite] Sqlite V2.x.x CAPI Reference docs

2004-10-18 Thread John Dean
Hi Can anybody tell where I might find the Sqlite C API Reference Documentation for V2.x.x. This one seems to be missing from the web site --- Regards John Dean, co-author of Rekall, the only alternative to MS Access

RE: [sqlite] sqlite with Borland C++ 5.02

2004-10-18 Thread john mcnicholas
Here is a workaround since the 5.02 version of implib does not have the "-a" option. This procedure worked with the 5.0 version of the tools so I don't think you'll have a problem with 5.02. 1. run impdef on the .dll you want to use. > impdef x.def sqlite3.dll 2. run implib on the def

Re: [sqlite] Sqlite V2.x.x CAPI Reference docs

2004-10-18 Thread D. Richard Hipp
John Dean wrote: Hi Can anybody tell where I might find the Sqlite C API Reference Documentation for V2.x.x. This one seems to be missing from the web site http://www.sqlite.org/c_interface.html -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

RE: [sqlite] sqlite with Borland C++ 5.02

2004-10-18 Thread Pigott, Paul
Maybe this is the last question (hopefully!) I've gotten the .LIB file built, thanks to everyone's help, and I'm now able to compile my C++ code using the .LIB file. Now, I'm having an execution problem. I'm getting the message "The procedure entry point _sqlite3_close could not be located in

RE: [sqlite] sqlite with Borland C++ 5.02

2004-10-18 Thread Marc Pitoniak
I am using Borland C++ Builder Version 6 with no problems. The command-line that I use is: implib -a sqlite3.lib sqlite3.def sqlite3.dll The options are the following: Borland Implib Version 3.0.22 Copyright (c) 1991, 2000 Inprise Corporation Syntax: IMPLIB [options] libname[.lib]

[sqlite] busy handler sometimes not called

2004-10-18 Thread Kevin Schmeichel
I've noticed that sometimes the busy handler doesn't get called by functions that return SQLITE_BUSY. One example is sqlite_finalize. I'm using sqlite 2.8.14. Anyone know if there's any reason for this, or is it just sloppy coding? Kevin ___

Re: [sqlite] busy handler sometimes not called

2004-10-18 Thread Steve Frierdich
Anyone know if the problem Kevin noticed been fixed in sqlite 3.0.7? Steve Kevin Schmeichel wrote: I've noticed that sometimes the busy handler doesn't get called by functions that return SQLITE_BUSY. One example is sqlite_finalize. I'm using sqlite 2.8.14. Anyone know if there's any reason

Re: [sqlite] SQLITE_BUSY returned without busy handler called

2004-10-18 Thread Kevin Schmeichel
What are some examples of circumstances when waiting and retrying a lock won't help? Kevin --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > Kevin Schmeichel wrote: > > By examining the code, it can be seen that there > are > > many places where SQLITE_BUSY is returned (from an > API >

Re: [sqlite] SQLITE_BUSY returned without busy handler called

2004-10-18 Thread b.bum
On Oct 18, 2004, at 12:01 PM, Kevin Schmeichel wrote: What are some examples of circumstances when waiting and retrying a lock won't help? Consider two processes, A and B. Lock state is in [BRACKETS]. (A) does a BEGIN TRANSACTION (B) does a BEGIN TRANSACTION (A) does a SELECT [SHARED] (B) does

[sqlite] Row shuffling

2004-10-18 Thread Jay Macaulay
Hi all, I hate asking SQL specific questions here, but if I could get a response privately it would be great. I have asked a few places and it's tough finding a good answer. What I'm looking for is a way to shuffle IDs in a database via SQL that doesn't require me to select the entire DB out,

Re: [sqlite] busy handler sometimes not called

2004-10-18 Thread Gerry Snyder
Steve Frierdich wrote: Anyone know if the problem Kevin noticed been fixed in sqlite 3.0.7? Steve Kevin Schmeichel wrote: I've noticed that sometimes the busy handler doesn't get called by functions that return SQLITE_BUSY. One example is sqlite_finalize. I'm using sqlite 2.8.14. Anyone know