Re: [sqlite] Open source projects using sqlite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/01/12 21:46, Matt Young wrote: > Group projects, collected together because sqlite is the common > foundation. Would be nice? You'll need to use longer sentences. What exactly do you want to achieve and who do you want to do the work of

Re: [sqlite] sqlite3_bind. error as library routine called out of sequence.

Hi Mr Black, I am very thankful to you. My code is working fine. Regards, Bhaskar Reddy. Black, Michael (IS) wrote: > > You have to do all the binds together, THEN step. This works for me. > > > > #include > #include > #include > #include "sqlite3.h" > > int main() > { >

[sqlite] Open source projects using sqlite

Group projects, collected together because sqlite is the common foundation. Would be nice? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some pieces of the puzzle are coming together

On Tue, Jan 17, 2012 at 5:05 AM, John Elrick wrote: > > > I can try that approach with BCC. I was concerned that the IDE would be > getting inaccurate information from the .OBJ. Crossing into a pre-complied > library can be tricky. > > As I recall,I could not make

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 5:31 PM, Richard Hipp wrote: > On Mon, Jan 16, 2012 at 5:13 PM, John Elrick >wrote: > > > I did this trace through the Delphi IDE and hand copied the call stack. > > Unfortunately, I can't give you line numbers, although I

Re: [sqlite] Some pieces of the puzzle are coming together

I will adjust the realloc tests tomorrow and let you know. The two routines are unique in the Delphi library unit. Thanks again for your time and efforts. On Mon, Jan 16, 2012 at 5:36 PM, Richard Hipp wrote: > On Mon, Jan 16, 2012 at 5:31 PM, John Elrick

Re: [sqlite] sqlite3_db_release_memory(): Return value undocumented.

On 16 Jan 2012, at 11:05pm, Ralf Junker wrote: > Reading the sources, sqlite3_db_release_memory() always returns > SQLITE_OK. Will it stay this way or will it some day return another > value like the amount of memory released? It will stay like that. Almost all the sqlite3 routines return a

Re: [sqlite] Incompatible versions of SQLite on same system

