[sqlite] VB.net error on adding SQLite3.dll to Project References

2011-03-03 Thread J Trahair
Hi everyone. VB.Net 2005, I am trying to add sqlite3.dll to the Project References. When I try to Add the dll I get an error message: 'A reference to {path to sqlite3.dll} could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component.' The

[sqlite] Invitation to connect on LinkedIn

2011-03-03 Thread Stephen Kervin
LinkedIn I'd like to add you to my professional network on LinkedIn. - Stephen Stephen Kervin Solutions Architect and Development Manager at SunGard Reading, United Kingdom Confirm that you know Stephen Kervin

Re: [sqlite] VB.net error on adding SQLite3.dll to Project References

2011-03-03 Thread Philip Graham Willoughby
On 3 Mar 2011, at 09:23, J Trahair wrote: Hi everyone. VB.Net 2005, I am trying to add sqlite3.dll to the Project References. When I try to Add the dll I get an error message: 'A reference to {path to sqlite3.dll} could not be added. Please make sure that the file is accessible, and

Re: [sqlite] possible bug handling group by and where clauses

2011-03-03 Thread alexis bialot
On 02/03/2011 17:30, Jay A. Kreibich wrote: On Wed, Mar 02, 2011 at 09:53:51AM +0100, alexis bialot scratched on the wall: hello, this looks to me like a bug but maybe this is just my misunderstanding. You might run an integrity check on the database file and verify any indexes you have

Re: [sqlite] Bug: rtree2 tests fail due to incorrect format string in rtree.c

2011-03-03 Thread Pavel Ivanov
 A favorite interview question is, given this line and no other  information, how big must buf_size be to never clip the output?  You can assume the default 1.6 precision (%1.6f).    snprintf( buf, buf_size, %f, v );  The answer?  At least 318 characters. This is very interesting. Jay, could

Re: [sqlite] Bug: rtree2 tests fail due to incorrect format string in rtree.c

2011-03-03 Thread Jay A. Kreibich
On Thu, Mar 03, 2011 at 11:06:33AM -0500, Pavel Ivanov scratched on the wall: ?A favorite interview question is, given this line and no other ?information, how big must buf_size be to never clip the output? ?You can assume the default 1.6 precision (%1.6f). ? ?snprintf( buf, buf_size, %f,

Re: [sqlite] Bug: rtree2 tests fail due to incorrect format string in rtree.c

2011-03-03 Thread Pavel Ivanov
I had an impression that for such big number it will be printed in scientific notation. But I guess that's the difference between %g and %f. And it turns out my habit of using %g instead of %f is a very good thing. Thank you very much for the explanation, Jay. Pavel On Thu, Mar 3, 2011 at 12:06

[sqlite] What is the data type affinity of columns generated by aggregate function and GROUP BY clause?

2011-03-03 Thread chen jia
Hi there, When I create a new table by using aggregate functions and the GROUP by clause, the newly generated columns do not have any data type affinity according to the schema info, while the old columns to which I apply the aggregate functions all have data type affinity. I wonder how SQLite

Re: [sqlite] OSX locking

2011-03-03 Thread Dave Dyer
I'm getting a little closer to pointing the finger at sqlite. I rebuilt my application using an archived binary from march 2009, and it works in the cases where a modern binary fails. It appears that some change in sqlite locking strategy between 2009 and now is not completely compatible with

Re: [sqlite] What is the data type affinity of columns generated by aggregate function and GROUP BY clause?

2011-03-03 Thread Igor Tandetnik
chen jia chen_1...@fisher.osu.edu wrote: When I create a new table by using aggregate functions and the GROUP by clause, the newly generated columns do not have any data type affinity according to the schema info, while the old columns to which I apply the aggregate functions all have data