[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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

[sqlite] Database corrupt after hard reboot. Can it be repaired?

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

[sqlite] SELECT SUM(...) FROM ... WHERE regression in 3.8.11

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

[sqlite] sqlite 3.8.11 - binary size

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

[sqlite] sqlite 3.8.11 - binary size

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.

[sqlite] sqlite 3.8.11 - binary size

> 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

[sqlite] sqlite 3.8.11 - binary size

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

[sqlite] SELECT SUM(...) FROM ... WHERE regression in 3.8.11

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

[sqlite] from hfiandor about a unit in spanish

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

[sqlite] Problem with sqlite3_create_function

> 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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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:

[sqlite] Database corrupt after hard reboot. Can it be repaired?

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

[sqlite] from hfiandor about a unit in spanish

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

[sqlite] FTS5 issue on OS X

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

[sqlite] SQLite C# Windows Store Apps

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

[sqlite] FTS5 issue on OS X

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

[sqlite] Problem with sqlite3_create_function

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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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

[sqlite] Problem with sqlite3_create_function

> 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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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:

[sqlite] FTS5 issue on OS X

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

[sqlite] Database corrupt after hard reboot. Can it be repaired?

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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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

[sqlite] FTS5 issue on OS X

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

[sqlite] FTS5 issue on OS X

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

[sqlite] Uninformative error message on foreign key violation

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

[sqlite] SELECT SUM(...) FROM ... WHERE regression in 3.8.11

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

[sqlite] from hfiandor about a unit in spanish

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

[sqlite] from hfiandor about a unit in spanish

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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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

[sqlite] Result of sqlite3_errmsg when there is no error

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

[sqlite] Simple Math Question

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

[sqlite] Simple Math Question

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

[sqlite] Simple Math Question

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

[sqlite] Problems making sqlite.lib using Embarcadero C++ 7.00

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

[sqlite] Simple Math Question

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.

[sqlite] Simple Math Question

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

[sqlite] Simple Math Question

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.

[sqlite] Simple Math Question

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, ...>

[sqlite] Simple Math Question

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

[sqlite] Simple Math Question

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,

[sqlite] Simple Math Question

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