At 01:08 17/01/2012, you wrote: ´¯¯¯ Richard, Simon, and you are seeing eye-to-eye on this. Earlier in the thread (since trimmed, of course), it was stated that SQLite was designed to be tiny so that each app could include the entire system without draining resources significantly (this would

Re: [sqlite] Incompatible versions of SQLite on same system

> The search path stuff is a mess under Microsoft. Yes, it sure is. The link you sent has some interesting stuff. In particular, this point is key: Before the system searches for a DLL, it checks the following: (1) If a DLL with the same module name is already loaded in memory, the system

[sqlite] sqlite3_db_release_memory(): Return value undocumented.

Reading the sources, sqlite3_db_release_memory() always returns SQLITE_OK. Will it stay this way or will it some day return another value like the amount of memory released? Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 5:31 PM, John Elrick wrote: > > I don't know if the calls to _realloc will help also, but I've added > tracing for those also. My updated output: > Cumulative _mallocs by size > <= 1kb: 1,118,058,528 bytes

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 5:13 PM, John Elrick wrote: > I did this trace through the Delphi IDE and hand copied the call stack. > Unfortunately, I can't give you line numbers, although I could go back and > give you hex offsets from the start of the procedures. These are

Re: [sqlite] Some pieces of the puzzle are coming together

Richard, I don't know if the calls to _realloc will help also, but I've added tracing for those also. My updated output: Application: Surveyor.exe Sqlite version: 3.7.9 Date/Time:01/16/2012 17:20:58 Memory Used:

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 5:14 PM, Simon Slavin wrote: > > On 16 Jan 2012, at 9:37pm, John Elrick wrote: > > > Lacking the status interfaces for 3.6.17 I was forced to mark them as > > "interface not supported". Simon suggested I track the calls to _malloc, > > so I've added

Re: [sqlite] Some pieces of the puzzle are coming together

On 16 Jan 2012, at 9:37pm, John Elrick wrote: > Lacking the status interfaces for 3.6.17 I was forced to mark them as > "interface not supported". Simon suggested I track the calls to _malloc, > so I've added extensive tracing code. Those results are excellently detailed and make no sense to

Re: [sqlite] Some pieces of the puzzle are coming together

I did this trace through the Delphi IDE and hand copied the call stack. Unfortunately, I can't give you line numbers, although I could go back and give you hex offsets from the start of the procedures. These are literally the first seven call stacks from _malloc after I initiate the trace. I'm

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 4:37 PM, John Elrick wrote: > Sqlite version: 3.6.17 > Cumulative _mallocs by size > <= 1kb: 109,025,904 bytes (565,230 count) > 1kb to 4kb: 510,357,112 bytes (485,801

[sqlite] sqlite3_uri_int64() doc error

The sqlite3_uri_int64() doc reads: "If the value of P is something other than an integer, then zero is returned." I found this to be not true. Instead, it returned default. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Some pieces of the puzzle are coming together

Addendum: This test was conducted using a full size test dataset. I had been using one that was an order of magnitude smaller for profiling before, but could use the full size for this test. On Mon, Jan 16, 2012 at 4:37 PM, John Elrick wrote: > Lacking the status

Re: [sqlite] Some pieces of the puzzle are coming together

Lacking the status interfaces for 3.6.17 I was forced to mark them as "interface not supported". Simon suggested I track the calls to _malloc, so I've added extensive tracing code. Here is the final output from the two versions: Application: Surveyor.exe Sqlite version:

Re: [sqlite] Incompatible versions of SQLite on same system

You don't need to "register" the SQLite DLL. That's for ActiveX and COM DLLs. Not ones that just export functions. The search path stuff is a mess under Microsoft. http://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx#standard_search_order_for_desktop_applications

Re: [sqlite] sql/tcl script

On 16 Jan 2012, at 8:11pm, Bill McCormick wrote: > I was sort of hoping it might be narrowed down to one of the documents on > this page: > > http://www.sqlite.org/docs.html > > Typing "script" and "command line" in the search box didn't help me find what > I was looking for either. Ah, I

Re: [sqlite] sql/tcl script

On Mon, Jan 16, 2012 at 9:21 PM, Tim Streater wrote: > I'm using the PDO interface from PHP for SQLite3 with no problems. What > are you referring to? > Sorry for the confusion - i meant that those are languages which _do_ have sqlite3 bindings (but my wording implied the

Re: [sqlite] sql/tcl script

On 16 Jan 2012 at 18:15, Stephan Beal wrote: > On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick wrote: > >> Is tcl the only scripting interface for SQLite? I'm just wondering what >> the options are. > There are few scripting languages which don't

Re: [sqlite] sql/tcl script

Simon Slavin wrote, On 1/16/2012 1:45 PM: On 16 Jan 2012, at 7:34pm, Bill McCormick wrote: Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3). Also, can I safely delete the database file (yourdb.db3, using your example) if I just want to start again? It appears that I can.

Re: [sqlite] Incompatible versions of SQLite on same system

Ah, I see that embedded images don't make it in this group, so the screen shot referred to in my previous message is attached. Regards, Joe Original Message Subject: Re: [sqlite] Incompatible versions of SQLite on same system From: Joe Winograd To: General

Re: [sqlite] sql/tcl script

Am 16.01.2012 20:34, schrieb Bill McCormick: Oliver Peters wrote, On 1/16/2012 1:02 PM: Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object

Re: [sqlite] sql/tcl script

On 16 Jan 2012, at 7:34pm, Bill McCormick wrote: > Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3). > > Also, can I safely delete the database file (yourdb.db3, using your example) > if I just want to start again? It appears that I can. Not while an app has it open, but if

Re: [sqlite] 3.7.9 Import problem - a test case

On Mon, Jan 16, 2012 at 2:28 PM, Udi Karni wrote: > > (2) I am new to share-ware. I don't compile my own code. How long between > "checked in" and "included in the shell-for-windows on the download page" ? > > Since SQLite 3.7.10 was released earlier this morning, you hit the

Re: [sqlite] Incompatible versions of SQLite on same system

Thanks for the response, Michael. This is a 64-bit W7 machine. The two supposedly conflicting programs are: c:\Program Files (x86)\TurboTax\Home & Business 2010\32bit\TurboTax.exe c:\Program Files (x86)\Hewlett-Packard\HP Connection Manager\HPConnectionManager.exe TurboTax does not have a

Re: [sqlite] sql/tcl script

Oliver Peters wrote, On 1/16/2012 1:02 PM: Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that

Re: [sqlite] 3.7.9 Import problem - a test case

Thanks Dr. Hipp ! (1) Wow - what fast turnaround in the share-ware world !!! (2) I am new to share-ware. I don't compile my own code. How long between "checked in" and "included in the shell-for-windows on the download page" ? On Mon, Jan 16, 2012 at 8:57 AM, Richard Hipp

Re: [sqlite] sql/tcl script

