As indicated by "Random Coder", the problem was that I was missing the
required dependencies.
Thank you.
On Tue, Mar 5, 2019 at 8:03 PM Thomas Kurz wrote:
> Are both of the same architecture, either 32bit or 64bit?
>
> - Original Message -
> From: Kyle
> To: sqlite-users@mailinglists.s
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 Windo
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
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
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
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
This is a compiler issue and has nothing to do with SQLite3. Anything you
compiled using that compiler would exhibit the same problems ...
The source for SQLite3 does not change the default compiler packing or
alignment, so whatever alignment the compiler thinks is appropriate is what
gets us
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
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
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
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
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
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
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.
_
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
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
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
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
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
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
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
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
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
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
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
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
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
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://
;<<<<
> -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: [
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
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
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
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
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
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
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
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
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
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
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
-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
I've outputted the results of _sqlite3_libversion and they have
verified that the OBJ files are self contained. However, doing so has
resulted in one new piece of data. The two versions are:
3.6.17
3.7.9
I don't know if that information makes any difference, but you should
have all potentially
On Tue, Jan 10, 2012 at 10:14 AM, Richard Hipp wrote:
> On Tue, Jan 10, 2012 at 10:08 AM, John Elrick wrote:
>
>> On Tue, Jan 10, 2012 at 8:31 AM, Richard Hipp wrote:
>> > On Tue, Jan 10, 2012 at 8:14 AM, John Elrick > >wrote:
>> >
>> >> I will have to get back to you on this. While running test
On Tue, Jan 10, 2012 at 10:08 AM, John Elrick wrote:
> On Tue, Jan 10, 2012 at 8:31 AM, Richard Hipp wrote:
> > On Tue, Jan 10, 2012 at 8:14 AM, John Elrick >wrote:
> >
> >> I will have to get back to you on this. While running tests against
> >> isolated queries, I noticed an unusual circumsta
On Tue, Jan 10, 2012 at 8:31 AM, Richard Hipp wrote:
> On Tue, Jan 10, 2012 at 8:14 AM, John Elrick wrote:
>
>> I will have to get back to you on this. While running tests against
>> isolated queries, I noticed an unusual circumstance. When I isolate
>> the queries into a test program, running t
On Tue, Jan 10, 2012 at 8:14 AM, John Elrick wrote:
> I will have to get back to you on this. While running tests against
> isolated queries, I noticed an unusual circumstance. When I isolate
> the queries into a test program, running through our present
> libraries, 3.7.9 is roughly 4 times fas
I will have to get back to you on this. While running tests against
isolated queries, I noticed an unusual circumstance. When I isolate
the queries into a test program, running through our present
libraries, 3.7.9 is roughly 4 times faster executing the exact same
queries where it is running roug
Thank you for sending the sample database file.
Rather than forcing me to understand your log database, and fill in
parameters with reasonable values, I wonder if you could simply email one
or more queries (with the parameters filled in) which you find to be slower
in 3.7.9 versus 3.6.7?
On Mon,
Please send private email to d...@sqlite.org. CC to d...@sqlite.org and
j...@sqlite.org.
On Mon, Jan 9, 2012 at 11:09 AM, John Elrick wrote:
> Sorry "The combined files are 2.4 MB zipped"
>
> On Mon, Jan 9, 2012 at 11:09 AM, John Elrick
> wrote:
> > Richard,
> >
> > I have the information avail
Sorry "The combined files are 2.4 MB zipped"
On Mon, Jan 9, 2012 at 11:09 AM, John Elrick wrote:
> Richard,
>
> I have the information available for you. Unfortunately, it appears
> that I cannot actually reduce the case, however, the issues appear to
> be fairly confined.
>
> The test database
Richard,
I have the information available for you. Unfortunately, it appears
that I cannot actually reduce the case, however, the issues appear to
be fairly confined.
The test database is 6 MB and I have a database showing the
performance tracking for each of the queries which is about 140KB.
Th
Yes. Look for it on Monday. I'm about to leave for the day. The
queries are automatically generated and will require some mining to
get specific examples. I should be able to reduce the range to a
simple repeatable case but it may take a while.
Thanks very much and have a great weekend.
On Fri
Can you publish for us:
(1) A sample database
(2) The specific queries that are causing your problems
So that we can investigate further?
On Fri, Jan 6, 2012 at 4:31 PM, John Elrick wrote:
> Background
> =
> We have been using Sqlite3 in a project since 2007. Because of the
> release
Hello Gaurav,
What does a debugger show you?
C
Tuesday, November 22, 2011, 2:07:38 AM, you wrote:
GV> Here is the situation. I am using a cluster on which you can use MPI to
GV> split the processing time on to different processors. I was using
GV> PostgreSQL but since the data was on different
Marc Henrickson wrote:
>
> I copied those dll files to my folder and still get the same error.
>
Ok. At this point, the best thing to do is to run the SysInternals ProcMon
tool
and carefully go over the logs it generates to determine which DLL is not
being
found and where the system is searchin
ubject: Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled
Your list does not seem to include the ICU DLLs that I mentioned, including:
icuuc48.dll
icuin48.dll
The necessary ICU files can be obtained from the official web site:
http://site.icu-project.org/
--
Joe
Your list does not seem to include the ICU DLLs that I mentioned, including:
icuuc48.dll
icuin48.dll
The necessary ICU files can be obtained from the official web site:
http://site.icu-project.org/
--
Joe Mistachkin
___
sqlite-users mailing list
sql
All DLL's are in the same folder.
Test.exe
SQLite.Interop.DLL
System.Data.SQLite.DLL
We have tried everything and cannot get this to run with ICU enabled.
Is there somewhere I can post my VS project files so someone can look at this?
It seems like it should be pretty straightforward, but nothin
Marc Henrickson wrote:
>
> System.Reflection.TargetInvocationException: Exception has been thrown by
the target of an invocation. --->
> System.TypeInitializationException: The type initializer for
'System.Data.SQLite.SQLiteFactory' threw an exception. --->
> System.DllNotFoundException: Unable
Yes, on linux host I have a lot of problems in SQLite tests with ICU enabled.
2011/9/30 Marc Henrickson :
> I have downloaded the SQLite source code (sqlite-netFx-source-1.0.74.0) as
> well as the latest ICU libraries (icu4c-4_8-Win32-msvc10). I then build the
> SQLite projects and run the test
What I'm looking for is to be able to compile SQLite with ICU enabled and have
the test application run at all. I don't necessarily need to debug or run from
the IDE. It seems no matter which configuration I use, or which settings I
tweak, nothing will work.
In order to get the test applica
>
> System.Reflection.TargetInvocationException: Exception has been thrown by
the target of an invocation. --->
> System.TypeInitializationException: The type initializer for
'System.Data.SQLite.SQLiteFactory' threw an exception. --->
> System.DllNotFoundException: Unable to load DLL 'SQLite.Inter
On 13 Sep 2011, at 7:36pm, David Holtkamp wrote:
> I was unaware of this. I thought it started to write to a Journal file
> during the backup and then persisted it afterward. However, if this
> scenario was happening, wouldn't the file size tend to jump around
> sporadically around 200Mb instead
I was unaware of this. I thought it started to write to a Journal file
during the backup and then persisted it afterward. However, if this
scenario was happening, wouldn't the file size tend to jump around
sporadically around 200Mb instead of settling into one specific size?
On Tue, Sep 13, 2011 a
Another thing you might think about is to modify the membase code (it is
open-source after all) such that membase itself invokes the backup using the
sqlite3_backup() interfaces. If the backup is being performed using the
same database connection that is doing the writes, then the backup will know
I was unaware of this. I thought it started to write to a Journal file
during the backup and then persisted it afterward. However, if this
scenario was happening, wouldn't the file size tend to jump around
sporadically around 200Mb instead of settling into one specific size?
>
> On Tue, Sep 13, 20
On Tue, Sep 13, 2011 at 2:23 PM, David Holtkamp wrote:
> Hello,
> I have been using Membase (a nosql database), which uses sqlite3 to
> persist data to disk and have run into some problems when attempting
> to backup the database files. Membase uses 4 different database files
> to store the data
Am Dienstag, den 17.05.2011, 13:53 +0800 schrieb jiajianying:
> Hello,
>
> I'm using sqlite to process some csv files. It is very disappointing
> that sqlite's csv mode doesn't support quoted csv format. I tried
> spatialite which can only strip quote marks but can't parse it correctly.
>
> Is
I made one, as a command line tool.
the announcement:
http://spointeau.blogspot.com/2011/03/sylisa-csv2db-is-born.html
the sources:
https://gitorious.org/sylisa-csv2db/sylisa-csv2db
Another option, you can also use the shell (in python) apsw
http://apidoc.apsw.googlecode.com/hg/index.html
_
Justin,
If you're comfortable with perl, try perl's Text::CSV module with
DBD::SQLite. I have used Text::CSV, which has a good set of format options
that it parses. I have not used DBD::SQLite myself.
Andy
-Original Message-
From: sqlite-users-boun...@sqlite.org [mail
On 04/21/2011 05:42 PM, Gaurav Srivastava wrote:
> Hi
>
> I have recently upgraded my sqlite version from 3.5.1 to 3.7.3. With the
> update I have been seeing some issues with sqlite3_prepare_v2() API.
> The workflow here is:
> sqlite3VdbeSetSql(pVDbe, zSql, saveSqlflag)
> ^
> |
>
package require Tcl 8.5
is all it takes
Gerry
On 7/29/10, Richard Hipp wrote:
> On Thu, Jul 29, 2010 at 4:44 PM, Paweł Hajdan, Jr.
> wrote:
>
>> I'm planning to contribute some patches (upstreaming patches Chromium
>> project applies to its local copy of sqlite).
>>
>> I've checked out the fos
On 30 Jul 2010, at 1:14am, Paweł Hajdan, Jr. wrote:
> On Thu, Jul 29, 2010 at 16:34, Richard Hipp wrote:
>
>> The test suite now requires Tcl 8.5. You appear to be running Tcl 8.4.
>>
>
> That's right. After upgrading from tcl8.4 to tcl8.5 the tests run just fine.
Can you insert a new test,
On Thu, Jul 29, 2010 at 16:34, Richard Hipp wrote:
> The test suite now requires Tcl 8.5. You appear to be running Tcl 8.4.
>
That's right. After upgrading from tcl8.4 to tcl8.5 the tests run just fine.
Thanks!
___
sqlite-users mailing list
sqlite-us
On Thu, Jul 29, 2010 at 4:44 PM, Paweł Hajdan, Jr.
wrote:
> I'm planning to contribute some patches (upstreaming patches Chromium
> project applies to its local copy of sqlite).
>
> I've checked out the fossil repository, configured and compiled sqlite, and
> tried running "make test" (I didn't ma
On Friday, July 23, 2010 1:26 PM, Richard Hipp wrote:
> You need TCL 8.5 or (even better) 8.6. TCL 8.4 is not adequate
> to run the newer parts of the test suite.
Again, thank you for your quick response.
Please can I suggest that the configure scripts be updated to reflect this
change in depe
On Thursday, July 22, 2010 8:21 PM, Richard Hipp wrote:
>> > The configure command I'm using is:
>> >
>> > ./configure
>> > CFLAGS="-std=c99 -Werror" --enable-threadsafe --enable-debug
>> --with-tcl=/usr/lib/tcl8.4
>> >
>>
>> Sorry, I should add, I'm running on Debian Linux Lenny, with gcc 4.4.4,
On Thu, Jul 22, 2010 at 12:39 PM, Andy Gibbs wrote:
> On Thursday, July 22, 2010 6:36 PM, Andy Gibbs wrote:
>
> > The configure command I'm using is:
> >
> > ./configure
> > CFLAGS="-std=c99 -Werror" --enable-threadsafe --enable-debug
> --with-tcl=/usr/lib/tcl8.4
> >
>
> Sorry, I should add, I'm r
On Thursday, July 22, 2010 6:36 PM, Andy Gibbs wrote:
> The configure command I'm using is:
>
> ./configure
> CFLAGS="-std=c99 -Werror" --enable-threadsafe --enable-debug
> --with-tcl=/usr/lib/tcl8.4
>
Sorry, I should add, I'm running on Debian Linux Lenny, with gcc 4.4.4,
because this is proba
On 13 Dec 2009, at 11:04am, Marek Staniewski wrote:
> We are using some application, which uses sqlite over the network.
> Sometimes I observed that last entered data into application is lost.
What programming language are you calling the SQLite function library from ?
What operating system is
>
>
>
> Here is the cut-down program...
>
>
> #!/usr/bin/tclsh
> set lat_degrees [expr [lindex $argv 0]]
> set long_degrees [expr [lindex $argv 1]]
> s
an change them back again to f.
Any suggestions would be greatly appreciated.
Regards
Rodney
> To: sqlite-users@sqlite.org
> From: itandet...@mvps.org
> Date: Thu, 5 Nov 2009 14:42:30 -0500
> Subject: Re: [sqlite] Problems with the UPDATE command
>
> Rodn
On Thu, Nov 5, 2009 at 1:28 PM, Rodney Cocker wrote:
>
> I ran the following SQL command
>
> UPDATE local_episodes
> SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename,
> 3,LENGTH(EpisodeFilename))
> WHERE SUBSTR(EpisodeFilename,1,3)='F:\'
>
> Which worked perfectly, but when I went to run it t
Rodney Cocker
wrote:
> I ran the following SQL command
>
> UPDATE local_episodes
> SET EpisodeFilename = 'j:' || SUBSTR(EpisodeFilename,
> 3,LENGTH(EpisodeFilename))
> WHERE SUBSTR(EpisodeFilename,1,3)='F:\'
>
> Which worked perfectly, but when I went to run it the next time to
> change any fi
Another idea: make sure that you're telling linker to link with
libsqlite3.a - it cannot guess it for you.
Pavel
On Tue, Oct 20, 2009 at 6:13 AM, Michal Seliga wrote:
> just an idea - make sure you are crosscompiling and libsqlite3.a is for
> arm-linux and not for cygwin
>
> j.hermanussen wrote:
just an idea - make sure you are crosscompiling and libsqlite3.a is for
arm-linux and not for cygwin
j.hermanussen wrote:
> Hi to all, I'm new on this list.
>
> I'm working on an application that runs on a small ARM-LINUX device, too
> small to contain GCC. So I've installed Cygwin on my Win XP
y smile and some self-deprecation. But, DRH already
commented on that.
>
> - Original Message -----
> From: "D. Richard Hipp"
> To: "General Discussion of SQLite Database"
> Sent: Thursday, September 03, 2009 8:05 AM
> Subject: Re: [sqlite] Problems encou
ical fallicies.
- Original Message -
From: "D. Richard Hipp"
To: "General Discussion of SQLite Database"
Sent: Thursday, September 03, 2009 8:05 AM
Subject: Re: [sqlite] Problems encountered on upgrade from SQLite2
to -3
>
> On Sep 3, 2009, at 10:43 AM, Ro
On Sep 3, 2009, at 10:43 AM, Rod Dav4is wrote:
>*re applied affinity:* If that is what is meant, then the document
> should say it, instead of leaving it to the reader's imagination.
>Since column typing was superfluous in version2, it seems that the
> version3 adoption of typing, as defi
Whoa! All I did was report two problems that I encountered when
upgrading from version2 to version3! I was told that my problems were
not problems at all; In fact one of them was a feature! That sounds
kinda arrogant to me.
As far as freezing the language, I made no such statement or
r
*re applied affinity:* If that is what is meant, then the document
should say it, instead of leaving it to the reader's imagination.
Since column typing was superfluous in version2, it seems that the
version3 adoption of typing, as defined, would perhaps be an upgrade
compatibility issue
Umm,
At 05:16 03/09/2009, you wrote:
´¯¯¯
>Thanks for reminding me: A thing's value is generally proportional to
>its cost. And the attitude of its support team figures in there, too.
>-R.
>
> >> Whether _you_ consider them problems or not, they were certainly
> >> problems for me, migrating a wor
> Yes, I know how it works. But that seems to contradict the
> documentation. The first field of the record inserted should have a type
> of numeric, as types are associated with the data not with the column
> declaration. So the phrase Where n = '1' should fall into the first
> bullet case
Rod, t
Pavel Ivanov wrote:
>> Perhaps the fact that my column definitions declared no
>> typing has an effect here?
>>
>
> Yes, that means that your columns have no affinity, all data stored in
> it as you give and no conversions done during insertions and
> comparisons:
>
> sqlite> create table t (
Pavel Ivanov wrote:
>> 2. *re integer vs string:* Version 3 differs from version 2 here.
>> Version 2 was declared to be typeless and "Select Where column =
>> 1" behaved identically with "Select Where column = '1'". Version
>> 3 behavior is different in that the two previous exam
> Perhaps the fact that my column definitions declared no
> typing has an effect here?
Yes, that means that your columns have no affinity, all data stored in
it as you give and no conversions done during insertions and
comparisons:
sqlite> create table t (n, t);
sqlite> insert into t values (1, '
Pavel Ivanov wrote:
2. *Quotes in SELECT*: Specification of Field='3' failed to find
hits; Field=3 (i.e. without quotes) was required.
>> This is a feature, not a bug. SQLite 3.x distinguishes between
>> integers and strings and does not consider them equal to one an
>>> 2. *Quotes in SELECT*: Specification of Field='3' failed to find
>>> hits; Field=3 (i.e. without quotes) was required.
>
> This is a feature, not a bug. SQLite 3.x distinguishes between
> integers and strings and does not consider them equal to one another.
> You might have some rows wh
> 2. *re integer vs string:* Version 3 differs from version 2 here.
> Version 2 was declared to be typeless and "Select Where column =
> 1" behaved identically with "Select Where column = '1'". Version
> 3 behavior is different in that the two previous examples produce
> diff
1. *re OID vs ROWID:* I don't understand your statement that the
"name" of a result column is undefined. The documentation clearly
states "A column name can be any of the names defined in the
CREATE TABLE statement or one of the following special
identifiers: "*ROWID*",
1 - 100 of 341 matches
Mail list logo
