"D. Richard Hipp" writes:
> On Jan 12, 2010, at 6:58 AM, Ian Jackson wrote:
>
>> Nikolaus Rath writes ("Re: [sqlite] Reasons for SQLITE_CANTOPEN"):
>>> Edzard Pasma writes:
Hope strace (see Roger Binns' post) will help you further. Also lsof
may help.
>>>
>>> The problem was indeed that
Not saying this will be faster for sure, but it's worth a try. Try a
composite index on (dept, salary). The goal is to rank distinct salaries
within department, and have those salary rankings be used as the inner
loop when the EEs table is joined to the ranking on the salary column.
The assump
Jigar,
If these two employees have the same rank:
dept, employee, salary
10, Joe, 75000
10, Mary, 75000
then you do not need to include employee columns in the inline view. The salary
gets the rank, not the employee, and the employee record is joined to the
ranked salary on salary.
Tim
Perhaps "...to whole underlying operating system..." should be "...to the whole
underlying operating system..."
- Original Message
From: Dennis Cote
To: General Discussion of SQLite Database
Sent: Thu, January 14, 2010 4:38:48 PM
Subject: [sqlite] BUG - Documentation
On the website p
On Jan 15, 2010, at 9:10 AM, Andy Gibbs wrote:
>
> Hi,
>
> I really like the way the SQL syntax diagrams are done (e.g. at
> http://www.sqlite.org/syntaxdiagrams.html)
> . What software did you use for it?
>
http://wiki.tcl.tk/21708
Also:
http://www.sqlite.org/faq.html#q25 and
http://www.s
On Jan 15, 2010, at 9:10 PM, Andy Gibbs wrote:
>
> Hi,
>
> I really like the way the SQL syntax diagrams are done (e.g. at
> http://www.sqlite.org/syntaxdiagrams.html)
> . What software did you use for it?
http://wiki.tcl.tk/21708
>
> Regards
> Andy
>
>
Hi,
I really like the way the SQL syntax diagrams are done (e.g. at
http://www.sqlite.org/syntaxdiagrams.html). What software did you use for it?
Regards
Andy
_
We want to hear all your f
As I think, the code you were surprised to see was a fix for this issue:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg35864.html
as Jeremy Spiegel in that post wrote
> when I try calling DeleteFileW on a file with a handle open on
> that file, I see DeleteFileW returning 1 (success) an
8 matches
Mail list logo