Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP

On Wed, Aug 24, 2005 at 04:19:09PM -0400, D. Richard Hipp wrote: > On Wed, 2005-08-24 at 10:08 -1000, Glen Nakamura wrote: > > The problem could be the following lines in Makefile.in: > > > > # In LIBOBJ but not TESTSRC > > COMMONOBJ = $(foreach obj,$(LIBOBJ),\ > > $(if $(findstring

Re: [sqlite] C++ API: Retrieve multiple rows into struct, using callback

It's not too hard. Instantiante a static class method that matches the sqlite callback signature. When you register the callback with sqlite, you'll want to pass in the this pointer to the instantiated class. Within the static class method, cast the void pointer back to the instantiated

Re: [sqlite] Linking to SQLite with Cygwin / CMake [SOLVED]

Reid, Thanks for the help! 1) I didn't realize the catch that the .lib directory was a hidden folder 2) I wasn't using the --enable-debug and --disable-tcl flags 3) CMake is not generating a valid Makefile that links correctly =(

Re: [sqlite] checking the database status

- Original Message - From: "Dennis Jenkins" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 1:48 PM Subject: Re: [sqlite] checking the database status Robert Simpson wrote: What I say below is in no means trying to be rude or show you (or anyone) up.

Re: [sqlite] checking the database status

Robert Simpson wrote: What I say below is in no means trying to be rude or show you (or anyone) up. I have no idea what your experiences are with Windows or Unix or Unix-Like operating systems. I'm probably stating things that almost all of us already know. :) So? If you open the file,

Re: [sqlite] checking the database status

- Original Message - From: "Dennis Jenkins" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 1:12 PM Subject: Re: [sqlite] checking the database status Robert Simpson wrote: sqlite3_open() doesn't create/open a file for exclusive access off the bat.

Re: [sqlite] checking the database status

Robert Simpson wrote: sqlite3_open() doesn't create/open a file for exclusive access off the bat. If you want to atomically open a file that already exists, open it yourself and while its open, call sqlite3_open(), then close your own handle to it. If you want to atomically create a file

Re: [sqlite] C++ API: Retrieve multiple rows into struct, using callback

On 8/26/05, Cam Crews <[EMAIL PROTECTED]> wrote: > Hi. I'm new to sqlite and would like to use the sqlite C++ API to > return multiple rows from a SELECT statement. I'm able to load a > single row's result into a struct & pass it back by reference through > the callback, but haven't been able to

Re: [sqlite] checking the database status

Robert Simpson wrote: um ... It's a file. You just check to see if the file exists. No sqlite calls involved. Robert That would work in this situation, but what about the inverse? You only want to open the file IF it already exists. There is a race condition: where you check for the

[sqlite] checking the database status

hello, i am working on sqlite 2.8.16 and my requirement is when i use the sqlite_open function i want to display error message if the database is not present.I don't want a new database with the wrong name to be created each time i use the sqlite_open function. I checked for the error parameter

Re: [sqlite] checking the database status

um ... It's a file. You just check to see if the file exists. No sqlite calls involved. Robert - Original Message - From: "YOGESH" <[EMAIL PROTECTED]> To: Sent: Friday, August 26, 2005 12:50 PM Subject: [sqlite] checking the database status hello, i am

[sqlite] C++ API: Retrieve multiple rows into struct, using callback

Hi. I'm new to sqlite and would like to use the sqlite C++ API to return multiple rows from a SELECT statement. I'm able to load a single row's result into a struct & pass it back by reference through the callback, but haven't been able to find any resources recommending a method for returning

RE: [sqlite] Linking to SQLite with Cygwin / CMake

Kiel W. wrote: > Ok, I'm definately thinking this is just a problem with my > understanding of the build process in *nix's and the quirks of Cygwin. > > I am getting the following warning with the default Makefile that is > generated. "libtool: link: warning: undefined symbols not allowed in >

RE: [sqlite] Encryption and fixed header values (was Re: [sqlite] Why can i open a textfile?)

Regarding Mrs. Brisby's ending comment: "A better defense: use a different key each time. Encrypt the session key separately." I may way off in asking this, but: Since we're talking about the encyption of data at rest, and aren't in a client-server situation, how could sqlite make session

Re: [sqlite] Encryption and fixed header values (was Re: [sqlite]Why can i open a textfile?)

> > The usual defense against this attack is to mix some random information > into the beginning of the plaintext. > > A better defense: use a different key each time. Encrypt the session key > separately. > And /or start encrypting after the fixed header. Best regards, Frank.