Re: [sqlite] SQLite Manager Firefox extension

It is pretty, runs well and is easy to use. Better than "decent". P Kishor wrote: To all those looking for a decent, cross-platform SQLite gui, check out SQLite Manager Firefox add-on https://addons.mozilla.org/en-US/firefox/addon/5817 I have just started experimenting with it, and it reall

Re: [sqlite] commit and rollback

Why not just test the status returned by sqlite3_step? Use sqlite3_prepare_v2 to make the returned status give more information. When you get an error just finalize your COMMIT statement and move your pointer from the prepared COMMIT statement to a ROLLBACK and shortcut the transaction. Inst

Re: [sqlite] commit and rollback

On 11/26/07, arbalest06 <[EMAIL PROTECTED]> wrote: > John Stanton-3 wrote: > > All you need to do is to test the returned status of your sqlite3_step > > calls and if you get an error launch an SQL statement "ROLLBACK" and > > bail out of the transaction. If there are no errors you complete your

Re: [sqlite] commit and rollback

good day! i think its really a good solution to this problem. However, im required to implement the c apis of sqlite..so i need to use the sqlite3_commit_hook and sqlite3_rollback_hook..im doing some prototyping to see their functionalities but i really cant make it work..and i also cant find som

[sqlite] Re: Nonexistant Delimiters?

Argh, I feel like an idiot. I had my SQL syntax wrong because I messed up some delimiters. Now that I have that straightened out, it works fine. I think this will make separating strings a lot easier for me. Andrew On Nov 26, 2007 7:32 PM, Andrew Wiley <[EMAIL PROTECTED]> wrote: > I'm havinga la

[sqlite] Nonexistant Delimiters?

I'm havinga large bit of encoding confusion. I'm programming an app in Java that is using SQLite, and have a text field that will contain a variable number of entries. I of course wanted to separate those entries with delimiters, but I thought I could avoid the hassle of making sure that user input

[sqlite] SQLite Manager Firefox extension

To all those looking for a decent, cross-platform SQLite gui, check out SQLite Manager Firefox add-on https://addons.mozilla.org/en-US/firefox/addon/5817 I have just started experimenting with it, and it really quite nice even at version 0.2.9.1. Works well on my Mac. -- Puneet Kishor ---

Re: [sqlite] sqlite with C++

Am Mon, 26 Nov 2007 08:36:47 -0500 (EST) schrieb Clay Dowling: > > Andreas Volz wrote: > > Am Sun, 25 Nov 2007 12:11:50 +0100 schrieb Andreas Volz: > > > >> Hello, > >> > >> I used this minimal example code to test my sqlite connection. This > >> works without problems. But now I tried to move th

[sqlite] Running SQLite tests

Hi- Is there any documentation on how one would run the SQLite tests? I'm thinking it would be an excellent test for my particular platform port. I'm seeing the test directory in CVS, but not exactly sure what to do with the test files. Thanks, Mark --

RE: [sqlite] SQLite 3.5.2 - Unix - Memory issue?

Ah, yes. My mistake. Thanks. > > The locking style has absolutely nothing to do with > threads. Locking style is what kind of file locks > are used to prevent separate processes from updating > the same database as the same time. SQLite uses > posix advisory locks by default. Not all systems

Re: [sqlite] sqlite with C++

Andreas Volz wrote: > Am Sun, 25 Nov 2007 12:11:50 +0100 schrieb Andreas Volz: > >> Hello, >> >> I used this minimal example code to test my sqlite connection. This >> works without problems. But now I tried to move the 'db' variable into >> the private member section of my 'Cache' class to access

Re: [sqlite] Threading (again)

SQLite is completely threadsafe. So we can share a single database connection across threads, it the underlying OS is Okay. But I guess we can not share a sqlite3_stmt prepared statement across threads threads. Am I correct. Or am I missing something? -- Sabyasachi

Re: [sqlite] sqlite icon

"Cariotoglou Mike" <[EMAIL PROTECTED]> wrote: > DRH : do you mind if I usurp the favicon.ico from the sqlite site, to > use in my application ? > thanks, mike > No. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscrib

[sqlite] sqlite icon

DRH : do you mind if I usurp the favicon.ico from the sqlite site, to use in my application ? thanks, mike - To unsubscribe, send email to [EMAIL PROTECTED]