Re: [sqlite] Selecting from a GROUP Select

I guess you need something like SELECT * from TableA WHERE z in ( SELECT z FROM TableA GROUP BY z HAVING count(*)=2 ); Pavel On Fri, Jun 22, 2012 at 6:43 PM, Peter Haworth wrote: > I have a situation where I need to select entries based on the count of the > number of entries

[sqlite] Selecting from a GROUP Select

I have a situation where I need to select entries based on the count of the number of entries in a GROUP = 2, and also that the value of a specific column must be different for each row in the group. I then need to select all the individual rows from the qualifying groups. Getting the groups with

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

On 22 Jun 2012, at 5:13pm, "Arbol One" wrote: > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools > Since there seems to be a confusion about the application I am using to view > the newly created table and the data entered to it, I asked the question you > are

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Since there seems to be a confusion about the application I am using to view the newly created table and the data entered to it, I asked the question you are referring to in order to establish a common ground, an application to view the

Re: [sqlite] HTML5 database commands as a JavaScript-SQLite bridge

On 22 Jun 2012, at 4:09pm, Etienne wrote: > Have you already had a look at JSDB? > > I know it is not closely related to your post (you speak of JS "client"), but > you can build little web apps very quickly with JSDB "Server" and "SQLite" > objects. > > There is

Re: [sqlite] HTML5 database commands as a JavaScript-SQLite bridge

Hi Simon, Have you already had a look at JSDB? I know it is not closely related to your post (you speak of JS "client"), but you can build little web apps very quickly with JSDB "Server" and "SQLite" objects. There is also an ODBC driver (that I did not test so far) included in this

Re: [sqlite] Something strange

On Fri, Jun 22, 2012 at 10:39 AM, Jeff Archer wrote: > I have seen something that seems strange and wonder if anyone has any > thoughts? > > I have been using SQLite for a long time now and never seen anything > similar. Had been using 3.7.6.1 and have now upgraded to 3.7.13

[sqlite] Something strange

I have seen something that seems strange and wonder if anyone has any thoughts? I have been using SQLite for a long time now and never seen anything similar. Had been using 3.7.6.1 and have now upgraded to 3.7.13 but behavior has not changed. In a Debug build this code works as expected but in

Re: [sqlite] Difference between 3.7.11 and 3.7.13

I am sorry, but it was sent twice for a mistake. -- Marco Bambini http://www.sqlabs.com On Jun 21, 2012, at 2:41 PM, Marco Bambini wrote: > Consider the following example: > > CREATE TABLE t1(x); > CREATE TABLE t2(y); > SELECT max((SELECT avg(x) FROM t2)) FROM t1; > > With sqlite 3.7.11 NULL

Re: [sqlite] SQLite database on the android phone

Ask this on Android-related mailing list. And if you include your populated database into application package before installation and don't see any data after installation check that you open your database with an absolute path otherwise you could be opening some other database file, not the one

[sqlite] SQLite database on the android phone

Dear Sir/Madam, I have developed an android application which have an sqlite database with some data which i had imported from a CVS file and its working well on the emulator virtual machine but when i install the application on the android phone it does not come with the data on the database. my

[sqlite] Difference between 3.7.11 and 3.7.13

Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] Parser bug on sub joins when on right side of the join operator

Hi, According to the documentation (Sqlite + standard Ansi), queries that should be supported like : SELECT * FROM A JOIN (B JOIN C ON B.ID = C.ID) ON A.ID = B.ID are still not supported whereas badly formed queries like : SELECT * FROM A JOIN (B JOIN C ON B.ID =

Re: [sqlite] Does sqlite3_exec work with sqlite3_bind ?

On 22 Jun 2012, at 11:28am, "deltagam...@gmx.net" wrote: > Thx for the quick response. > > So sqlite3_exec can only be used with "static" sql_statements. Yes. _exec() gets fed one or more commands in a long string. Binding works only when you use _prepare(), _step(),

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

>  As I stated in my previous email, I used SQLight Designer to view the > database, which application would you recommend to view my database? This question was asked million times on this list. Please search the archives. Pavel On Fri, Jun 22, 2012 at 4:34 AM, Arbol One

Re: [sqlite] Does sqlite3_exec work with sqlite3_bind ?

Am 22.06.2012 12:01, schrieb Richard Hipp: On Fri, Jun 22, 2012 at 1:03 AM, deltagam...@gmx.net wrote: sqlite3_prepare_v2() >, sqlite3_step()

Re: [sqlite] Does sqlite3_exec work with sqlite3_bind ?

On Fri, Jun 22, 2012 at 1:03 AM, deltagam...@gmx.net wrote: > sqlite3_prepare_v2() > >, > sqlite3_step() > >, > and

Re: [sqlite] C++ programming - int sqlite3_prepare_v2() question

Thanks for the prompt response. As I stated in my previous email, I used SQLight Designer to view the database, which application would you recommend to view my database? Please keep in mind that I am not able to purchase a program, so it needs to be a free trial or a freeware. On the other