Re: [sqlite] Problems loading extensions on Windows 10

le > To: sqlite-users@mailinglists.sqlite.org < > sqlite-users@mailinglists.sqlite.org> > Sent: Tuesday, March 5, 2019, 23:30:35 > Subject: [sqlite] Problems loading extensions on Windows 10 > > I am having problems loading sqlite3 extensions on Windows 10. > > I have downloaded bot

Re: [sqlite] Problems loading extensions on Windows 10

Are both of the same architecture, either 32bit or 64bit? - Original Message - From: Kyle To: sqlite-users@mailinglists.sqlite.org Sent: Tuesday, March 5, 2019, 23:30:35 Subject: [sqlite] Problems loading extensions on Windows 10 I am having problems loading sqlite3 extensions on

Re: [sqlite] Problems loading extensions on Windows 10

On Tue, Mar 5, 2019 at 2:30 PM Kyle wrote: > I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and > copied them to C:\Windows\System32. > > When I run > SELECT load_extension('mod_spatialite') > sqlite returns "Error: the specified module could not be found" Helpfully, on

[sqlite] Problems loading extensions on Windows 10

I am having problems loading sqlite3 extensions on Windows 10. I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and copied them to C:\Windows\System32. When I run SELECT load_extension('mod_spatialite') sqlite returns "Error: the specified module could not be found" I ha

Re: [sqlite] Problems with compiling SQLite for MUSL.

On Sun, 02 Sep 2018 22:25:16 -0600 "Keith Medcalf" wrote: > Interesting ... Sounds like the optimizer in the compiler is broken ... > unless someone has ideas about how to debug this. Can you compile with no > optimization and SQLITE_DEBUG defined and see what happens? Though, to me it > sou

Re: [sqlite] Problems with compiling SQLite for MUSL.

On Sunday, 2 September, 2018 20:32, John Found wrote: >On Sun, 02 Sep 2018 14:18:50 -0600 "Keith Medcalf" wrote: >> This is a compiler issue and has nothing to do with SQLite3. >>Anything you compiled using that compiler would exhibit the same >>problems ... >Well, I was almost sure, but as l

Re: [sqlite] Problems with compiling SQLite for MUSL.

On Sun, 02 Sep 2018 14:18:50 -0600 "Keith Medcalf" wrote: > > This is a compiler issue and has nothing to do with SQLite3. Anything you > compiled using that compiler would exhibit the same problems ... Well, I was almost sure, but as long as here I can find people understanding gcc and I am

Re: [sqlite] Problems with compiling SQLite for MUSL.

nticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of John Found >Sent: Sunday, 2 September, 2018 12:18 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Problems with compiling SQLit

[sqlite] Problems with compiling SQLite for MUSL.

I am trying to compile SQLite with 32bit MUSL, but probably mess some compiler options. The command I am using is: musl-gcc -O3 -shared -fno-stack-protector -DSQLITE_DEFAULT_MEMSTATUS=0 -DSQLITE_LIKE_DOESNT_MATCH_BLOBS -DSQLITE_MAX_EXPR_DEPTH=0 -DSQLITE_OMIT_DEPRECATED -D SQLITE_OMIT_PROGRESS

Re: [sqlite] Problems compiling FTS5 extension

Thanks for the tips! Don't know about the segfault too but can ignore it for now — this same file works well with the GUI app and with my Node.js program. On Thu, Oct 19, 2017 at 6:38 PM Dan Kennedy wrote: > On 10/19/2017 08:40 PM, Eugene Mirotin wrote: > > Hm, I think that's because the extens

Re: [sqlite] Problems compiling FTS5 extension

On 10/19/2017 08:40 PM, Eugene Mirotin wrote: Hm, I think that's because the extension is already preloaded with my version if sqlite. Which means I didn't even have to build it :) But now is the question how would I reliably load / not load it in production env if the target user may or may not

Re: [sqlite] Problems compiling FTS5 extension

