Re: [sqlite] Use David Gay's fast & accurate strtod?

2012-02-21 Thread Richard Hipp
On Tue, Feb 21, 2012 at 9:07 PM, Bob Burger wrote: > > The license for David Gay's dtoa.c is not compatible with SQLite. > > Thanks for checking into it, and I'm very sorry to hear it's incompatible. > Our software uses the SQLite binary interface to bind parameters in most > cases, but there are

Re: [sqlite] Use David Gay's fast & accurate strtod?

2012-02-21 Thread Bob Burger
> The license for David Gay's dtoa.c is not compatible with SQLite. Thanks for checking into it, and I'm very sorry to hear it's incompatible. Our software uses the SQLite binary interface to bind parameters in most cases, but there are a few occasions when users specify queries in text. What w

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Joe Mistachkin
Agrawal, Manish wrote: > > Since the 32-bit installer will install 32-bit assemblies, and VS2010 > is a 32-bit app, what is the benefit of installing 64-bit assemblies > into the GAC. > The 64-bit assemblies in the GAC could be used by any purely managed application running on a 64-bit machine

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Agrawal, Manish
Thanks very much, hopefully my last question in the series: Since the 32-bit installer will install 32-bit assemblies, and VS2010 is a 32-bit app, what is the benefit of installing 64-bit assemblies into the GAC. Thanks Manish > > 2. If only the 32-bit setup files are useful, what is the use o

Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.

2012-02-21 Thread Joe Mistachkin
LouOttawa wrote: > > You explained that: "The path you are seeing is from the machine used to > build the released binaries." I understand your explanation, but is this not > then a bug in SQLite? Doesn't "someone" build the binaries on the "SQLite > machine" so to speak? > No, it's not a bug.

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Joe Mistachkin
Agrawal, Manish wrote: > > 1. To confirm, if I want data source and other visual support, I MUST INSTALL the > setups on my development machine. It is not adequate to just copy the dll files > to the project. > Basically, yes. Otherwise you would have to manually run the design-time component in

Re: [sqlite] Reference error

2012-02-21 Thread Joe Mistachkin
David Horne wrote: > > The only thing I haven't checked is the contents of the GAC for the > possible stray that you mention. Can you tell me how to do this? > Open a Visual Studio 2010 Command Prompt and type: gacutil /l System.Data.SQLite -- Joe Mistachkin

Re: [sqlite] Use David Gay's fast & accurate strtod?

2012-02-21 Thread Richard Hipp
On Tue, Feb 21, 2012 at 4:18 PM, Bob Burger wrote: > On 1 Nov 2011, Richard Hipp wrote: > > Floating-point numbers are approximations. There is no way to represent > > 290.08 or 6.97 or 283.11 in binary. The closest you can get to these > > numbers using IEEE doubles is: > > > 290.079

[sqlite] Site/Login Confusion

2012-02-21 Thread LouOttawa
I can loggin under Nabble without a problem. But the SQLite web site at "http://www.sqlite.org/src/login"; seems to be quite separate in its credentials, although it lists bug reports that I entered in Nabble. What is that website for? -- View this message in context: http://old.nabble.com/Site

Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.

2012-02-21 Thread LouOttawa
Joe... You explained that: "The path you are seeing is from the machine used to build the released binaries." I understand your explanation, but is this not then a bug in SQLite? Doesn't "someone" build the binaries on the "SQLite machine" so to speak? I mean - its not a SharpDevelop problem, is

[sqlite] Use David Gay's fast & accurate strtod?

2012-02-21 Thread Bob Burger
On 1 Nov 2011, Richard Hipp wrote: > Floating-point numbers are approximations. There is no way to represent > 290.08 or 6.97 or 283.11 in binary. The closest you can get to these > numbers using IEEE doubles is: > 290.079998408384271897375583648681640625 > 6.9697513100424

Re: [sqlite] Is there way to modify table structure after > initial definition ?

2012-02-21 Thread gregorinator
On 2/21/12, Andrew Barnes wrote: >> You need to study the ALTER TABLE statement and its limitations. {snip} > SQLLite uses dynamic typing so you can put data of any type into any column. Modification of the table structure might not be necessary in this case, but in a general case, SQLite's ALTER

Re: [sqlite] Is there way to modify table structure after > initial definition ?

2012-02-21 Thread Andrew Barnes
> Huang Chen Min wrote: > > Dear all: > > Forgive for asking such stupid question. I use Xbase way to > > understand SQLite. > > It is allowed to modify dat type of column in clipper. In my personal > > thoughts, Creating a brandnew table and copy those data from older version > > might be

Re: [sqlite] Reference error

2012-02-21 Thread David Horne
Yes I do mean 'System.Data.SQLite.dll' and I've checked for any duplicates. I've also removed the original download and installation, downloaded again and re-installed. The reference is to : C:\Program FIles\System.Data.SQLite\2010\bin\System.Data.SQLite.dll. This little test is about as simple

Re: [sqlite] Relative path to sqlite database

2012-02-21 Thread Taleeb Anwar
Hi, Your exe from desktop, perhaps, crashes because it can no longer find the resources referenced by it (and present in debug folder) For test purpose you can try ../../db/test.db3 But this will fail on deployment. You need to programmatically find the exe location. One of the following may hel

Re: [sqlite] Relative path to sqlite database

2012-02-21 Thread Pavel Ivanov
> Just a quick note though, when I move the .exe file to the desktop and > double-click on it, it crashes, which suggests that the bin/debug location is > only applicable when the application is run from within the IDE. Crash is probably because your desktop folder doesn't have db subdirectory w

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Brady Kelly
On 21 February 2012 05:44, Joe Mistachkin wrote: > > NOTE #2: When installing the setup package, make sure that the option to > install the assemblies into the GAC is checked if you plan on installing > the design-time components. In the next release, this box will be checked > by default. > T

Re: [sqlite] SQLite data source in Visual Studio 2010

2012-02-21 Thread Agrawal, Manish
Thanks very much, that is very helpful. I had three follow up questions: 1. To confirm, if I want data source and other visual support, I MUST INSTALL the setups on my development machine. It is not adequate to just copy the dll files to the project. 2. If only the 32-bit setup files are useful