On Thu, Nov 13, 2014 at 6:53 PM, RSmith rsm...@rsweb.co.za 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
Impressive !
On 12 November 2014 12:08, Kirill kir...@aidagw.com 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
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 kir...@aidagw.com wrote:
Good day,
Full line manager to work
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
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);
INSERT INTO B
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
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
On 14 Nov 2014, at 3:42am, James K. Lowden jklow...@schemamania.org wrote:
Simon Slavin slav...@bigfraud.org 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.
On 14 Nov 2014, at 10:40am, ARVIND KUMAR arv...@sblsoftware.com 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
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 istas...@gmail.com wrote:
CREATE TABLE A(id UNSIGNED
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
On Fri, 14 Nov 2014 04:59:58 -0700 (MST), bjdodo bjd...@hotmail.com
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
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
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
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
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
On Fri, Nov 14, 2014 at 4:31 PM, Clemens Ladisch clem...@ladisch.de 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
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
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?
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
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-type
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
22 matches
Mail list logo