Re: [sqlite] Order of rows in a VALUES select expression

I am not in front of a sqlite equipped system at the moment, but wouldn't something like this probably work? select * from (values ...) order by ... On Thu, Jan 30, 2014 at 1:28 PM, Zsbán Ambrus wrote: > The future release sqlite 3.8.3 adds VALUES statements as a shortcut

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

I'm not a ".net" guy but, I do use visual studio. One thing I do is have several post-build steps that copy files around to where I need them before I debug. You can define "post build" steps in the project options. Thursday, January 30, 2014, 7:16:55 PM, you wrote: JM> Eric Schultz

Re: [sqlite] order of = in join

What version of SQLite and what indexes have you created? (and, if you have relevant indexes, have you run analyze?) >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of E. Timothy Uy >Sent: Thursday, 30 January, 2014 09:25

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

AUTOINCREMENT is not required unless you need to only automatically assign values to the primary key that are larger than any value ever used in the table. INTEGER PRIMARY KEY will assign a value max(column)+1 to the INTEGER PRIMARY KEY anytime a record is inserted where no value is provided

Re: [sqlite] Boolean and DataReader

Have you declared the column with integer affinity (before inserting the data)? >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Johnny >Sent: Thursday, 30 January, 2014 08:38 >To: sqlite-users@sqlite.org >Subject: Re:

Re: [sqlite] Boolean and DataReader

On 1/30/2014 7:20 PM, James K. Lowden wrote: or define a constraint colname boolean check (colname in ('Y', 'N')) Of course you can use 0 and 1, but there's no technical advantage There is a tiny advantage. Values 0 and 1 are special-cased in SQLite's file format, and occupy only

Re: [sqlite] Boolean and DataReader

On Thu, 30 Jan 2014 10:49:39 -0500 Stephen Chrzanowski wrote: > What I might suggest you do is instead of checking GetBoolean (Since > it is extremely picky apparently) is use GetInteger != 0. If the > result is ZERO this will return FALSE. (1 != 0 = TRUE; 0 != 0 = > FALSE)

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > When I debug in Visual Studio, IIS Express copies all of the > Assemblies in my "bin" directory to a folder into the "AppData\Temporary > ASP.Net Files" folder. Unfortunately, it does not copy the > System.Data.SQLite.dll.config file or the x86 and amd64 subfolders of bin

[sqlite] Documentation

This page is more than awseome : http://www.sqlite.org/draft/lang_select.html By comparison, this other page is more than outdated, and drags down the website global experience : http://www.sqlite.org/draft/speed.html ==> Wouldn't it be better to remove it, for the moment ?

[sqlite] System.Data.SQLite Preloading and ASP.Net debugging

All, I'm adding SQLite support to the open source Orchard project (which is an ASP.Net CMS) and I'm running into a problem with System.Data.SQLite preloading. When I debug in Visual Studio, IIS Express copies all of the Assemblies in my "bin" directory to a folder into the "AppData\Temporary

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

On Thu, Jan 30, 2014 at 3:07 PM, Zsbán Ambrus wrote: > On 1/30/14, Richard Hipp wrote: > > Thanks Kevin and Ambrus for the error reports. A revised copy of the > > documentation is up at http://www.sqlite.org/draft/lang_select.html - > > please let me know

[sqlite] Order of rows in a VALUES select expression

The future release sqlite 3.8.3 adds VALUES statements as a shortcut form of SELECT statements. This shortcut simply creates a results set made of any number of rows, any number of (unnamed) columns in each, and all the values given by separate explicit expressions. My question is whether sqlite

Re: [sqlite] order of = in join

On 1/30/14, E. Timothy Uy wrote: > #1 - f.term = t.term > Query #1 takes 300 ms, and query #2 takes 30 ms. Can you show the schema for the tables? Is it possible that the two equals comparisons use different affinity or collation, which changes the semantics of your statement?

Re: [sqlite] too many SQL variables

Hehe, you know it. On Thu, Jan 30, 2014 at 11:51 AM, RSmith wrote: > > Just for my edification, what is the limit on the number of SQL >> parameters? >> Today I hit "too may SQL variables" with about 1400... >> Just for our edification, which kind of statement was that? >>

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

On 1/30/14, Richard Hipp wrote: > Thanks Kevin and Ambrus for the error reports. A revised copy of the > documentation is up at http://www.sqlite.org/draft/lang_select.html - > please let me know if you see any other problems. Great, but the diagram for table-or-subquery still

