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
> form of SELECT stat
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 wrote
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
>T
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 f
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: [sql
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 one
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) If the result is any
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
>
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 ?
__
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
ASP.Ne
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 if you see any other problems.
>
> Gre
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
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?
Ambrus
__
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?
>>
>>
> The worst kind.
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 has an error. The
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
sqlite-
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
___
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?
___
sql
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
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
___
sqlite-u
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 revised copy of the
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 lis
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, th
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!
> >
> > I'm writing to you about the syntax diag
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 diagram for simple-se
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.
__
#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 =
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 B
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
> "http://sqlite.org/draft/lang_select.html";, and is
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 u
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 m
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 upgrad
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 is
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 AUTOINC
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 ho
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 ho
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 Syst
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 have
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 sqlite3_config(SQLITE
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
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 i
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
http://sqlite.org:8080
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 work
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 co
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
d
45 matches
Mail list logo
