Hi,
Actually, I've found a workaround:
To create the sql request, I use a stringstream.
I've set the precision of this stream to 30
(instead of default which is 6 I think).
This made the request's '1.79769e+308' be
trandformed into '1.79769313486232e+308'.
But this does not explain *why* the problem occured.
Could it be that sqlite does not find a double
representation of the string '1.79769e+308' but
finds one for '1.79769313486232e+308' ?
The column which contains these numbers is
declared as REAL. This raises another question to
me: I thought that the numbers were stored as
strings, so why sqlite would try to transform these strings into double?
Stéphane
At 11:01 12/09/2007, Trevor Talbot wrote:
On 9/12/07, Stéphane Thiers <[EMAIL PROTECTED]> wrote:
> I got this stack error in SQLITE when executing the following request:
I assume there's an exception that goes with this; what is it?
> "INSERT INTO _scalars_float
> VALUES(237,220,'ComputedNoise','Noise','Noise
> level estimated by the smoothing
>
algorithm','DouglasPeuckerAlgorihtm',0,0,NULL,'-1.79769e+308','1.79769e+308','%.2f','')
If this is part of C-style code, what value was
used as an argument for "%.2f"?
> mscorlib.ni.dll!793612c2()
> mscorlib.ni.dll!79361141()
What are you using the CLR for in this process?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
Stéphane Thiers
Data Systems, Lancelot Applications Software Group Engineer
Scientific Instruments
Varian Data Systems S.A.S
1 Rue Hector Berlioz
ZAC DES PLANS
F-38600 FONTAINE
FRANCE
Tel: +33 4 76 53 35 80
Fax: +33 4 76 53 35 89
[EMAIL PROTECTED]
http://www.varianinc.com
Inspiring Excellence
