Re: [sqlite] Profile API: triggered only when sqlite3_step() returns DONE?

the code, the profiling function is called in step(), which I think is strange. >Guillaume >On Thu, May 5, 2011 at 1:52 PM, Marian Cascaval <mariancasca...@yahoo.com>wrote: > Please, read once more the documentation: > > http://www.sqlite.org/cintro.html > > >

Re: [sqlite] Profile API: triggered only when sqlite3_step() returns DONE?

sqlite3_exec() - which triggers callback function. Marian Cascaval From: Guillaume B <guitre...@gmail.com> To: sqlite-users@sqlite.org Sent: Thu, May 5, 2011 11:38:56 AM Subject: [sqlite] Profile API: triggered only when sqlite3_step() returns DONE? Hey guys

Re: [sqlite] date field with default current date

1:35:07 while I am in the data 9:37:30 >Why? What is the difference between your system time and UTC? Marian Cascaval ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GROUP BY Problem

P BY t1.key1 Shouldn't the second JOIN be LEFT JOIN t3 ON t3.key3=t1.key1 ? Marian Cascaval ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] read full txt file in one record

From: Gert Van Assche To: sqlite-users@sqlite.org Sent: Wed, April 6, 2011 12:08:47 AM Subject: [sqlite] read full txt file in one record >Dear all, >what would be the best way to read a full txt file into one record? Until the experts

Re: [sqlite] bug with sqlite

Windows doesn't allow "con" named fodlers or files. Marian Cascaval From: Felix Zimmermann <fea...@yahoo.de> To: sqlite-users@sqlite.org Sent: Mon, March 28, 2011 10:26:59 PM Subject: [sqlite] bug with sqlite hi why isnt it possible to c

Re: [sqlite] sqlite3_close( ) error

ey are both okay, I just >wonder if there is something there I am not seeing. rc is INT as sqlite3_open() returns an INT. SQLITE_OK is defined as 0 in 'sqlite3.h', so both are checked as boolean. Marian Cascaval ___ sqlite-users mailing l

Re: [sqlite] Compiler warnings in R-Tree code under Visual Studio Express

ecific only to Microsoft's IDEs, could you give the simplest code example (with SQLITE_ENABLE_RTREE=1) to compile it and see if we get different results with the warnings? Marian Cascaval From: Afriza N. Arief <afriza...@gmail.com> To: General Discussi

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

ing .. or all. Marian Cascaval From: Tito Ciuro <tci...@mac.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Mon, January 31, 2011 9:38:57 PM Subject: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

Re: [sqlite] LAST() function not supported

Marian Cascaval From: Puneet Kishor <punk.k...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Sat, January 29, 2011 11:12:52 PM Subject: Re: [sqlite] LAST() function not supported On Saturday, January 29, 2011 at 3:

Re: [sqlite] LAST() function not supported

qlite.org> Sent: Sat, January 29, 2011 10:51:30 PM Subject: Re: [sqlite] LAST() function not supported On Sat, Jan 29, 2011 at 12:38:37PM -0800, Marian Cascaval wrote: > Hi! > > Is LAST() function going to be supported? > > Or will the "SELECT ... FROM ... ORDER BY ...

Re: [sqlite] LAST() function not supported

com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Sat, January 29, 2011 10:47:44 PM Subject: Re: [sqlite] LAST() function not supported On Saturday, January 29, 2011 at 2:38 PM, Marian Cascaval wrote: > Hi! > > Is LAST() function

[sqlite] LAST() function not supported

Hi! Is LAST() function going to be supported? Or will the "SELECT ... FROM ... ORDER BY ... DESC LIMIT 1" workaround always be enough? My concern is if there might be any speed improvement if LAST() function were to be implemented, comparing to the workaround. Maria

Re: [sqlite] how to create sqlite3_value structure to be used with sqlite3_bind_value()?

ite3_bind_int(); sqlite3_step(); } sqlite3_exec(... "COMMIT TRANSACTION" ...); Sorry if this is too basic and you already knew it, but I felt like sharing my basic knowledge :P Marian Cascaval From: Igor Tandetnik <itandet...@mvps.org> To: sqli

Re: [sqlite] SQLite version 3.7.5 - code freeze

Here's a first documentation typo: http://www.sqlite.org/draft/c3ref/mprintf.html "_In_ sqlite3_snprintf() routine is similar to "snprintf()" from the standard C library." It should be "_The_ sqlite3_snprintf() routine is similar to

[sqlite] Documentation typos - part no.3

rom within C++ code): 9. http://www.sqlite.org/cintro.html "A complete list of functions that form the SQLite application _program_ interface ..." Who wrote this definitely doesn't like _programming_ ;) Marian Cascaval ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_open_v2 somewhat misses the point

Uhm... so you've figured I'm not an English teacher either. That's why a team is good for: correcting each other's typos :) Marian Cascaval From: Puneet Kishor <punk.k...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.

[sqlite] sqlite3_open_v2 somewhat misses the point

error is returned _, except when first parameter is NULL_." I'm not a programmer, so just bare with me please.. Marian Cascaval ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Documentation typos - part no.2

it_ if it does not already exist." It should be either _is created_ or _creates it_. It's clear the author had these two ideas in mind and amalgamated them ;). I can drop the jokes next time if solemnity is required here. Marian Cascaval __

Re: [sqlite] How SQLite manages result of a SELECT query?

Hi! As far as I understandd, sqlite3_step() does not fetch any data but returns SQLITE_ROW. If this is the case, then use sqlite3_column() to fetch the actual data. Marian Cascaval From: Sunil Bhardwaj <sbhard...@ipolicynetworks.com> To: G

[sqlite] PRAGMA Documentation typo

ew of them. Should I continue reporting this kind of typos or not? Thank you. Marian Cascaval ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users