If you're using SQLite3.exe (or equivalent CLI - Command Line Interface)
then by default the database id written to memory, not to the disk. Doing
something like [ sqlite3.exe test.db3] will create a test.db3 file once you
do an actual transaction like creating a table. I THINK even doing a
selec
Yuriy Kaminskiy wrote:
> Use of some function/features protected by #ifdefs, but lacks autoconf magic
> to
> automatically enable them when possible. Of course, they can be manually
> enabled, but it is not very likely. And unused code tends to bitrot.
Oops, last time patch attachment with mime-t
Use of some function/features protected by #ifdefs, but lacks autoconf magic to
automatically enable them when possible. Of course, they can be manually
enabled, but it is not very likely. And unused code tends to bitrot.
___
sqlite-users mailing list
s
On Fri, Nov 14, 2014 at 6:16 PM, Paul Sanderson <
sandersonforens...@gmail.com> wrote:
> I can simplify the SQL by creating a view andthen use the ciew in my
> recursive cte, but for various reasons I would rather not do this.
>
> Is it possible to use a recursive cte that refers to a cte?
>
http
I have a recursive cte on a joined table and altough it works fine the
SQL is a little complex and teh join makes it a little difficult to
follow.
I can simplify the SQL by creating a view andthen use the ciew in my
recursive cte, but for various reasons I would rather not do this.
Is it possible
On Fri, Nov 14, 2014 at 4:31 PM, Clemens Ladisch wrote:
> I understand the desire to avoid storing data on the web server, but it
> would
>
It doesn't - you can load local files.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since
The ticket describing the cause of this problem is
https://www.sqlite.org/src/tktview/db872294979b
The problem should be fixed in 3.8.7.2 (due early next week) and in the
next main release 3.8.8, and later today on trunk and on the branch-3.8.7
branch.
On Fri, Nov 14, 2014 at 9:45 AM, Igor Stassi
Dan Kennedy wrote:
> Perhaps not as functional as a native app (so far), but looking really good!
> And you can't beat the deployment.
Well, it does not replace SQL Fiddle.
I understand the desire to avoid storing data on the web server, but it would
be nice if the initial schema/query could be s
bjdodo wrote:
> Sorry for resurrecting an old thread. I got the where clause working for
> queries with byte array arguments based on this discussion. I cannot find
> the way to use byte arrays in where clauses for update and delete
> statements.
In the Android database API, execSQL() is the only
On 11/14/2014 08:33 AM, RP McMurphy wrote:
When using CTEs the rowid is null. The following returns "--NULL--"
.null --NULL--
with c(x) as (select 1)
select rowid from c;
I guess that's expected. The same behaviour as for reading the rowid of
a view or sub-select. It s
On Fri, 14 Nov 2014 04:59:58 -0700 (MST), bjdodo
wrote:
>Hi
>
>Sorry for resurrecting an old thread. I got the where clause working for
>queries with byte array arguments based on this discussion. I cannot find
>the way to use byte arrays in where clauses for update and delete
>statements. I know
this was found in a larger query during testing (the number of ids was
larger in the IN statement,
however the query was the same)
the bug was found with version 3.8.7.1 on:
Linux 3.13.0-39-generic #66-Ubuntu x86_64 GNU/Linux
on 3.8.2 the error did not occur on Ubuntu, but occured on
Darwin Kerne
Thanks for the succinct script for reproducing the problem. We are working
on it now.
Just curious: Did you find this problem when a larger and more complex
query failed in a real application?
On Thu, Nov 13, 2014 at 9:05 AM, Igor Stassiy wrote:
> CREATE TABLE A(id UNSIGNED INT, tag NVARCHAR(
On 14 Nov 2014, at 10:40am, ARVIND KUMAR wrote:
> I am new for SQLite. I am trying to create database. But its not creating.
> I have attached the screenshot. Please find and do needful.
You cannot post screenshots to this mailing list.
Most problems with creating a new database are because yo
On 14 Nov 2014, at 3:42am, James K. Lowden wrote:
> Simon Slavin wrote:
>
>> I'm not aware of
>> any usable libraries which actually support 23,10 outside the world
>> of physics.
>
> http://www.mpfr.org/#free-sw
>
> I'm sure you're aware of such things.
Hey, you're right. I was thinking a
Hi
Sorry for resurrecting an old thread. I got the where clause working for
queries with byte array arguments based on this discussion. I cannot find
the way to use byte arrays in where clauses for update and delete
statements. I know it is terrible to use byte arrays as query arguments, I
need th
CREATE TABLE A(id UNSIGNED INT, tag NVARCHAR(256), value NVARCHAR(256));
CREATE TABLE B(tag NVARCHAR(256), hash NVARCHAR(256));
INSERT INTO A VALUES(1, "color", "red");
INSERT INTO A VALUES(1, "size", "big");
INSERT INTO A VALUES(2, "color", "green");
INSERT INTO A VALUES(2, "size", "small");
IN
Hi,
I am new for SQLite. I am trying to create database. But its not creating.
I have attached the screenshot. Please find and do needful.
Thanks & Regards
Arvind
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailm
When using CTEs the rowid is null. The following returns "--NULL--"
.null --NULL--
with c(x) as (select 1)
select rowid from c;
RP
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listi
On 11/14/2014 03:37 PM, Noel Frankinet wrote:
Impressive !
It is that. Perhaps not as functional as a native app (so far), but
looking really good! And you can't beat the deployment.
Dan.
On 12 November 2014 12:08, Kirill wrote:
Good day,
Full line manager to work with sqlite direct
Impressive !
On 12 November 2014 12:08, Kirill wrote:
> Good day,
>
> Full line manager to work with sqlite directly
> from the browser on any platform:
> http://sqliteonline.com/
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://s
On Thu, Nov 13, 2014 at 6:53 PM, RSmith wrote:
> By the way, my Oracle friends should intersect here if need be, but I
> believe the oracle method of /decimal(n,m)/ is simply a representation
> directive and constraint, there is no native datatype that actually stores
> or communicates such a val
22 matches
Mail list logo