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

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 >

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

> 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

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

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

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

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

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

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

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

Re: [sqlite] Reference error

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?

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: >

[sqlite] Site/Login Confusion

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:

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

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?

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 >

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

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

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

> 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

Re: [sqlite] Reference error

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

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

Re: [sqlite] Relative path to sqlite database

> 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

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

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

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

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