Re: [sqlite] too many SQL variables

Just for my edification, what is the limit on the number of SQL parameters? Today I hit "too may SQL variables" with about 1400… Just for our edification, which kind of statement was that? The worst kind :) ___ sqlite-users mailing list

Re: [sqlite] order of = in join

E. Timothy Uy wrote: > Here the Terms_content table is big, maybe 300k rows, while the Favorites > table is small, <100 rows. Query #1 takes 300 ms, and query #2 takes 30 ms. Which SQLite version? What is the output of EXPLAIN QUERY PLAN for both queries? Regards, Clemens

Re: [sqlite] too many SQL variables

On Jan 30, 2014, at 7:01 PM, E. Timothy Uy wrote: > Just for my edification, what is the limit on the number of SQL parameters? > Today I hit "too may SQL variables" with about 1400… Just for our edification, which kind of statement was that?

[sqlite] too many SQL variables

Just for my edification, what is the limit on the number of SQL parameters? Today I hit "too may SQL variables" with about 1400... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] too many SQL variables

On 01/31/2014 01:01 AM, E. Timothy Uy wrote: Just for my edification, what is the limit on the number of SQL parameters? Today I hit "too may SQL variables" with about 1400... 999. http://www.sqlite.org/limits.html#max_variable_number ___

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

Another change to the select-stmt syntax diagram. I need to adjust the text to match, but I have to be away from my desk for a few minutes. More updates when I return. On Thu, Jan 30, 2014 at 12:39 PM, Richard Hipp wrote: > Thanks Kevin and Ambrus for the error reports. A

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

Thanks Kevin and Ambrus for the error reports. A revised copy of the documentation is up at http://www.sqlite.org/draft/lang_select.html - please let me know if you see any other problems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] How to Troubleshoot Disk I/O Error

Hello Akintoye, A common problem I ran into with the transition from XP to anything newer is that the user folders changed. So, what was a legal read/write folder in XP wasn't in Vista+. I had the folder embedded in the configuration file so, when they brought their old configurations forward,

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

On Thu, Jan 30, 2014 at 10:58 AM, Richard Hipp wrote: > Documentation on SELECT statements at > http://www.sqlite.org/draft/lang_select.html has now been updated and > amplified. > > > On Thu, Jan 30, 2014 at 5:52 AM, Zsbán Ambrus wrote: > > > Hi! > > > >

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

On 1/30/14, Richard Hipp wrote: > Documentation on SELECT statements at > http://www.sqlite.org/draft/lang_select.html has now been updated and > amplified. Thank you, that seems cleaner. However, there seems to be an error. From the diagram for select-stmt and also in the

Re: [sqlite] order of = in join

On 30 Jan 2014, at 4:24pm, E. Timothy Uy wrote: > Here the Terms_content table is big, maybe 300k rows, while the Favorites > table is small, <100 rows. Query #1 takes 300 ms, and query #2 takes 30 ms. Have you run ANALYZE on the database ? Simon.

[sqlite] order of = in join

#1 - f.term = t.term SELECT m.term AS term, m.definition AS definition FROM (SELECT t.term, e.definition FROM Terms_content t INNER JOIN Favorites f ON f.term = t.term LEFT JOIN TermEntries te ON te.termid = t.docid LEFT JOIN Entries e ON e.docid = te.entryid) AS m LEFT JOIN Favorites f ON f.term

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

There is a problem in the first group of SQL statements. The coffee hadn't set in, and I always find crap on a reread-after-submission. Should read as follows: Previously: create table Tasks (TaskID INTEGER PRIMARY KEY AUTOINCREMENT, fkProjectID integer, TaskID integer, TaskName char, Completed

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

Documentation on SELECT statements at http://www.sqlite.org/draft/lang_select.html has now been updated and amplified. On Thu, Jan 30, 2014 at 5:52 AM, Zsbán Ambrus wrote: > Hi! > > I'm writing to you about the syntax diagram that appears on >

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

Wow! thanks for this. I have to read it slowly to capture the understanding of some of the syntax. But this is great! thanks. Stephen Chrzanowski" wrote... Untested and only from the SQL compiler in my brain -- This compiler is known to have a few bugs -- It may also be too late to go

Re: [sqlite] How to Troubleshoot Disk I/O Error