Hm, I think that's because the extension is already preloaded with my version if sqlite. Which means I didn't even have to build it :) But now is the question how would I reliably load / not load it in production env if the target user may or may not have sqlite precompiled with it? On Thu, Oct 19

Re: [sqlite] Problems compiling FTS5 extension

Well, now I have troubles loading this extension. I've built another one before, fts5stemmer. When using the CLI sqlite3 (version 3.20.1 from MacPorts): ❯ sqlite3 SQLite version 3.20.1 2017-08-24 16:21:36 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILE

Re: [sqlite] Problems compiling FTS5 extension

Thanks a lot Dan, that worked! I'm fine with the trunk version for now but hope to see this in stable eventually as I'll have to later build this extension for various platforms for the release of my app. Thanks again for the quick fix On Wed, Oct 18, 2017 at 6:06 PM Dan Kennedy wrote: > On 10/1

Re: [sqlite] Problems compiling FTS5 extension

On 10/18/2017 06:32 PM, Eugene Mirotin wrote: In short the error I get is fts5_storage.c:305:9: error: 'sqlite3_api_routines' has no member named '__builtin___snprintf_chk' More details in SO question here: https://stackoverflow.com/questions/46793988/sqlite-trouble-building-fts5-loadable-extens

[sqlite] Problems compiling FTS5 extension

In short the error I get is fts5_storage.c:305:9: error: 'sqlite3_api_routines' has no member named '__builtin___snprintf_chk' More details in SO question here: https://stackoverflow.com/questions/46793988/sqlite-trouble-building-fts5-loadable-extension, please let me know if I should paste everyt

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

On Tue, Oct 27, 2015 at 11:05 PM, James K. Lowden wrote: > On Tue, 27 Oct 2015 12:24:03 +0100 Clemens Ladisch > wrote: > > > You've solved the problem by compiling for a > single-threaded environment. > > No; the single-threaded environment is the problem. > > That's a matter of opinion. Anothe

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

On Tue, 27 Oct 2015 12:24:03 +0100 Clemens Ladisch wrote: > > You've solved the problem by compiling for a single-threaded > > environment. > > No; the single-threaded environment is the problem. That's a matter of opinion. Another way to look at it: threads set back computing by 20 years.

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

James K. Lowden wrote: > On Thu, 22 Oct 2015 15:23:38 +0200 > "Marco Turco" wrote: >> 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. > > You've solved the problem by compiling fo

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

On Thu, 22 Oct 2015 15:23:38 +0200 "Marco Turco" wrote: > 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. You've solved the problem by compiling for a single-threaded environment.

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

