- Original Message -
From: Alek Paunov a...@declera.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Monday, August 25, 2014 4:04 PM
Subject: Re: [sqlite] Problem with recursive CTE
On 25.08.2014 15:42, Frank Millman wrote:
I have upgraded to version
On Monday, August 25, 2014 09:25:47 PM Stephan Beal wrote:
On Mon, Aug 25, 2014 at 9:17 PM, Petite Abeille petite.abei...@gmail.com
wrote:
True. But what a quantum leap that would be. Like moving from the
wheelbarrow to the jet engine.
For the small percentage of users who need it (or
hi, Andy Ling:
The error disk I / o error I have resolved ;
but when I used the following code:
rc = sqlite3_open(D:\\WindRiver\\SqliteOne.db,db);
it tell me can not find the data base;
when I used the following code:
rc = sqlite3_open(SqliteOne.db,db);
It is OK
How could I resolve the
As I said before, that doesn’t look like a vxWorks path to a file. Are you sure
D:\\WindRiver really exists? In general vxWorks uses the forward slash (/) as a
path separator. Is this a remote mounted host file system you are trying to use?
What is your current directory when it works the
On Tue, Aug 26, 2014 at 8:44 AM, 王庆刚 2004wqg2...@163.com wrote:
hi, Andy Ling:
The error disk I / o error I have resolved ;
but when I used the following code:
rc = sqlite3_open(D:\\WindRiver\\SqliteOne.db,db);
it tell me can not find the data base;
Have you tried instead:
rc =
On 25.08.2014 20:47, Richard Hipp wrote:
On Mon, Aug 25, 2014 at 1:21 PM, forkandwait webb.spra...@gmail.com wrote:
You used the word immense which I like - it is an apt description of
the
knowledge and effort needed to add windowing functions to SQLite (and
probably any other database
Igor, thanks for a meaningful response. I am a neophyte at SQL, and learning it
on my own. The graphical approach to a solution is another methodology I will
be adding to my arsenal.
The reason why I was checking both names against stop B is that my intent was
to find the other route stops
A thin SQLite wrapper for Swift:
https://github.com/ryanfowler/SwiftData
Uses Swift variable types. You have to explicitly say what type you want your
value as.
Implements variable binding for security purposes.
Implements a date class. I have not checked out how well it does this.
On 2014-08-25 17:04, Richard Hipp wrote:
Thank you for creating this project. I downloaded a copy. It seems
very nice.
NOW, PLEASE CHANGE THE NAME!!!
SQLite is a trademark. You are welcomed and encouraged to use the
code for SQLite, but not the name SQLite.
This is not just a legal
Hello,
It seems to me that, all of a sudden, a LOT of micro-wins and bigger wins
are raining on the Sqlite/timeline
(since about august 1rst, the in () improvement)
Is it an effect of a new Compiling/Testing environnement ? of summer
vaccation ? of partner's help ?
(maybe I'm wrong and all is
On Tue, Aug 26, 2014 at 6:58 PM, big stone stonebi...@gmail.com wrote:
(maybe I'm wrong and all is as speedy as usual)
Maybe this additional info will help:
http://sqlite.org/src/reports?view=byweek
http://sqlite.org/src/reports?view=bymonth
--
- stephan beal
On 2014-08-26 18:00, sqlite-users-requ...@sqlite.org wrote:
SELECT
employee_name,
employee_id,
salary,
rank() OVER(PARTITION BY dept ORDER BY salary DESC),
100.0*salary/sum(salary) OVER (PARTITION BY dept)
FROM employee;
I don't know if the above is valid SQL or not. But is
On Tue, Aug 26, 2014 at 12:58 PM, big stone stonebi...@gmail.com wrote:
Hello,
It seems to me that, all of a sudden, a LOT of micro-wins and bigger wins
are raining on the Sqlite/timeline
(since about august 1rst, the in () improvement)
Is it an effect of a new Compiling/Testing
See also
https://news.ycombinator.com/item?id=8226962
for discussion.
On Tue, Aug 26, 2014 at 9:09 AM, Simon Slavin slav...@bigfraud.org wrote:
A thin SQLite wrapper for Swift:
https://github.com/ryanfowler/SwiftData
Uses Swift variable types. You have to explicitly say what type you
I have taken a different approach to the solution to this problem. Instead of
paring the self-joins I have cross-joined the tables in pairs as follows:
SELECT distinct R1.num, R1.company, S1.name, R2.num, R2.company
FROM stops S1, stops S2, route R1, route R2
WHERE S1.name='Craiglockhart' AND
On 8/26/2014 5:39 PM, Errol Emden wrote:
I have taken a different approach to the solution to this problem. Instead of
paring the self-joins I have cross-joined the tables in pairs as follows:
SELECT distinct R1.num, R1.company, S1.name, R2.num, R2.company
FROM stops S1, stops S2, route R1,
Regarding:
WITH RECURSIVE
x(y) AS (VALUES(1) UNION ALL SELECT y+1 FROM x WHERE y1000)
INSERT INTO player SELECT printf('Player%d',i), i, random(), NULL FROM x;
If anyone's playing along at home I wondered if instead of:
... printf('Player%d',i), i, random(),...
what might
17 matches
Mail list logo