On Mon, Jan 16, 2012 at 8:02 PM, Bill McCormick wrote: > I assume that you are *NOT* naming the few that don't, rather these > scripting languages *DO* have sqlite3 binding support. Yes, sorry - a bad choice of wording on my part. :/ -- - stephan beal

Re: [sqlite] sql/tcl script

Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read

Re: [sqlite] sql/tcl script

Stephan Beal wrote, On 1/16/2012 12:15 PM: On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormickwrote: Is tcl the only scripting interface for SQLite? I'm just wondering what the options are. There are few scripting languages which don't have an sqlite3 binding. Just to

Re: [sqlite] sql/tcl script

On 16 Jan 2012, at 6:59pm, Bill McCormick wrote: > James Pearson wrote, On 1/16/2012 12:28 PM: >> If it's just for setting up databases, tables, etc, why not just use a sql >> script? >> >> Throw all your database object creation sql into a file and then execute >> that file from within

Re: [sqlite] sql/tcl script

James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read FILE" command. I think this is what I'm

Re: [sqlite] [sqlite-announce] SQLite version 3.7.10

On 16 Jan 2012, at 4:34pm, James Pearson wrote: > I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled > binaries for Mac OS X and find that the up arrow command recall isn't working. Works fine for me, downloading the shell from the 'Downloads' page and running it under

Re: [sqlite] sql/tcl script

If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read FILE" command. On 16 Jan 2012, at 11:23, John Elrick wrote: Ruby also. On Mon, Jan

Re: [sqlite] sql/tcl script

Ruby also. On Mon, Jan 16, 2012 at 1:15 PM, Stephan Beal wrote: > On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick >wrote: > > > Is tcl the only scripting interface for SQLite? I'm just wondering what > > the options are. > > > > > There are few

Re: [sqlite] sql/tcl script

