Re: [sqlite] Static sqlite3 library for Linux

If you use the amalgamated source, there is only one file to be compiled. That can be as simple as: gcc -c sqlite3.c ar r libsqlite3.a sqlite3.o Any further dependencies are up to the linker. No need to worry about that. Regards, Arjen > -Original Message- > From:

Re: [sqlite] thousand separator for printing large numbers

> > > On 10 Feb 2017, at 1:25pm, Arjen Markus <arjen.mar...@deltares.nl> wrote: > > > Not entirely, in German-spoken countries the apostrophe (') is often used > > as a > thousands-separator. > > That's Switzerland, right ? Not a member of the EU. I didn't kn

Re: [sqlite] thousand separator for printing large numbers

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf > Of Simon Slavin > > Just to add to what Clemens wrote, you would at least need ways of doing > comma- > separation for thousands, dot-separation for thousands, and

[sqlite] TCL tests

quot;sqlite3_test_control_pending_byte" > while executing > "sqlite3_test_control_pending_byte 0x001" > (file "./tester.tcl" line 92) > invoked from within > "source $testdir/tester.tcl" > (file "attach.test" line 19) &g

[sqlite] TCL tests

Hi Sairam, That ought to be easy: tclsh name-of-test-file.test You will need an installation of Tcl, but these are easy to find. One place is at ActiveState's site, www.activestate.com/activetcl, but it may be that you already have it on your

Re: [sqlite] float to string conversion problem

Hi Richard, On Fri, 14 Jun 2013 08:26:19 -0400 Richard Hipp wrote: SQLite has its own printf() implementation. It has to. If it used system printf(), than certain LOCALE settings would turn "." into "," and introduce syntax errors. The build-in printf() of SQLite also

Re: [sqlite] float to string conversion problem

Hi Filipe, On Thu, 13 Jun 2013 15:59:35 +0100 Filipe Madureira wrote: Hi, I have a problem executing a query on a WinCE6 ARM device. I use SQlite for years and tested on all types of devices including WinCE6 ARM and never had a problem. But I have

Re: [sqlite] VC++ and SQLite

On Tue, 13 Nov 2012 09:51:01 -0500 Arbol One wrote: Following the advice of MSN: Open the project's Property Pages dialog box. For details, see Setting Visual C++ Project Properties. Click the C/C++ folder. Click the Advanced property page. Modify the Force Includes

Re: [sqlite] Tcl syntax help

Hi Shamil, yes, John's is more concise and better still, it works: my use of [list insert ...] caused the last element to be delimited by {} as it contains spaces. Regards, Arjen On 2011-12-08 05:06, Shamil F. Daghestani wrote: Thanks. It works even with my original list: set roads [list

Re: [sqlite] Tcl syntax help

Hi Shamil, I am not an expert in SQL, but how about: set sqlRoads {} foreach road $roads { lappend sqlRoads "'$road'" } db eval [list insert into myTable VALUES([join $sqlRoads ,])] That way, the values are properly formatted, delimited by single quotes and separated by commas. Regards,

Re: [sqlite] bug with sqlite

Hi, is this under Windows? con is one of the reserved file names, dating from the DOS days (or even before that). Other reserved names are aux, nul and prn (I think there is a fifth, but I cannot remember that one). So, that has nothing to do with SQLite itself. Regards, Arjen On 2011-03-28

Re: [sqlite] What languages can include SQLite statically?

Hi, On 2010-05-21 12:11, Jean-Denis Muys wrote: > Well the answer is: any language with an external interface to the C ABI can > link to the SQLite compiled C object code (on my planet they don't have .OBJ > nor .LIB extensions. Perhaps we are not on the same planet) to yield an > executable (I

Re: [sqlite] What languages can include SQLite statically?

Hi Gilles, I do not quite understand why this is important to you, but the answer is independent of SQLite itself - and it is a trifle complicated. You can add Fortran to the list below - either a static or a dynamic library will do fine. If you look at Tcl, the matter becomes more complicated:

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

How about SQLIteStudio? http://sqlitestudio.one.pl/index.rvt Regards, Arjen On 2009-10-23 12:54, Gilles Ganault wrote: > On Fri, 23 Oct 2009 11:13:05 +0100, "O'Neill, Owen" > wrote: >> http://sqlitebrowser.sourceforge.net/screenshots.html > > Thanks for the pointer. >

Re: [sqlite] New Book Available

Hello Rich, being a countryman of Rick's it was probably easier for me to spot the typo ;). Regards, Arjen On 2009-07-10 15:14, Rich Shepard wrote: > On Thu, 9 Jul 2009, Arjen Markus wrote: > >> there is a small typo there: Rick van der Lans (just one "a") > >

Re: [sqlite] New Book Available

Hi, there is a small typo there: Rick van der Lans (just one "a") The 4th edition did not show up yet ... Regards, Arjen On 2009-07-09 15:50, cmar...@unc.edu wrote: > On Thu, 9 Jul 2009, Rich Shepard wrote: > >> Rick van der Laans, who wrote the excellent "Introduction to SQL, 4th Ed." >>

Re: [sqlite] how to build TCL testing environment

Hello, you can either install a Tcl distribution like ActiveState's (www.activestate.com) or use a tclkit - a standalone Tcl executable (see: http://code.google.com/p/tclkit/) Regards, Arjen On 2009-06-15 08:27, ??? wrote: > Hello,Everyone > I just have a project based on SQLite.For some

Re: [sqlite] "parameters are not allowed in views"

ou can get rid of most threats, right? Regards, Arjen On 2009-02-27 16:01, Alexey Pechnikov wrote: > Hello! > > On Friday 27 February 2009 17:32:36 Arjen Markus wrote: >> This is the Tcl binding, right? >> You could replace the variable by its value using [string map

Re: [sqlite] "parameters are not allowed in views"

This is the Tcl binding, right? You could replace the variable by its value using [string map]: db eval [string map [list USER_ID $user_id ...] $sql_statement] or more directly: db eval \ "CREATE TABLE view_report_01 AS ... WHERE u.id = $user_id ..." Regards, Arjen On

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Shane Harrelson wrote: > >It wasn't a loss of precision, it was mearly a display issue. The Windows >ActiveTCL 8.5 >distribution might display the floating point value as "5.4e-018" while the >"unix" >TCL 8.5 version would display "5.4e-18" (or something similar). There's >probably >an option

Re: [sqlite] Static embedding sqlite and compiling in gcc

icantthinkofone wrote: >I lost my note on what I did to make this work. I've rearranged my >computers for work and installed sqlite3 on Ubuntu. When I installed >sqlite3, I did ./configure --disable-shared. When I recompile my working >code on the new machine: >gcc -static -L/usr/local/lib

Re: [sqlite] GCC -ffast-math safe version of sqlite3IsNaN

Brown, Daniel wrote: >Unfortunately our build system is automated and not particularly agile, it can >be done but it would be preferred not to have to do that and to replace the >offending function instead but I've never had to write a IsNaN test. > > > I had a look at the sourcecode for

Re: [sqlite] Lemon

> Hi, > Can u send me any documentation on LEMON that u have worked out. > I have some queries also. > 1.Does LEMON work on Windows environment? > 2.I tried but it is not.I heard that it works on Linux environment.I am > trying to know why not on windows...can u give me some info about it > >

Re: [sqlite] Lemon

arjunkumar keerti wrote: >Hi, >I found in wikipedia that Lemon parser is a part of SQLite project but i >couldn't found any sort of information regarding to LEMON. >Can u give me any documentation regarding how to install it and how to work >for some programs on Lemon parser generator or any

Re: [sqlite] Writing double into a socket file

> I am going to guess yes. > > On Mon, Jun 9, 2008 at 9:58 PM, Russell Leighton > <[EMAIL PROTECTED]> > wrote: > >> >> Aren' t there aligment and endian issues as well as potential floating >> point representations between platforms? >> As most computers nowadays use the IEEE standard to

Re: [sqlite] Re: select round(98926650.50001, 1) ?

Doug Currie wrote: I suspect the bug is in the functions that convert between string and double; that's why I keep harping on Steele and White's (and Clinger's) PLDI 1990 papers. What I don't know is why this bug appears in the binary from sqlite.org but not in the version I build myself with

Re: [sqlite] Re: select round(98926650.50001, 1) ?

Serena Lien wrote: Okay, but even if the rounded result does not have a finite binary representation, shouldn't the displayed (human readable) representation be at least truncated to the number of decimal places that were requested in the round function? Not that I am confusing round with

Re: [sqlite] Re: select round(98926650.50001, 1) ?

Serena Lien wrote: I have read some of the postings/faq about the difficulties with the round function, when certain numbers do not have a finite representation in binary, which SQLite uses. eg 9.95 is actually 9.9499...etc so that round( 9.95, 1) rounds down. But, I have found several numbers

Re: [sqlite] Sqlite 14 (cant open database)

Lloyd wrote: This error occurs only on FAT 32 file system! I have a directory with 32764 files. one of the file is my sqlite database. It seems that, when the file count reaches around this particular no. the SQLite cant open database error occurs. Can anybody give me some hint? (I am mounting

Re: [sqlite] TCL Binding with VC6

yazan wasfi wrote: Hi All, I'm trying to compile sqlite with TCL enabled under VC6, Ive installed ActiveTCL8.4, and Added the include, lib, bin, to my VC6 project, when compiling the sqlite, I dont get any errors, but when trying to link it I get 49 errors like this Linking... tclsqlite.obj

Re: [sqlite] Fortran 95 Language Bindings

Liam Healy wrote: Arjen, Thank you for attentive maintenance and development on this valuable interface. Thanks, Gary's and your interest in a Fortran wrapper were enough to revive my activities in this area. With the documentation (almost) completed, I guess it is time to add the link to

Re: [sqlite] Fortran 95 Language Bindings

Liam Healy wrote: Arjen, I've taken another look at these bindings, and at my project. For a variety of reasons, most not related to the sqlite3 Fortran bindings, I have decided to proceed in a different direction. However, on closer examination of the Fortran bindings and other language

Re: [sqlite] Fortran 95 Language Bindings

Liam Healy wrote: Arjen, I've taken another look at these bindings, and at my project. For a variety of reasons, most not related to the sqlite3 Fortran bindings, I have decided to proceed in a different direction. However, on closer examination of the Fortran bindings and other language

Re: [sqlite] Fortran 95 Language Bindings

Gary Scott wrote: Hi, CVF initially. I will likely transition to IVF once a suitable version is released. Well, that should be easy enough - MSVC/CVF is the platform I used to develop the interface. I managed to extend the documentation on the interface last night - see

Re: [sqlite] Fortran 95 Language Bindings

Gary Scott wrote: I do not possess a C compiler, so I will need an all-Fortran solution, unless the C interface is provided as a compiled binary. What Fortran compiler do you prefer? I can supply a precompiled C library that should be suitable for a number of Fortran compilers (CVF, IVF on

Re: [sqlite] Fortran 95 Language Bindings

Gary Scott wrote: Liam Healy wrote: I am very interested in this for a project of increasing urgency. A few months ago I found the two links that the other emails mentioned, but found both of them inadequate and not well documented. I think a complete, documented F95 API would be very

Re: [sqlite] Fortran 95 Language Bindings

> Hi, this is my first post, so please excuse any etiquette goofs. I'm > researching incorporation of SQLite into a project. It would appear > relatively straightforward to develop an F95 language binding, however > it is likely to be compiler specific (extensions required to adapt > calling

Re: [sqlite] serious performance problems with indexes

Peter De Rijk wrote: I have run into a serious performance problem with tables with many rows. The problem only occurs on tables with an index The time needed for an insert into a table with an index is dependend on the number of rows. I have not formally checked, but from my tests it looks

Re: [sqlite] Compiling Sqlite with Openwatcom

[EMAIL PROTECTED] wrote: Hi Arjen Unfortunately I am still using f77 not f90... Hello Victor, any specific reason? There are lots of (free) Fortran 90 compilers around, and unless I am mistaken the Openwatcom compiler supports Fortran 90 (after all, the standard is more than 20 years

Re: [sqlite] Compiling Sqlite with Openwatcom

[EMAIL PROTECTED] wrote: Hi All, I wonder whether anyone has already compiled Sqlite with Openwatcom (a free compiler suite available at www.openwatcom.org including a C/C++/Fortran compiler). Since when I tried, I got the following compiling error on line 95 of the file sqlite3ext.h: invalid

Re: [sqlite] Re: SQLite Order BY

A. Pagaltzis wrote: * John Stanton <[EMAIL PROTECTED]> [2006-10-09 19:35]: Sorting data is time consuming, a physical law is involved. At best it is an nlog(n) process. Only when you sort by comparing elements with each other. Bucket sort runs in O(n), f.ex. And quantum sort is O(1).

Re: [sqlite] Wiki is locked

[EMAIL PROTECTED] wrote: Whatever Everything appears to be working now. Yes, I can see the contents now. As we are on the subject of documentation, someone on the Tclers' chat mentioned that the subcommand "exists" is documented, but not actually implemented. Could you have a look at

[sqlite] Wiki is locked

Hello, I tried to access the SQLite Wiki this morning (MET 8:30), but all I got was a reply that the query failed because the database was locked. Can somebody (Richard Hipp most probably) look into this? Regards, Arjen

Re: [sqlite] Using Between in SQL

Roger wrote: On Wed, 2006-08-30 at 12:03 +0100, Martin Jenkins wrote: Roger wrote: I have a question. I trying to write a query as follows Select * From People Where Surname Between 'A%' and 'E%' Order by UPPER(Surname); Now the problem i have is that i get only the Surnames from

Re: [sqlite] Using Between in SQL

Roger wrote: I have a question. I trying to write a query as follows Select * From People Where Surname Between 'A%' and 'E%' Order by UPPER(Surname); Now the problem i have is that i get only the Surnames from A up to D and the E's are excluded. Can anyone help me out, i am writing a web

[sqlite] Article on common errors in SQL queries

Hello, I came across the article below and thought this might interest at least some people on this list. Regards, Arjen -- Title: Semantic errors in SQL queries: A quite complete list Authors: Brass, S; Goldberg, C Source: JOURNAL OF SYSTEMS AND

Re: [sqlite] SQLITE3.exe from Windows CMD

Josef Hlawatschek (JT) wrote: Hi, I want to use SQLITE3.EXE to run automated reports in Windows. I use an init file to load parameters and a SQL script file. All goes well until the SQL script has been executed, then the SQLITE3.EXE command prompt appears. The command prompt only closes once

Re: [sqlite] Table question

Eugen Stoianovici wrote: Is there a way o creating tables that have fields that are expressions rather than values? Those expresions would return a value based on values stored in other fields of some other table (or the same table if that's necessary). If the expressions do not vary per

Re: [sqlite] feild value pairs

chetana bhargav wrote: > > Hi, > > My requirement is that, I want to store some common properties and some > more optional properties depending on the need of each application. Where > these optional properties need to be stored as feild value pairs. Most of the > values(almost 99.5%)

Re: [sqlite] Versioning in SQL database?

Paul Tomblin wrote: > > I am putting together something that will act like a Wiki for structured > data (in this case, airport and navigation aid data like id, location, > runways, etc). I currently store the data in an SQL databasee, but only > the "current" version. I want to allow people to

Re: [sqlite] Decimal separator

Carl Jacobs wrote: > > > > All would be fine but look at this : > > > > > > create table test( > > > price double, > > > amount double default 0 > > > ); > > > > > > insert into test(price) values("12,0"); > > > > > > amount now = 0.0 > > The world seems to have settled on using Arabic numerals

Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

Lloyd Thomas wrote: > > Thanks Kimball > Your right about having a little experience. I am > just running into error after error installing apps, but I'm learnoing > slowly. Anyway, I was trying to install the sqlite support for another > application I want to use and as a

Re: [sqlite] Building sqlite 3.2.8 on redhat 9

Lloyd Thomas wrote: > > I have compilted tcl, but had a problem with tk. having compiled sqlite3 I > get a new error trying to run sqlite3 = > 'sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open > shared object file: No such file or diretory' > That seems a common

Re: [sqlite] Problem with floating point fields, and a feature request

Cariotoglou Mike wrote: > > I see again that you all miss the point. I DO know how to handle floating > point. My point is : > ... > > since a solution to this issue is fairly simple, and the applicable audience > is large, why not provide one? > the fact that MSSQL will not be able to do the

Re: [sqlite] Problem with floating point fields, and a feature request

Cariotoglou Mike wrote: > > as you may remember, some time ago I raised an issue with floating point > accuracy, and how this may affect sqlite. > > I now have a concrete example, which actually happened in an > installation, and helps to demonstrate the severity of the issue: > > try this

Re: [sqlite] equivalent of linked tables in sqlite ?

gl demoor wrote: > > I did some preliminary and extensive reseach (cough google cough :) on > delphi and pocketpc > > unless I'm missing something, delphi is not use for pocketpc programming > > google results were of the following nature: > >I'm pretty sure no one supports *Delphi* for *Pocket

Re: [sqlite] how can I import CSV file into SQLite quickly

Aaron Peterson wrote: > > On 12/7/05, Teg <[EMAIL PROTECTED]> wrote: > > Hello All, > > > > Wouldn't it make sense to write a program that reads it in, one line > > at a time, splits and inserts the data into the proper tables? Even > > creating the table on the fly? That's what I'd do, a little

Re: [sqlite] sqlite and cygwin

Oliver Manthey wrote: > > hello, > > i'm new to sqlite and want to use it in a windows xp/cygwin/eclipse > environment. > > is there any documentation how to install sqlite into cygwin ? > > looking forward, > oliver You should be able to do that via the instructions for Linux, as the Cygwin

Re: [sqlite] Compiling from source code on Windows

Ran wrote: > > It will be great if you can send me the .dsp and .dsw files. > About preparing the files - I prefer to do this on Linux as D. Richard Hipp > suggested because I will anyway continue the development of my part on > Linux. > Hello Ran, I replied before I saw that Richard had

Re: [sqlite] optimizing out function calls

Jay Sprenkle wrote: > > On 11/14/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Original Message > > > Subject: Re: [sqlite] optimizing out function calls > > > From: Jay Sprenkle <[EMAIL PROTECTED]> > > > Date: Mon, November 14, 2005 4:34 pm > > > To:

Re: [sqlite] optimizing out function calls

Joe Wilson wrote: > > What do other databases return for the types of SQL queries below? > > SELECT random(1) AS func FROM test ORDER BY func; > SELECT random() AS func FROM test WHERE func > 10; > > MS Access appears to assume all functions called with the same > arguments are constant and

Re: [sqlite] Re: converting a mysql database

Dave Dyer wrote: > > I looked into this, and the actual problem is windows returning > a "access denied" error code when trying to recreate the journal > file immediately after deleting it. I can't find any documentation > that says create might fail for this reason, but filemon (from >

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

Fred Williams wrote: > > Well, since you put it that way. May I go one step farther and request > that this new Dynamic Type also adhere to "Bankers Rounding" commonly > implemented as BCD in other so equipped databases. > > For years I have spent countless hours testing and sweating rounding

Re: [sqlite] Error code 25

Hannes Ricklefs wrote: > > Hi, > > does anyone know what error code 25 stands for I can't find it in the > documentation! It occurs in relation to binding values to a prepared > statement. > > THanks, > Hannes You can find all codes in the sqlite.h include file: #define SQLITE_RANGE 25

[sqlite] Handling dates and timestamps via the C API

Hello, I would like to know how I should handle dates and timestamps via the C API. I know that if I write an SQL insert statement, I have to use one of the forms reserved for dates and timestamps and the like, but how do I do this via the sqlite3_bind_* procedures? Regards, Arjen

Re: [sqlite] Dotnet C# support

Robert Simpson wrote: > > That's exactly what I ended up doing in the ADO.NET 2.0 wrapper. In order > to implement full Compact Framework support and callbacks, I ended up > writing stdcall entrypoints and callback wrappers for just about the entire > SQLite API. > My Fortran interface does

Re: [sqlite] Dotnet C# support

Robert Simpson wrote: > > > Lots of problems here ... My VB is rusty, but here goes: > > 1. Don't bother declaring the callback struct -- you cannot do any form of > callbacks in .NET with SQLite without major hacking. SQLite's callbacks are > expected to be "cdecl" and .NET callbacks are

Re: [sqlite] Re: begin transaction and commit

Igor Tandetnik wrote: > > > > There is another reason that is more or less specific to SQLite: a batch > of data manipulation (insert, update and delete) statements completes > much faster when all statements are executed under a single transaction. > > > I understeand that if I use them, and

Re: [sqlite] FYI: Fortran interface to SQLite

Hamid Benhocine wrote: > > Hello, > Very interesting, I planned to do some work (not done yet) to > provide my division with some examples using sqlite with fortran 90/95 > (to replace a home pivot format in numerical computing : we use f90/95). > So, if you have a release, you want to share, I

Re: [sqlite] getting only count of records

Wilfried Mestdagh wrote: > > Hi Arjen, > > AM> No, they will probably not all do the same internally: the result > AM> may be the same, but the "virtual machine" that runs the SQL statements > AM> will very probably do different things - this depends on optimisation > AM> and so on. But for most

Re: [sqlite] sqlite on SunOS 5.6 (Solaris Sparc 6)

[EMAIL PROTECTED] wrote: > > Has anyone sucessfully built sqlite 3.2.7 on a SunOS 5.6 (Solaris > sparc 6) box? > > I had no problems with sqlite 2, but can't seem to get sqlite3 to > build. > > Using the ./configure ; make route, it dies with: > > ./lemon -DSQLITE_OMIT_CURSOR parse.y

[sqlite] FYI: Fortran interface to SQLite

Hello, my (almost) first experience with SQLite was the sample code that Al Danial published to show how to use SQLite in a FORTRAN program. I was inspired by his work to develop a more comprehensive interface, this time in Fortran 90/95. I am pleased to say that this was fairly easy to do and

Re: [sqlite] Zip file with prebuilt DLL incomplete

Cory Nelson wrote: > > Indeed it should probably include sqlite3.h, but you are supposed to > generate an import .lib for your compiler using the .def file. VC++ comes > with lib.exe, I'm not sure how you do it with others. > > I know that the GNU compilers have a similar utility - I just have

[sqlite] Zip file with prebuilt DLL incomplete

, but it is more common to use the import library. But even so, the sqlite3.h header file is missing. So the zip-file as such is not useable. Kind regards, Arjen Markus