Ladisch Sent: Thursday, October 22, 2015 8:51 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [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'

[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] Problems making sqlite.lib using Embarcadero C++ 7.00

: sqlite-users at mailinglists.sqlite.org Subject: Re: [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 t

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

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

2015 12:12 PM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [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.

[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] 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 -DHB_NO_DEFAULT_API_MA

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

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

Thanks. Works great! Thanks. From: Richard Hipp Sent: Wednesday, October 14, 2015 5:37 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located On 10/14/15, jose isaias cabrera wrote: > -Origi

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On 10/14/15, jose isaias cabrera wrote: > -Original Message- > From: Random Coder > Sent: Wednesday, October 14, 2015 2:17 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize > could not be located

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

-Original Message- From: Random Coder Sent: Wednesday, October 14, 2015 2:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera wrote: > &

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On 10/14/15, Random Coder wrote: > > There appears to be a problem with the officially provided DLL. It > only has sqlite3_json_init exported in the DLL. > Confirmed. And yet the reason for that is still a complete mystery to us SQLite developers. We are trying to figure out why the DLL build

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize couldnot be located

: Wednesday, October 14, 2015 12:55 PM To: sqlite-users at mailinglists.sqlite.org Subject: [sqlite] Problems with v3.9.0: entry point sqlite3_finalize couldnot be located Greetings. I just downloaded the provided Windows DLL version from the download site, v3.9.0, and when I run my program, I get &quo

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

Greetings. I just downloaded the provided Windows DLL version from the download site, v3.9.0, and when I run my program, I get "The procedure entry point sqlite3_finalize could not be located in the dynamic link library SQLITE3.DLL." and the program aborts. I had to go back to v3.8.11.1 to m

[sqlite] Problems with v3.9.0: entry point sqlite3_finalize could not be located

On Wed, Oct 14, 2015 at 9:55 AM, jose isaias cabrera wrote: > "The procedure entry point sqlite3_finalize could not be located in the > dynamic link library SQLITE3.DLL." > > and the program aborts. I had to go back to v3.8.11.1 to make the program > work again. Any thoughts? I thought that thi

[sqlite] Problems in reading a record containing a blob

On Wed, 17 Jun 2015 16:59:02 +, Sivananda Nyayapathi wrote: > I have created a table to store images. The columns are > file name and file content. FileContent field is the blob. > I am using Samsung Tablet with Android Version 4.4.2. > Most of the tablets that I tested the software in, it

[sqlite] Problems in reading a record containing a blob

On 17 Jun 2015, at 5:59pm, Sivananda Nyayapathi wrote: > I am able to store the image in the blob field. However, while attempting to > read, I get the following error two times (as seen in the LogCat entries): > > W/CursorWindow(26737): Window is full: requested allocation 3184896 bytes, >

[sqlite] Problems in reading a record containing a blob

I have created a table to store images. The columns are file name and file content. FileContent field is the blob. I am using Samsung Tablet with Android Version 4.4.2. Most of the tablets that I tested the software in, it works fine. However, on one specific Android table I am having proble

[sqlite] Problems with pragma journal_mode

-boun...@mailinglists.sqlite.org] On Behalf Of Janke, Julian Sent: Mittwoch, 22. April 2015 13:13 To: ambrus at math.bme.hu; General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode Thank you for the hint. I'll check that. -Original Message- From: s

[sqlite] Problems with pragma journal_mode

, 22. April 2015 12:59 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 4/22/15, Janke, Julian wrote: > The embedded system has various storage media, with different read / > write speeds. > A quick and dirty test shows that the outso

[sqlite] Problems with pragma journal_mode

t: Re: [sqlite] Problems with pragma journal_mode On Wed, Apr 22, 2015 at 10:46 AM, Janke, Julian wrote: > I have tested some of the other pragmas and none worked. After > discussing with you now I come to the conclusion that the problem is > caused more by my local setup. I In that case,

[sqlite] Problems with pragma journal_mode

On Wed, Apr 22, 2015 at 10:46 AM, Janke, Julian wrote: > I have tested some of the other pragmas and none worked. After discussing > with you now I come to the conclusion that the problem is caused more by my > local setup. I In that case, as you have a custom vfs, could you check if it's your

[sqlite] Problems with pragma journal_mode

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Montag, 20. April 2015 16:32 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode If the compile-time options you have shown are complete, then the PRAGMA command ought to be

[sqlite] Problems with pragma journal_mode

On 4/22/15, Janke, Julian wrote: > The embedded system has various storage media, with different read / write > speeds. > A quick and dirty test shows that the outsourcing of the journal files on a > faster medium may be a significant speed boost. > Is there a possibility to write journal(temporar

[sqlite] Problems with pragma journal_mode

On 4/22/15, Zsb?n Ambrus wrote: > > In that case, as you have a custom vfs, could you check if it's your > vfs that is handling those pragmas? The documentation at > "http://sqlite.org/c3ref/c_fcntl_busyhandler.html#sqlitefcntlpragma"; > describes that when you run a PRAGMA statement on a databas

[sqlite] Problems with pragma journal_mode

te.org] On Behalf Of Richard Hipp Sent: Montag, 20. April 2015 15:55 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 4/20/15, Janke, Julian wrote: > > PRAGMA compile_options; shows 0 This makes me think that the list of compile-time optio

[sqlite] Problems with pragma journal_mode

Sent: Montag, 20. April 2015 12:18 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 4/20/15, Janke, Julian wrote: > 'EXPLAIN PRAGMA journal_mode=WAL' returns 2 rows > > 0: 0 Init 0 0 0 > 1: 1 Halt 0 0 0 > You shoul

[sqlite] Problems with pragma journal_mode

org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard > Hipp > Sent: Montag, 20. April 2015 15:55 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Problems with pragma journal_mode > > On 4/20/15, Janke, Julian wrote:

[sqlite] Problems with pragma journal_mode

g > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard > Hipp > Sent: Montag, 20. April 2015 12:18 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Problems with pragma journal_mode > > On 4/20/15, Janke, Julian wrote: >> &#x

[sqlite] Problems with pragma journal_mode

Hipp Sent: Freitag, 17. April 2015 16:59 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 4/17/15, Janke, Julian wrote: > Hello, > Thanks for your reply. > > I changed my code again: > > 1) rc = sqlite3_open(dbPath, &db); -->

[sqlite] Problems with pragma journal_mode

, 17. April 2015 16:59 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Problems with pragma journal_mode > > On 4/17/15, Janke, Julian wrote: >> Hello, >> Thanks for your reply. >> >> I changed my code again: >> >> 1) rc = sqlite3_open(db

[sqlite] Problems with pragma journal_mode

On Fri, Apr 17, 2015 at 12:59 PM, Janke, Julian wrote: > Unfortunately, I can't run the shell tool on the es and try the same > sequence of commands. > Why? Don't you have some kind of shell on that embedded system that can run executables? According to https://www.sqlite.org/howtocompile.html,

[sqlite] Problems with pragma journal_mode

es at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Dominique Devienne Sent: Freitag, 17. April 2015 13:50 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On Fri, Apr 17, 2015 at 12:59 PM, Janke, Julian

[sqlite] Problems with pragma journal_mode

On 17 Apr 2015, at 11:59am, Janke, Julian wrote: > I've changed the stmt to "SELECT 'Hello World !!';" > In this case, > > sqlite3_step() returns SQLITE_ROW > sqlite3_column_text() returns 'Hello World !!' > > That, looks right. I agree. And it shows that your C code is working perfectly. F

[sqlite] Problems with pragma journal_mode

On 17 Apr 2015, at 11:12am, Janke, Julian wrote: > I changed my code again: Move the DROP TABLE command on line 5 to after the _finalize() call. But I don't think it'll make any difference. You should not be getting SQLITE_DONE back from your call to _step(). The documentation says that th

[sqlite] Problems with pragma journal_mode

General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 17 Apr 2015, at 11:12am, Janke, Julian wrote: > I changed my code again: Move the DROP TABLE command on line 5 to after the _finalize() call. But I don't think it'll make any differe

[sqlite] Problems with pragma journal_mode

Thanks for your help > > > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Simon > Slavin > Sent: Donnerstag, 16. April 2015 17:56 > To: General Discussion of SQL

[sqlite] Problems with pragma journal_mode

ent: Donnerstag, 16. April 2015 17:56 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 16 Apr 2015, at 2:33pm, Janke, Julian wrote: > rc = sqlite3_step(stmt); > --> returns SQLITE_DONE After the above two lines, print the value

[sqlite] Problems with pragma journal_mode

On 16 Apr 2015, at 2:33pm, Janke, Julian wrote: > rc = sqlite3_step(stmt); > --> returns SQLITE_DONE After the above two lines, print the value returned by sqlite3_column_text(stmt, 0) I'm not good at C off the top of my head but I think it's something like - const unsigned

[sqlite] Problems with pragma journal_mode

ehalf Of Simon Slavin Sent: Donnerstag, 16. April 2015 14:15 To: General Discussion of SQLite Database Subject: Re: [sqlite] Problems with pragma journal_mode On 16 Apr 2015, at 10:10am, Janke, Julian wrote: > rc = sqlite3_open(dbPath, &db); > rc = sqlite3_exec(db, "PRAGMA jour

[sqlite] Problems with pragma journal_mode

On 16 Apr 2015, at 10:10am, Janke, Julian wrote: > rc = sqlite3_open(dbPath, &db); > rc = sqlite3_exec(db, "PRAGMA journal_mode=WAL;", testCallbackPrint, 0, > &zErrMsg); > [?] > sqlite3_close(db); Execute your PRAGMA as if it's a SELECT call (i.e. use sqlite3_prepare_v2(), sqlite3_step(), and

[sqlite] Problems with pragma journal_mode

Janke, Julian wrote: > PRAGMA journal_mode=WAL; > > Unfortunately, after these lines, the journal mode is not changed. > > -DSQLITE_OS_OTHER=1 Do you have mmap support? says: | WAL normally requires that the VFS support shared-memory primitives. | The built-in uni

[sqlite] Problems with pragma journal_mode

On Thu, Apr 16, 2015 at 11:10 AM, Janke, Julian wrote: > I want to change the journal mode of a database to WAL. So I did the > following: > > rc = sqlite3_open(dbPath, &db); > rc = sqlite3_exec(db, "PRAGMA journal_mode=WAL;", testCallbackPrint, 0, > &zErrMsg); > [?] > sqlite3_close(db); > > Unfo

[sqlite] Problems with pragma journal_mode

On 16 April 2015 at 10:10, Janke, Julian wrote: > Hi everyone, > > I'm relatively new to SQLite and currently I'm experimenting a little bit > with the SQLite database on an embedded system. > I want to change the journal mode of a database to WAL. So I did the > following: > > rc = sqlite3_open

[sqlite] Problems with pragma journal_mode

April 2015 11:23 To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] Problems with pragma journal_mode Janke, Julian wrote: > PRAGMA journal_mode=WAL; > > Unfortunately, after these lines, the journal mode is not changed. > > -DSQLITE_OS_OTHER=1 Do you have mmap sup

[sqlite] Problems with pragma journal_mode

ubject: Re: [sqlite] Problems with pragma journal_mode On 16 April 2015 at 10:10, Janke, Julian wrote: > Hi everyone, > > I'm relatively new to SQLite and currently I'm experimenting a little bit > with the SQLite database on an embedded system. > I want to change the jo

[sqlite] Problems with pragma journal_mode

Hi everyone, I'm relatively new to SQLite and currently I'm experimenting a little bit with the SQLite database on an embedded system. I want to change the journal mode of a database to WAL. So I did the following: rc = sqlite3_open(dbPath, &db); rc = sqlite3_exec(db, "PRAGMA journal_mode=WAL;",

Re: [sqlite] Problems uploading CSV into sqlite3 DB

On 10 Sep 2014, at 3:45am, Carlos A. Gorricho (HGSAS) wrote: > The problem was a field with a very long blank string, something like 40 > space-characters. Was this value correctly delimited with quotes, or was it just 40 spaces between two commas separating the fields ? Simon. _

[sqlite] Problems uploading CSV into sqlite3 DB

Dear all, A brief update on how I managed to solve the problem...thank you all for you remarks and comments, since these were instrumental in the solution. Indeed sqlite versions had to do a lot with the problem, where 3.8 can handle csv imports, not without some glitches. I had to go in circles

Re: [sqlite] Problems uploading CSV into sqlite3 DB

Humour us and paste the first 4 lines or so of your CSV text here On 2014/09/05 04:17, Carlos A. Gorricho (HGSAS) wrote: So, any ideas on how to solve this issue will be more than welcome. I have tried several shortcuts...none works. Latest was to install an Ubuntu 14.04 Virtual Machine on

Re: [sqlite] Problems uploading CSV into sqlite3 DB

I get similar results on OS X 10.9.4 if I try to use the version of SQLite supplied with the operating system (3.7.13) to import a CSV. The simple ".mode csv" and ".import tab1" method works if I run the copy of SQLite 3.8.5 I built myself from the source code, or if I use the Mac OS X precomp

Re: [sqlite] Problems uploading CSV into sqlite3 DB

Carlos A. Gorricho (HGSAS) wrote on Friday, September 05, 2014 4:17 AM >So, any ideas on how to solve this issue will be more than welcome. I have >tried several shortcuts...none works. >Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels >software. > Maybe line endin

Re: [sqlite] Problems uploading CSV into sqlite3 DB

So, any ideas on how to solve this issue will be more than welcome. I have tried several shortcuts...none works. Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels software. Downloaded sqlite de Linux way: $ sudo apt-get install sqlite3 Ran the CSV .import protocol

Re: [sqlite] Problems uploading CSV into sqlite3 DB

​When I start sqlite double clicking the icon in the Mac Applications folder: Last login: Wed Sep 3 10:13:32 on ttys000 HEPTAGON-GROUP-SAS:~ carlosgorricho$ /Applications/sqlite3 ; exit; SQLite version 3.8.5 2014-06-04 14:06:34 Enter ".help" for usage hints. Connected to a *transient in-memor

Re: [sqlite] Problems uploading CSV into sqlite3 DB

On 3 Sep 2014, at 1:51pm, Richard Hipp wrote: > What version of SQLite is installed? Or rather, when you start the shell tool 'sqlite3' what version does it report itself as ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

Re: [sqlite] Problems with INT columns

On 29 Apr 2014, at 10:15am, Kleiner Werner wrote: > If I understand the SQLite Docu correct there is no difference between INT or > INTEGER, except if you use a column as Primary Autoincrement. > I thought an Int column in SQLite is always 64bit integer, but why does the > SQLiteDatareader doe

[sqlite] Problems with INT columns

Hello In our SQLite DB there are some tables with column type as "int" which contains values with 13 digits, like 189336960 It seems that the values are stored correct in SQLite table. But if our Windows Tool with the SQLite Datareader tries to select this value it returns wrong values. We

Re: [sqlite] Problems with executereader in System.Data.SQLite

On 15 Apr 2014, at 10:14am, Ralf wrote: > Yes. Everything is Working as expected when i access the DB with any Browser. > It is just the powershell environment Then the chances are that the problem is with PowerShell, not SQLite. Simon. ___ sqlite-u

Re: [sqlite] Problems with executereader in System.Data.SQLite

On 15. April 2014 09:46:43 MESZ, Joe Mistachkin wrote: > >Ralf wrote: >> >> I just tried... No change :-( >> > >Have you looked at the contents of the database using the SQLite >command >line tool for Windows? > > https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip > >-- >Joe Mist

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf wrote: > > I just tried... No change :-( > Have you looked at the contents of the database using the SQLite command line tool for Windows? https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Problems with executereader in System.Data.SQLite

On 15. April 2014 01:55:40 MESZ, Joe Mistachkin wrote: > >Ralf Jantschek wrote: >> >> The connection as such is ok. Updates are working. It is only the >> executereader that is troubling me >> > >For database files that need a UNC path, four leading backslashes are >required. > >Without them, som

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf Jantschek wrote: > > The connection as such is ok. Updates are working. It is only the > executereader that is troubling me > For database files that need a UNC path, four leading backslashes are required. Without them, some things may appear to work correctly; however, it might also exhib

Re: [sqlite] Problems with executereader in System.Data.SQLite

4 20:36 > An: 'General Discussion of SQLite Database' > Betreff: Re: [sqlite] Problems with executereader in System.Data.SQLite > > > Ralf Jantschek wrote: > > > >$cn.ConnectionString = "Data Source=\\..." > > > > If you are

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf Jantschek wrote: > >$cn.ConnectionString = "Data Source=\\..." > If you are opening a database on a network share, there must now be four leading backslashes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] Problems with executereader in System.Data.SQLite

;<<<< > -Ursprüngliche Nachricht- > Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Joe Mistachkin > Gesendet: Freitag, 11. April 2014 21:02 > An: 'General Discussion of SQLite Database' > Betreff: Re: [

Re: [sqlite] Problems with executereader in System.Data.SQLite

Ralf Jantschek wrote: > > I have the following table: > > Table: > > Field1Field2 > > 12 > Could you please show the schema for the table involved in this query? > > I am trying to access the values with > > "Select * from table;" > > But the sel

[sqlite] Problems with executereader in System.Data.SQLite

Hello, i hope this is the right Forum. I have the following table: Table: Field1Field2 12 I am trying to access the values with "Select * from table;" But the select doesn't return "1 2" as expected, it returns the FieldCount which

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 12/21/2012 05:18 PM, Dan Kennedy wrote: Thanks. I think it's this: http://www.sqlite.org/src/info/0cfd98ee20 Dan. You are right. I have been re-reading our mail thread and this is exactly what happens. I have build a SQLite version from the latest version in the archive (3.7.16) and this

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 11:03 AM, Marco ten Thije wrote: On 01/02/2013 10:04 AM, Dan Kennedy wrote: What series of commands did you pass to 3.7.5 to create this file? This file was copied from an existing product which uses QT 4.7 libraries to populate the database. I cannot reproduce the exact command

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 10:04 AM, Dan Kennedy wrote: What series of commands did you pass to 3.7.5 to create this file? This file was copied from an existing product which uses QT 4.7 libraries to populate the database. I cannot reproduce the exact commands which resulted in this file, because it is popu

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 03:27 PM, Marco ten Thije wrote: On 12/21/2012 05:18 PM, Dan Kennedy wrote: Thanks. I think it's this: http://www.sqlite.org/src/info/0cfd98ee20 Dan. Thanks. I have looked into ticket, but we also see this problem when the backup is written and read by the same SQLite version (3

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 12/21/2012 05:18 PM, Dan Kennedy wrote: Thanks. I think it's this: http://www.sqlite.org/src/info/0cfd98ee20 Dan. Thanks. I have looked into ticket, but we also see this problem when the backup is written and read by the same SQLite version (3.7.5). I have recreated a backup using the 3

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 12/21/2012 10:54 PM, Marco ten Thije wrote: What is the size of the two database files? The size of both files is 160768 bytes. Also, can we have the first 6 lines of each hex dump (i.e. enough to see the first 100 bytes)? The first bytes of the original database: 000 5153 694c 6574

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

What is the size of the two database files? The size of both files is 160768 bytes. Also, can we have the first 6 lines of each hex dump (i.e. enough to see the first 100 bytes)? The first bytes of the original database: 000 5153 694c 6574 6620 726f 616d 2074 0033 010 0004 0101 4000

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 12/21/2012 08:46 PM, Marco ten Thije wrote: It returns 'ok': ./sqlite3 energy.sqlite SQLite version 3.7.15.1 2012-12-19 20:39:10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma integrity_check; ok sqlite> So, the original database looks ok. I have co

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

It returns 'ok': ./sqlite3 energy.sqlite SQLite version 3.7.15.1 2012-12-19 20:39:10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma integrity_check; ok sqlite> So, the original database looks ok. I have compared the two databases (original and backup) a

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

Can you please try running "pragma integrity_check;" on the original database? That will give an indication of whether the original database has any data corruption. On Fri, Dec 21, 2012 at 4:13 AM, Marco ten Thije < marco.tenth...@usetechnology.nl> wrote: > Hello, > > We are facing a problem w

[sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

Hello, We are facing a problem with the '.backup' command using the SQLite command line interface. The resulting backup-database seems to be corrupt. We ran into this problem on a ARM9 platform using SQLite 3.7.5, but it can also be reproduced on the latest 3.7.15.1 version on Intel. I have

Re: [sqlite] Problems in VFS file read

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/09/12 19:16, Roger Binns wrote: > Looking through the code for both VFS I don't see any attempt to check > the amount parameter is positive, and in both cases it silently gets > passed to a routine expecting unsigned (size_t or DWORD). http://ww

[sqlite] Problems in VFS file read

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 One of the parameters to read is the amount of data to read. Since SQLite avoids standard types like size_t, a signed int is used instead. I observed a difference in behaviour between the Unix VFS and the Windows VFS - the former returns an error whi

  1   2   3   4   5   >