Error is-> SQLITE_IOERR 10 /* Some kind of disk I/O error occurred */ - Akintoye - Original Message - From: pontia...@gmail.com To: Akintoye Olorode (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org At: Jan 30 2014 10:38:53 What exact Disk I/O error are you getting? There are

Re: [sqlite] How to Troubleshoot Disk I/O Error

Thanks, will try this suggestions and post results. - Akintoye - Original Message - From: sqlite-users@sqlite.org To: sqlite-users@sqlite.org At: Jan 30 2014 10:44:45 On 01/30/2014 10:19 PM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) wrote: > Hi, > > We have one client that recently

Re: [sqlite] Boolean and DataReader

I don't use .NET anything, so I can't speak on it. However, with my wrapper in Delphi, if I store a value as 1 or '1', returning a .AsInteger will succeed. The wrapper is smart enough to decide if it is actually a number. I don't recall if it'll throw an exception if the value in the database

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

Untested and only from the SQL compiler in my brain -- This compiler is known to have a few bugs -- It may also be too late to go use this, so this might be something to look at if you plan on upgrading; This is the first way I'd do it; create table Projects (ProjectID INTEGER PRIMARY KEY

Re: [sqlite] How to Troubleshoot Disk I/O Error

On 01/30/2014 10:19 PM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) wrote: Hi, We have one client that recently upgraded from WinXP SP3 to Win7 sp1 (Japanese Language). With new OS, attempts to access read from our sqlite database fails with disk I/O error. Can anyone help with suggestions on

Re: [sqlite] How to Troubleshoot Disk I/O Error

On 01/30/2014 10:19 PM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) wrote: Hi, We have one client that recently upgraded from WinXP SP3 to Win7 sp1 (Japanese Language). With new OS, attempts to access read from our sqlite database fails with disk I/O error. Can anyone help with suggestions on

Re: [sqlite] Boolean and DataReader

I'm not one of the sqlite dev'rs for sure, but I immagine that the .net driver has been done with their cooperation In any case the funny thing is that (in a particular situation: after a "wrong" insert of "1" instead of 1, fault of sqlite admin) my Wrapper level - can I say that the ADO .net

Re: [sqlite] How to Troubleshoot Disk I/O Error

What exact Disk I/O error are you getting? There are many different types. - Permissions to read are denied - Invalid characters in the filename - Corrupted database etc On Thu, Jan 30, 2014 at 10:19 AM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) < aolor...@bloomberg.net> wrote: > Hi, > > We

[sqlite] How to Troubleshoot Disk I/O Error

Hi, We have one client that recently upgraded from WinXP SP3 to Win7 sp1 (Japanese Language). With new OS, attempts to access read from our sqlite database fails with disk I/O error. Can anyone help with suggestions on how to troubleshoot disk I/O error ? Adding call to

Re: [sqlite] Boolean and DataReader

Just to make it crystal clear, to a developer actually calling the SQLite functions (I'm talking about [ PrepareSQL_v2 ] and such, not [ select * from table ]), SQLite is TYPELESS which means there is no data type that is kept track of for any field. This means that even if you define a column as

Re: [sqlite] SQLite access from ARM ?

Hi, Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > Do you know some project to SQLite access from ARM embedded processors ? > I see something for mySQL using MBed plataform (ARM Cortex M3). > Thanks and best regards. As SQLite comes in the form of C source, it

[sqlite] SQLite access from ARM ?

Do you know some project to SQLite access from ARM embedded processors ? I see something for mySQL using MBed plataform (ARM Cortex M3). Thanks and best regards. Renato / Brazil ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Boolean and DataReader

I just want to keep track of the issue as it is and of the complete solution. Problem was due to a wrong sqlite initialization of the Boolean as a text instead of integer when I used the boolean checkbox of the EditData tab in SQLite Administrator software. Fixing that and making DR.GetBoolean

[sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

Hi! I'm writing to you about the syntax diagram that appears on "http://sqlite.org/draft/lang_select.html;, and is a draft for the next version of sqlite (3.8.3). I find this diagram confusing, and would rather prefer to have something similar to "http://sqlite.org/lang_select.html;, only of

[sqlite] "PRAGMA data_store_directory" inconsistancies

Noting that: - In src/pragma.c line 1267 can be seen that this PRAGMA is only expected to exist when SQLITE_OS_WIN==1 - In src/pragma.c line 149, the pragma is eliminated when SQLITE_OMIT_PAGER_PRAGMAS is defined. This looks wrong to me. - On Cygwin, one of the functions exported from the