Re: [sqlite] Reasons for SQLITE_CANTOPEN

"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

Re: [sqlite] How to find Rank in SQLite3?

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

Re: [sqlite] How to find Rank in SQLite3?

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

Re: [sqlite] BUG - Documentation

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

Re: [sqlite] SQL syntax diagrams

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

Re: [sqlite] SQL syntax diagrams

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 >

[sqlite] SQL syntax diagrams

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

Re: [sqlite] SQLITE3_CANTOPEN

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)