Re: [sqlite] Query executes in sqlite manager but not sqlite database in android

It seems Android use a pretty outdated SQlite motor : SQlite 3.7.1 = march 20th, 2012 http://stackoverflow.com/questions/2421189/version-of-sqlite-used-in-android SQLite 3.7.11: 19-4.4-KitKat 18-4.3-Jelly Bean 17-4.2-Jelly Bean 16-4.1-Jelly Bean SQLite 3.7.4: 15-4.0.3-Ice

Re: [sqlite] Query executes in sqlite manager but not sqlite database in android

Hi Kamulegs, Your SQLiteManager includes a version of SQLite >=3.7.16 , and your android application does not. Indeed the syntax " (b JOIN c ON b.id = c.id)" is only accepted without this errror after 3.7.16. ==> If you can rewrite your syntax without these parenthesis (like below), all should

Re: [sqlite] Getting Error at line 16265 (v3.8.2)

On 24 Jan 2014, at 5:09pm, Hiew William wrote: > I’m getting error from sqlite3.c when i’m trying to run my application in > development…… Which error ? In other words, what's the error message ? And what API function is your application trying to execute when you get

Re: [sqlite] export table to csv

On 24 Jan 2014, at 6:24am, Frantisek Cerven wrote: > I want to ask you if is any way to call sqlite special commands > programatically from c#. These 'special commands' are not in SQLite at all. They are features of the command-line shell application. SQLite does not

[sqlite] Query executes in sqlite manager but not sqlite database in android

Hello Community Hope to get some pointers here because i have a hit a snag! I have 4 tables. Meters:_id, SerialNumber Tenants: _id, FirstName. TenantsMeters: _id,Tenant_id,Meter_id, (basically junction table for linking many to many relationship btn tenants and meters) MeterReading: _id,

Re: [sqlite] SELECTing from another SELECT

Igor Tandetnik wrote... On 1/23/2014 2:26 PM, St. B. wrote: SELECT * FROM A WHERE projid in (SELECT projid FROM B WHERE ptask = 'a'); will probably fill the bill. If I where to run your query, I would do a select A.* from A inner join B on A.a = b.ProjId where b.ptask='a' Careful - this

Re: [sqlite] SELECTing from another SELECT

"Igor Tandetnik" wrote on Friday, January 24, 2014 9:48 AM... On 1/24/2014 9:28 AM, jose isaias cabrera wrote: Igor Tandetnik wrote... On 1/23/2014 2:26 PM, St. B. wrote: SELECT * FROM A WHERE projid in (SELECT projid FROM B WHERE ptask = 'a'); will probably fill the bill. If I where to

[sqlite] Getting Error at line 16265 (v3.8.2)

Help, not sure if this is the right place to post, I’m getting error from sqlite3.c when i’m trying to run my application in development…… I’m developing using vs 2012 for Windows Store App, running for winrt and desktop. Installed “SQLite for Windows Runtime and SQLite-net 1.0.7 nugget

Re: [sqlite] SELECTing from another SELECT

St. B. wrote... SELECT * FROM A WHERE projid in (SELECT projid FROM B WHERE ptask = 'a'); will probably fill the bill. If I where to run your query, I would do a select A.* from A inner join B on A.a = b.ProjId where b.ptask='a' the join may optimize better than the in (select ...)

Re: [sqlite] csv export

can I run sql shell also on windows CE and windows Mobile? could you please give me little example how to create virual table to file export it and to pc? I can find it. Can I also delete it from file explorer without problems? Many thanks. On Fri, Jan 24, 2014 at 9:10 AM, Hick Gunter

[sqlite] export table to csv

Hello, I want to ask you if is any way to call sqlite special commands programatically from c#. E.g. I need something like this in code not in command line: sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; sqlite> .output stdout If not, what is the quicker way to export

Re: [sqlite] "Common Table Expression"

>remark 2: >- >I'm using Keith buildMSVC.cmd file to compile (that I'm using without >knowing what it does exactly) > >I have one more compile error than with 21th version. >"c1 : fatal error C1083: Impossible d'ouvrir le fichier source : >'CSVImport.c' " > >==> Maybe it's normal. Yes.

Re: [sqlite] "Common Table Expression"

On Jan 25, 2014, at 6:05 AM, Keith Medcalf wrote: > Read the docs. It explains how recursive CTEs are computed and how UNION ALL > vs UNION work in CTEs. Hmmm… perhaps… doing is believing… so will experiment once the next SQLite release is officially out.

Re: [sqlite] "Common Table Expression"

On Jan 25, 2014, at 2:37 AM, James K. Lowden wrote: > Funny, we find ourselves on the opposite side of the compexity question > this time. Ehehehe… yes… the irony is duly noted :) But, ok, then, let welcome our new VALUES overlord. May it have a long and prosperous

Re: [sqlite] "Common Table Expression"

On 25/01/14 18:41, James K. Lowden wrote: On Sat, 25 Jan 2014 11:56:32 +0200 Elefterios Stamatogiannakis wrote: Wouldn't it be better instead of creating a new concept "row constructor", to use the existing row constructors, also known as virtual tables? Perhaps. I didn't

Re: [sqlite] "Common Table Expression"

On Sat, 25 Jan 2014 11:56:32 +0200 Elefterios Stamatogiannakis wrote: > Wouldn't it be better instead of creating a new concept "row > constructor", to use the existing row constructors, also known as > virtual tables? Perhaps. I didn't make up the term; it exists in

Re: [sqlite] "Common Table Expression"

On 25/01/14 03:37, James K. Lowden wrote: On Fri, 24 Jan 2014 23:51:11 +0100 Petite Abeille wrote: It's exactly the same as "SELECT ?", but a little bit easier to write. (It behaves like with INSERT, but is now available in every place where a SELECT would be

Re: [sqlite] "Common Table Expression"

hi again, With the version sqlite-amalgamation-201401242258 of this night. I found my error so timings are : timing with medium sudoku example : '17.9..3..2...8..96..553..9...1..8...264...3..1..4..7..7...3..' 2 nested with = 3.06 sec (3.32 sec previous beta of 21rst) 8%