Le Mon, 19 Oct 2015 08:41:28 +0200,
"Gert Venter" a ?crit :
> I also received an eMail from alexa within 15 minutes after registering.
>
> GAV
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org
On 22 Oct 2015 at 21:25, Richard A Rousselot wrote:
> I fully expected something like this from a fractional number like 1/3 but
> didn't realize that this would be the case if when the digits were explicitly
> stated and they summed to a whole number. I will use a Cast statement to
> resolve.
Le Thu, 22 Oct 2015 19:45:09 +,
"Rousselot, Richard A" a ?crit :
> Doing the following math, why is it that the results are not all returning
> "yes"?
>
> SELECT
> (9.2+7.9+0+4.0+2.6+1.3),
> case when (9.2+7.9+0+4.0+2.6+1.3)=25.0 then "yes" else "no"
> end,
Solved.
At the end I have added the parameter -DSQLITE_THREADSAFE=0 to exclude the
multithread code from the library
Thank you.
Marco
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens
L
If I recall, he had a printout of the state at each time unit. The state was
represented as a set of numbers out to 6 decimal points.
He wanted to rerun part of the simulation, so he entered in those super-precise
numbers and let them run, but the model quick diverged because those numbers
jus
On Thu, Oct 22, 2015 at 9:45 PM, Rousselot, Richard A <
Richard.A.Rousselot at centurylink.com> wrote:
> Doing the following math, why is it that the results are not all returning
> "yes"?
>
> SELECT
> (9.2+7.9+0+4.0+2.6+1.3),
> case when (9.2+7.9+0+4.0+2.6+1.3)=25.
On 22 Oct 2015, at 8:45pm, Rousselot, Richard A wrote:
>(9.2+7.9+0+1.0+1.3+1.6),
If you really are handling a lot of numbers with exactly one decimal place, the
answer is to multiply them all by 10 are part of your input routine, and store
them all as integers. On the other h
Marco Turco wrote:
> could you please give me the full Bcc32 string you are using ?
That would not be useful for you; I'm using an incompatible calling convention.
Just replace "-tW" with "-tWM".
Regards,
Clemens
I did read the documentation and that says:
If the most recent API call was successful, then the return value from
sqlite3_errcode is undefined. It is a bit awkward though that after doing
this after sqlite3_step gives 100 or 101
for sqlite3_errcode and unknown error for sqlite3_errmsg.
Why can't i
I fully expected something like this from a fractional number like 1/3 but
didn't realize that this would be the case if when the digits were explicitly
stated and they summed to a whole number. I will use a Cast statement to
resolve.
FWIW, MySQL and Oracle both return all yes for that query.
Hi Hector,
You can just copy-paste the unit code here - we'll have a look, but it's
best to write a set of SQL statements that can be run in any SQLite
application (such as the sqlite3.exe command line interface) and see
whether that too doesn't work right, and if it doesn't, then we have a
de
Doing the following math, why is it that the results are not all returning
"yes"?
SELECT
(9.2+7.9+0+4.0+2.6+1.3),
case when (9.2+7.9+0+4.0+2.6+1.3)=25.0 then "yes" else "no" end,
(9.2+7.8+0+3.0+1.3+1.7),
case when (9.2+7.8+0+3.0+1.3+
> Financial software frequently handles all currency amounts as pence or
> cents for the reasons you've just found out. Annoys the heck out of
> bankers until you have them work problems by hand and seen just how stupid
> computers really are.
Usually as hundredths (1/100) of a cent -- that is,
Because there are differences. Double precision floating point is only
accurate to 14 digits and there is a difference in the 15th decimal place.
sqlite> SELECT
...> (9.2+7.9+0+4.0+2.6+1.3) - 25.0,
...> (9.2+7.8+0+3.0+1.3+1.7) - 23.0,
...>
On 10/22/2015 4:25 PM, Rousselot, Richard A wrote:
> I fully expected something like this from a fractional number like 1/3 but
> didn't realize that this would be the case if when the digits were explicitly
> stated and they summed to a whole number. I will use a Cast statement to
> resolve.
J
Thanks Simon!
We also store our critical data synchronously in flat (csv) files before
sending it in the sqlite database. When the hard reboot occured only one
of these was corrupted and only the last line.
We can always refill sqlite from these files, we use sqlite to allow us
to easily offer a
Hi,
could you please give me the full Bcc32 string you are using ?
thank you
Marco
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Clemens
Ladisch
Sent: Thursday, October 22, 2015 4:22 PM
To: sq
Marco Turco wrote:
> I'm trying to generate the sqlite3 library but there is no way with
> Embercadero C++ 7.00.
>
> I always receive some warnings and the first two related to the
> _endthreadex' and '_beginthreadex' cannot permit to link me the library.
>
> k:\BCC70\Bin\Bcc32.Exe -DHB_NO_DEFAULT_
Oh yeah, bingo :)
Thanks?
Gergely
On 22/10/2015 17:05, "Scott Hess" wrote:
>Dollars to donuts you're compiling SQLite but then linking against the
>system version.
>
>-scott
>
>
>On Thu, Oct 22, 2015 at 7:51 AM, Gergely Lukacsy (glukacsy) <
>glukacsy at cisco.com> wrote:
>
>> Hi Simon,
>>
>> T
On 10/22/2015 3:45 PM, Rousselot, Richard A wrote:
> Doing the following math, why is it that the results are not all returning
> "yes"?
For the same reason that 0.33 + 0.33 + 0.33 !=
1. 0.33 is only approximately equal to 1/3, and the error
tends to accumulate
Hi,
can any one write some suggestion (I mean nuget package(s)) for creating
Windows Store App in C# with SQLite? In desktop apps I use simply
"System.Data.SQLite (x86/x64)" which I love because it allows me to write
SQL statements directly. Are there any good (ideally with examples or
documentatio
I will prepare a version of my DB file with dummy customers and
suppliers names (not too many) and I can pass it as it is.
On 22.10.2015 15:19, Richard Hipp wrote:
> Thanks for the report.
>
> Can you also provide us with a test case that demonstrates the malfunction?
>
> On 10/22/15, Catalin Ion
> Maybe running under control of a debugger would help to locate the exact
error position
I am not familiar with C code or C debugging, but will look into that.
RBS
On Thu, Oct 22, 2015 at 3:11 PM, Hick Gunter wrote:
>
>
> >> Can you reproduce the problem using the sqlite shell?
> >This won't
The problem is when I link the generated library. I receive the following error
related to the first two warnings so I'm unable to generate the executable file.
Embarcadero C++ 7.00 for Win32 Copyright (c) 1993-2015 Embarcadero
Technologies, Inc.
K:\RENTMNG\Obj\mod306f.c:
k:\BCC70\Bin\iLink32.Ex
Hi Simon,
Thanks for coming back to me.
I ran sqlite3_compileoption_get in a loop to enumerate all options (I
assume this is the same as the pragma query suggested below) and I got the
following:
2015-10-22T14:46:24.000Z [0x7fff7679d300] DBWrapper.cpp:33
DBInit:OptiomENABLE_FTS3
2015-10-22T14:
On 22 Oct 2015, at 2:38pm, Gergely Lukacsy (glukacsy)
wrote:
> ... I get an "error: no module: fts5" error message. This indicates that I
> didn't compile SQLite with FTS5 support, but I am pretty sure that I am using
> the right preprocessor flags
Using that version of SQLite, can you exec
On 22 Oct 2015, at 2:02pm, H?ctor Fiandor wrote:
> I have attached the unit because I don?t know what is the rules for this
> case.
Hector,
First, this mailing list doesn't allow attachments.
Second, since your problem is mostly to with Lazarus you would be better off
asking in a Lazarus for
On 22 Oct 2015, at 11:16am, gunnar wrote:
> It's good to know there are so many possibilities to repair when it is really
> needed!
But it's worth noting that these are only possibilities. There is no guarentee
of repair. And trying out one possibility can corrupt your database further so
Hi,
I am running sqlite3 v3.8.10 on an ARM Cortex-M4 based embedded system. The
minimal size I could achieve was 184 K. Do you really have 44.8 K? And how
much runtime RAM is used by your binary? My RAM usage is 72-74 K.
2015-10-22 10:51 GMT+02:00 Romain Crausaz :
> Dear,
>
> We have an embedded
> We carefully monitor the size of the compiled SQLite binary. A graph
> of that size is shown at
>
> https://www.sqlite.org/binary-size.jpg
>
> The 627.4KB for 3.8.11 is within reason, depending on what compiler
> you are using. But SQLite has *never* been as small as 44.8 KB. Is
> that a
> Can you reproduce the problem using the sqlite shell?
This won't be easy as the UDF is in an ActiveX dll, not in sqlite3.dlll
This is the output from explain, run on this SQL:
SELECT XXX(F1, F2) as A, XXX(F1, F2) as B FROM UDF_TEST limit 3
XXX will just add the results of the integer values of f
>> Can you reproduce the problem using the sqlite shell?
>This won't be easy as the UDF is in an ActiveX dll, not in sqlite3.dlll
>
>This is the output from explain, run on this SQL:
>SELECT XXX(F1, F2) as A, XXX(F1, F2) as B FROM UDF_TEST limit 3 XXX will just
>add the results of the integer va
Dear Mr. Simon:
First, thanks for learn to me that the list don?t admits attachments.
Second, I am not sure that my problem if only with lazarus, the error
messages appears when I try to copy a table to a transistory one, drop, and
recreate the same table, and after that copy from the transistory
Hi,
I am using Sqlite in a codebase shared between Windows and OS X and
specifically I am using FTS4 for searching our DB for free text strings. I have
just upgraded to the latest 3.9.1 and thought to give a try to FTS5, but
encountered an issue. It works fine on Windows, but on OS X the moment
Hi.
There was a ticket about uninformative error message on check constraint
failures -
http://www.sqlite.org/src/tktview/23b212820161c6599cbf414aa99bf8a5bfa5e7a3
(It's market as Fixed on 2014-03-11 in version 3.3.2).
But for foreign key we still have uninformative error messages - "FOREIGN
KEY co
Hi Paul, thanks!
It's good to know there are so many possibilities to repair when it is
really needed!
On 10/19/2015 10:21 PM, Paul Sanderson wrote:
> Gunnar
>
> If the data is very important then don't do anything that will change
> the computer.
>
> If you have sometools that can take an image
On 2015-10-22 11:01 AM, Marco Turco wrote:
> Hi all,
>
> I'm trying to generate the sqlite3 library but there is no way with
> Embercadero C++ 7.00.
>
> I always receive some warnings and the first two related to the
> _endthreadex' and '_beginthreadex' cannot permit to link me the library.
>
>
Hi all,
I'm trying to generate the sqlite3 library but there is no way with
Embercadero C++ 7.00.
I always receive some warnings and the first two related to the
_endthreadex' and '_beginthreadex' cannot permit to link me the library.
See below.
k:\BCC70\Bin\Bcc32.Exe -DHB_NO_DEFAULT_API_MA
Dear,
We have an embedded system using sqlite. I performed an update from
version 3.7.11 to 3.8.11 and was surprized that the binary file sqlite3
has grown from 44.8 KB to 627.4 KB. I used the same configuration
(default) for both cross-compilation.
The system has a limited amount of NAND memo
Dollars to donuts you're compiling SQLite but then linking against the
system version.
-scott
On Thu, Oct 22, 2015 at 7:51 AM, Gergely Lukacsy (glukacsy) <
glukacsy at cisco.com> wrote:
> Hi Simon,
>
> Thanks for coming back to me.
>
> I ran sqlite3_compileoption_get in a loop to enumerate all
Dear members:
I use Lazarus for applications and SQLite for BD?motors, in spanish
language.
I have the attached unit to re-build a BD table that fulfill some
conditions. I have found the way of a 2-phase to avoid an error message.
Please, if you have a solution to do this task in a 1 phas
I have an internal stocks management application that I rebuild from
time to time, usually against the latest SQLite version. After moving to
SQLite 3.9.1 it started reporting crazy stock values. Previously it was
compiled with SQLite 3.8.8.3. Further investigation showed that the last
usable S
Thanks for the report.
Can you also provide us with a test case that demonstrates the malfunction?
On 10/22/15, Catalin Ionescu wrote:
> I have an internal stocks management application that I rebuild from
> time to time, usually against the latest SQLite version. After moving to
> SQLite 3.9.1
I am using Embarcadero's development studio and compiling in the sqlite
amalgamation. You can just turn off those two warnings.
To turn it off for whole project:
Select the Projects menu Options
Under the C++ Compiler options select the warnings
Open the options for selected warnings.
scroll dow
On 10/22/15, Romain Crausaz wrote:
> Dear,
>
> We have an embedded system using sqlite. I performed an update from
> version 3.7.11 to 3.8.11 and was surprized that the binary file sqlite3
> has grown from 44.8 KB to 627.4 KB. I used the same configuration
> (default) for both cross-compilation.
45 matches
Mail list logo