Re: [sqlite] How to determine if database is currently insideatransaction

> -Original Message- > From: Igor Tandetnik [mailto:itandet...@mvps.org] > Sent: Thursday, February 26, 2009 16:05 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to determine if database is currently > insideatransaction > > "Dennis Volodomanov" >

Re: [sqlite] How to determine if database is currently inside atransaction

"Dennis Volodomanov" wrote in message news:8501919721c3de4c81bca22846b08721899...@lazarus.conceiva.com > Is there any way to determine whether the database is currently > inside a BEGIN...END transaction block? sqlite3_get_autocommit Igor Tandetnik

Re: [sqlite] Transactions and attached databases

Hi Donald, On Feb 25, 2009, at 3:39 PM, Griggs, Donald wrote: > Greetings, Tito, > > Did you see page: >http://www.sqlite.org/lang_attach.html > > > Transactions involving multiple attached databases are atomic, > assuming > that the main database is not ":memory:". > > It then goes on to

[sqlite] How to determine if database is currently inside a transaction

Hello, I couldn't find an answer to my question, but maybe it's really simple... Is there any way to determine whether the database is currently inside a BEGIN...END transaction block? The only way I can think of at the moment is to check whether SQLITE_BUSY is returned, but I'm not sure

Re: [sqlite] meta-question: In what version did feature X first appear?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Machin wrote: > However my point is that many people > are prevented for various reasons for *deploying* that new version into > production, and are constrained to remain on some earlier version of > SQLite. This is only going to be the case

Re: [sqlite] meta-question: In what version did feature X first appear?

On 26/02/2009 11:55 AM, Roger Binns wrote: Hi Roger, > John Machin wrote: >> In >> that situation, the next question to arise would be "What other >> currently-documented features must I avoid?" > > The usual solution is for documentation for each API to include version > information about

Re: [sqlite] manual with sample C programs

> Could you tell me where can I find such documentation, or can you > recommend some books. "The Definitive Guide to SQLite" by Michael Owens explains the SQLite API in detail and provides a number of samples in C. ___ sqlite-users mailing list

Re: [sqlite] meta-question: In what version did feature X first appear?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Machin wrote: > In > that situation, the next question to arise would be "What other > currently-documented features must I avoid?" The usual solution is for documentation for each API to include version information about when it was

[sqlite] manual with sample C programs

Hello users group, I have been looking in the documentation for sample programs in C, but no luck yet. Could you tell me where can I find such documentation, or can you recommend some books. Thanks very much Michael R ___ sqlite-users mailing list