On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick wrote: > Is tcl the only scripting interface for SQLite? I'm just wondering what > the options are. > There are few scripting languages which don't have an sqlite3 binding. Just to name a few: - Perl - PHP - JavaScript (v8

[sqlite] sql/tcl script

Is tcl the only scripting interface for SQLite? I'm just wondering what the options are. I'm trying to write a script to setup my database on new systems (create the db, add tables, etc.), but I don't have much experience using Tcl. My fist attempt is not going so well and I'm not finding

Re: [sqlite] [sqlite-announce] SQLite version 3.7.10

On 16 Jan 2012, at 10:53, Richard Hipp wrote: We have now uploaded a new prebuilt command-line shell binary for Mac that has the command-line editing built in. Please download the new one and try again. On Mon, Jan 16, 2012 at 12:47 PM, James Pearson wrote: On 16 Jan

Re: [sqlite] [sqlite-announce] SQLite version 3.7.10

Read here on Mac OS X http://sqlite.org/cvstrac/wiki?p=ReadLine Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org

Re: [sqlite] [sqlite-announce] SQLite version 3.7.10

We have now uploaded a new prebuilt command-line shell binary for Mac that has the command-line editing built in. Please download the new one and try again. On Mon, Jan 16, 2012 at 12:47 PM, James Pearson wrote: > On 16 Jan 2012, at 10:12, Richard Hipp wrote: > > On Mon,

Re: [sqlite] [sqlite-announce] SQLite version 3.7.10

On 16 Jan 2012, at 10:12, Richard Hipp wrote: On Mon, Jan 16, 2012 at 11:34 AM, James Pearson wrote: I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled binaries for Mac OS X and find that the up arrow command recall isn't working. Searching for

Re: [sqlite] Some pieces of the puzzle are coming together

On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote: > On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote: > > > > > 3.6.17 > > > > Procedure % TimeTimeCalls > > _sqlite3_step 58.4% 1.795,052 > >

Re: [sqlite] 3.7.9 Import problem - a test case

Am 16.01.2012 17:57, schrieb Richard Hipp: Changes to the command-line shell so that it understands quoted fields have now been checked in. thanks - what about a possibility to recognize special characters (i.e. \NULL) or delimiter""delimiter or delimiterdelimiter as NULL during the import?

Re: [sqlite] Fwd: [sqlite-announce] SQLite version 3.7.10

On Mon, Jan 16, 2012 at 11:34 AM, James Pearson wrote: > I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled > binaries for Mac OS X and find that the up arrow command recall isn't > working. > > Searching for fixes online I can only find suggestions for

Re: [sqlite] makefile for c

On 01/16/2012 04:17 AM, Bill McCormick wrote: Tim Streater wrote, On 1/15/2012 3:00 PM: On 15 Jan 2012 at 20:44, Bill McCormick wrote: What is the problem with the shared lib stuff? Thanks!! Black, Michael (IS) wrote, On 1/15/2012 2:27 PM: A simple one -- and please

Re: [sqlite] 3.7.9 Import problem - a test case

On 16 Jan 2012, at 4:49pm, Udi Karni wrote: > Hm so there is no way to specify (borrowing syntax from other DBs) > something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ? To import fields which contain commas use a delimiter other than a comma to separate your fields and preceed your

Re: [sqlite] 3.7.9 Import problem - a test case

Changes to the command-line shell so that it understands quoted fields have now been checked in. On Mon, Jan 16, 2012 at 11:49 AM, Udi Karni wrote: > Oliver - thanks ! > > Hm so there is no way to specify (borrowing syntax from other DBs) > something like - "DELIMITED

[sqlite] Fwd: [sqlite-announce] SQLite version 3.7.10

I just updated my sqlite install from 3.7.5 with the 3.7.10 precompiled binaries for Mac OS X and find that the up arrow command recall isn't working. Searching for fixes online I can only find suggestions for correcting the issue by compiling sqlite myself. Is that the only way to get

Re: [sqlite] 3.7.9 Import problem - a test case

Am 16.01.2012 17:49, schrieb Udi Karni: Oliver - thanks ! Hm so there is no way to specify (borrowing syntax from other DBs) something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ? yes, no way :-) if you want to discover the possibilities of the CLI type .h (after having started with

Re: [sqlite] 3.7.9 Import problem - a test case

Oliver - thanks ! Hm so there is no way to specify (borrowing syntax from other DBs) something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ? On Mon, Jan 16, 2012 at 8:32 AM, Oliver Peters wrote: > Am 16.01.2012 17:10, schrieb Udi Karni: > > Simon - thanks - but this

Re: [sqlite] 3.7.9 Import problem - a test case

Am 16.01.2012 17:10, schrieb Udi Karni: Simon - thanks - but this used to work on 3.7.7.1 (I believe was the last version I downloaded and unfortunately replaced with the latest...) afaik this never worked with the original CLI (might be that you have used a fork that can do this) I see 3

Re: [sqlite] 3.7.9 Import problem - a test case

Simon - thanks - but this used to work on 3.7.7.1 (I believe was the last version I downloaded and unfortunately replaced with the latest...) How, then, do you import character columns that contain commas (like addresses) from a .csv which uses commas as a delimiter? Thanks ! On Mon, Jan 16,

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 10:33 AM, Richard Hipp wrote: > On Mon, Jan 16, 2012 at 10:29 AM, John Elrick >wrote: > > > > > > > > SQLite has lots of interfaces that can be used to determine performance > > and > > > status information. Some example code

Re: [sqlite] 3.7.9 Import problem - a test case

On 16 Jan 2012, at 3:34pm, Udi Karni wrote: > "COL1","COL2" > "","" > "XX,X","" Sorry, but the shell tool doesn't understand quotes in csv files. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] 3.7.9 Import problem - a test case

C:\>type k:\data\test.csv "COL1","COL2" "","" "XX,X","" C:\>sqlite3 k:\db\testdb SQLite version 3.7.9 2011-11-01 00:52:41 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .separator ',' sqlite> sqlite> CREATE TABLE TEST (COL1 CHAR (4), COL2 CHAR

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 10:29 AM, John Elrick wrote: > > > > SQLite has lots of interfaces that can be used to determine performance > and > > status information. Some example code from the command-line shell that > > accesses this status information is here: > >

Re: [sqlite] Some pieces of the puzzle are coming together

On Fri, Jan 13, 2012 at 5:58 PM, Richard Hipp wrote: > On Fri, Jan 13, 2012 at 4:49 PM, John Elrick >wrote: > SNIP > SQLite has lots of interfaces that can be used to determine performance and > status information. Some example code from the

Re: [sqlite] savepoint

2012/1/16 Csaba Jeney > Is there any way to query the valid savepoints? At least their names? > Many thanks. > > AFAIK, the only way to do this is to keep track of each begin, rollback, add savepoint, ... executed, to always know where you are. (Anyway this is what's done in

Re: [sqlite] makefile for c

If you insist on using the shared library instead of compiling in as we all recommend you don't need to worry about the different file extensions on the shared libraries. There are no options when linking the shared libary. CFLAGS=-O OBJECTS=myapp.o LIBS=-lsqlite3 -lpthread -ldl myapp:

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 5:37 PM, John Elrick wrote: > > is this test ok for you (still showing bad performance)? > > > > On my side it's about 800 ms for 3.7.9 static and about 6000 memory calls > > during the query. For 3.6.20 the number of calls ~ 7000, the time is >

Re: [sqlite] sqlite3_bind. error as library routine called out of sequence.

You have to do all the binds together, THEN step. This works for me. #include #include #include #include "sqlite3.h" int main() { sqlite3 *db; sqlite3_stmt *stmt; int status; char *create = "create table ONTTable(slotId,ponChannelId,onuType,onuId,adminStatus);"; char

[sqlite] sqlite3_bind. error as library routine called out of sequence.

Hi Friends, When i tried, query = "insert into ONTTable (slotId,ponChannelId,onuType,onuId,adminStatus) values (?1,?2,?3,?4,?5);"; then binding each parameter. //sqlite3_prepare_v2(db,query,strlen(query)+1, , NULL); sqlite3_bind_int(stmt,1,ontTable -> slotId);

Re: [sqlite] Some pieces of the puzzle are coming together

On Mon, Jan 16, 2012 at 4:37 AM, Max Vlasov wrote: > On Sun, Jan 15, 2012 at 3:35 AM, John Elrick >wrote: > > > On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov > wrote: > > > > 5,008 calls to > > > > UPDATE RESPONSES SET > >

Re: [sqlite] All values of a fields are not stored in the single record.

Hi Mr. Black, I tried what you recommend me. But i am getting error as, sqilte3_bind_int(stmt,2,ontTable -> ponChannelId) failed with status 21: library routine called out of sequence. Regards, Bhaskar Reddy. Black, Michael (IS) wrote: > > You did 5 inserts and got 5

Re: [sqlite] All values of a fields are not stored in the single record.

You did 5 inserts and got 5 records. You need to do either just ONE insert or ONE insert and FOUR updates. I'd got for the one insert. query = "insert into ONTTable (slotId,ponChannelId,onuType,onuId,adminStatus) values (?1,?2,?3,?4,?5);"; then bind each parameter. Michael D. Black

[sqlite] All values of a fields are not stored in the single record.

Hi friends, While i am writing data into the table the values are not storing in a single records, instead the values are storing in improper order. I am adding the values to the table as, query = "insert into ONTTable (slotId) values (?1);";

[sqlite] Need help with adding Update Callback for node-sqlite

I am not sure if this is the correct mailing list to ask this question. If not, please redirect me to the correct forum. I am using Node js with node-sqlite extension. I tried to use the commented out caode in node-sqlite to add an update callback. On running the code I am getting a

Re: [sqlite] SSD with TRIM

For this particular test cache_size didn't matter much...actually ran a touch faster with smaller cache (although may be within the margin of error) I dropped the cache_size to 125 pages (which matches the 16X increase in page size that I did) On SSD: time sqlite3 gen.db int main () {

Re: [sqlite] SSD with TRIM

Yes...Linuxforgot to mention that. Also Intel E5405 @ 2.00Ghz -- 8 processors and 32G mem in an HP Blade on local storage. System was pretty well I/O bound. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman

Re: [sqlite] SSD with TRIM

Yup...I'm sure... Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Peter

Re: [sqlite] SSD with TRIM

On 16 Jan 2012, at 7:18am, Max Vlasov wrote: > Michael, thanks for the info, your tests confirms some advantages of ssd, > at least on some of the current platform (linux, can you confirm?). > Probably the page size is a parameter that also should be adjusted for > optimal performance. I suppose

Re: [sqlite] Some pieces of the puzzle are coming together

On Sun, Jan 15, 2012 at 3:35 AM, John Elrick wrote: > On Fri, Jan 13, 2012 at 5:13 PM, Max Vlasov wrote: > > 5,008 calls to > > UPDATE RESPONSES SET > RESPONSE_NAME = :RESPONSE_NAME, > prelisted_value = :prelisted_value > WHERE RESPONSE_OID =

Re: [sqlite] savepoint

On 01/16/2012 03:31 PM, Csaba Jeney wrote: Is there any way to query the valid savepoints? At least their names? No way to do that at present. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] savepoint

Is there any way to query the valid savepoints? At least their names? Many thanks. Csaba This message is intended to be confidential and may be privileged. If you are not the intended recipient, please delete this e-mail from your system immediately and notify us of the erroneous transmission