Re: [sqlite] .timer with windows cli

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kim Boulton wrote: > However, how do you get the thing to compile with MinGW? You tried way too hard :-) Use the .tar.gz version of the amalgamation as it includes the shell source code (the .zip doesn't). Then this command works (no need to use

Re: [sqlite] Transactions and attached databases

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tito Ciuro Sent: Wednesday, February 25, 2009 6:36 PM To: sqlite-users@sqlite.org Subject: [sqlite] Transactions and attached databases Hello, If I attach one or more

[sqlite] Transactions and attached databases

Hello, If I attach one or more databases and wrap a series of operations which affect some/all of them, would ROLLBACK or COMMIT treat these operations atomically? For example: Open database 'foo'; Attach database 'bar' as a1; BEGIN TRANSACTION; INSERT INTO main.some_table ... ;

Re: [sqlite] Scrolling cursor with multiple keys...

John Elrick wrote: > I have a situation where I need to retrieve the 'next' item in a table > sorted by an arbitrary number of keys. My current planned solution is to > create a table for the sorting which is recreated as needed with the > appropriate keys. As a simplified example > > create

Re: [sqlite] .timer with windows cli

Roger, Thanks for that. However, how do you get the thing to compile with MinGW? I Installed mingw and msys, fixed a problem with the msys batch file, fixed the paths to mingw so that gcc was found, did a compile and then a make but get linker failures at that point. To get this far I

Re: [sqlite] PRAGMA page_cache=x doesnt seem to have an effect

Try sqlite3_soft_heap_limit() or use memsys3/memsys5 - http://www.sqlite.org/malloc.html Cheers, Dave. -Original Message- From: ed [mailto:epdm...@gmail.com] Sent: 25 February 2009 10:50 To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA page_cache=x doesnt seem to

[sqlite] meta-question: In what version did feature X first appear?

This is becoming a FAQ. E.g. here is a precis of a very recent thread: OP: Error message is : 'SQL error :near "savepoint": syntax error' Dan: Probably you need to upgrade. SAVEPOINT first appeared in 3.6.8. OP: That was the problem; I had 3.6.4 version Yesterday (my time) there was another,

[sqlite] Scrolling cursor with multiple keys...

I have a situation where I need to retrieve the 'next' item in a table sorted by an arbitrary number of keys. My current planned solution is to create a table for the sorting which is recreated as needed with the appropriate keys. As a simplified example create table x ( x_id integer

Re: [sqlite] SAVEPOINT : Seems don't work : SOLVED (version problem)

Very good answer : That was the problem; I had 3.6.4 version : It works with the last version Thank's a lot Dan MaxMax14 -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]de la part de Dan Envoye : mercredi 25 fevrier 2009 05:28 A : General

Re: [sqlite] Displaying Large Tables

Setting aside the fact that it seems silly to try to show people an 8 million row resultset... You could merge the two ideas: create a temp table containing just the rowids you want, in the order that you want, and then use LIMIT and OFFSET to get the particular ones you want. Using those

[sqlite] Displaying Large Tables

I'm working on a simple SQLITE database browser (part of a larger program) and I'm running into problems displaying larger (~8 million rows) tables. I originally set out using OFFSET and LIMIT to grab the rows I need to display on screen at any given time, but realized that this becomes

Re: [sqlite] PRAGMA page_cache=x doesnt seem to have an effect

Does anyone have any experience or examples of reducing sqlite memory usage through the pragma cache_size, page_size satements? I am misunderstanding the intended use of the pragmas? thanks, ed On Fri, Feb 20, 2009 at 5:58 PM, ed wrote: > Hello, > I am using sqlite in an

Re: [sqlite] running sqlite with gcc C

On Wed, 25 Feb 2009 10:04:18 -0500 (EST), Michael (mrobi...@cs.fiu.edu) wrote : >Thank you, it works perfectly >The links at the bottom of your email helped a lot. I'm glad it does work. By the way, the links were really easy to find. In my humble opinion you would benefit from spending more

Re: [sqlite] SQL error: no such function: replace

BenJones12345 wrote: > Ah... its version 3.3.5 > > Unfortunately though I don't have the option of updating it, since I > am using it on a very widespread set of machines which I don't have > root privileges on... > > Is there another way I can achieve the same effect

Re: [sqlite] SQlite3 problem with floating point for arm-linux

On February 25, 2009 10:36:31 am D. Richard Hipp wrote: > You probably need to compile on ARM with the - > DSQLITE_MIXED_ENDIAN_64BIT_FLOAT=1 flag. There is a comment in the > code that explains this flag in more detail. Use "grep" to find it. > Thank you very much, that worked perfectly. Dave

Re: [sqlite] running sqlite with gcc C, continuation.....

Thank you very much it works fine Michael > Hi, > > you have to compile sqlite3.c, using something like > > gcc -c sqlite3.c > > making an object file, and then linking it to your own program. > Your call combines compiler and linker using only your own source file. > > Also, it should not be

Re: [sqlite] running sqlite with gcc C

Thank you, it works perfectly The links at the bottom of your email helped a lot. Michael > On Wed, 25 Feb 2009 09:05:29 -0500 (EST), > mrobi...@cs.fiu.edu wrote in General Discussion of SQLite > Database : > >>Dear sqlite users group, >> >>I am new at SQlite3 and I

Re: [sqlite] UPDATE Field based on matching value in different Table

Igor, I am using a temporary table where that condition will not occur but I do appreciate the info as I was considering re-writing the SQL to see if I could do it without using a temporary table and that would have created the NULL condition you noted. Thanks again for noting the potential

Re: [sqlite] running sqlite with gcc C, continuation.....

Hi, you have to compile sqlite3.c, using something like gcc -c sqlite3.c making an object file, and then linking it to your own program. Your call combines compiler and linker using only your own source file. Also, it should not be necessary to define sqlite3_open and sqlite3_close (or any

[sqlite] running sqlite with gcc C, continuation.....

Sorry, Maybe I should have included the following details: This is the program: #include #include #include int sqlite3_open( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); int sqlite3_close(sqlite3 *); int main() {

Re: [sqlite] running sqlite with gcc C

Hello Michael, download the source code, compile it with your compiler and link it to your program. See http://www.sqlite.org/download.html. Its easiest to use the amalgamation: sqlite-amalgamation-3_6_11.zip There is indeed no

Re: [sqlite] running sqlite with gcc C

On Wed, 25 Feb 2009 09:05:29 -0500 (EST), mrobi...@cs.fiu.edu wrote in General Discussion of SQLite Database : >Dear sqlite users group, > >I am new at SQlite3 and I would be very thankful for your help. > >I read that SQlite does not require installation, so I downloaded

Re: [sqlite] SQlite3 problem with floating point for arm-linux

On Feb 25, 2009, at 9:23 AM, Dave Flogeras wrote: > Hi list, > > I am attempting to use sqlite-3.6.11 for a project using an embedded > board > with a PXA255 processor. The data will then be transferred to a > regular x86 > desktop to be analyzed. > > I have compiled sqlite for both

[sqlite] SQlite3 problem with floating point for arm-linux

Hi list, I am attempting to use sqlite-3.6.11 for a project using an embedded board with a PXA255 processor. The data will then be transferred to a regular x86 desktop to be analyzed. I have compiled sqlite for both embedded/desktop platforms using the amalgamated sources.  I do nothing

[sqlite] running sqlite with gcc C

Dear sqlite users group, I am new at SQlite3 and I would be very thankful for your help. I read that SQlite does not require installation, so I downloaded the Precompiled Binaries For Windows and run sqlite3.exe in windows xp, no problem, however, I have some gcc C programs that I run in windows

Re: [sqlite] How to size and position a scrollbar within a virtual listview

I thought Puneet's reply was good. When you make statements like query the internal btree table to request at least the internal pagenr w... I think you are asking too much of sqlite, right? The purpose of a database engine is to abstract the gory details and make your life easier, just as

Re: [sqlite] SQLite vs. Oracle (parallelized)

I must trade my works for currency. "Will Code for FOOD" : - ) I consult and architect systems professionally and really can't afford to do much free work. As much as I love to develop solutions, we are not in the Star Trek age of we just live to better others and ourselves! If we were you

Re: [sqlite] .timer with windows cli

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kim Boulton wrote: > Anywhere I can download one would be nice. You can get the free MinGW compiler from http://www.mingw.org - it is what I use to compile SQLite and other code on Windows. MinGW is a Windows port of gcc plus other GNU tools. Roger

Re: [sqlite] How to size and position a scrollbar within a virtual listview

Puneet, Thank you for your help. Yes your solution would work. Due to the fact that i have many (up to 10) keys within a huge table, I would have to recreate the temp table with a additional key for every index or 'order by' clause I would ever use. This must happen every day or at least

[sqlite] .timer with windows cli

Hello, Is there a compiled v3.6.11 sqlite3.exe with the .timer facility enabled. I don't have a C compiler on this machine. Anywhere I can download one would be nice. Thanks kim ___ sqlite-users mailing list sqlite-users@sqlite.org