Hi
I saw in the version history that SQLite makes use of trace listeners.
Could anyone give me an example of how to attach a trace listener to an
application that uses System.Data.SQLite? Specifically related to the
compact frame work version for Windows Mobile and Pocket PC.
Any help would be gr
Hi Igor, Keith,
I think my explanation wasn't very clear.
I just meant to say that ROWID is not a sequence number of insertion in
the case when an INTEGER PRIMARY KEY is used - it comes across as a
sequence number when we don't have an integer primary key.
Rest of the answers less relevant n
On 2/10/2013 10:06 PM, Mohit Sindhwani wrote:
1. If I'm not wrong, ROWID does not change when you delete records. So,
if the OP wants the ability to always say "it's the 9th record in the
table right now", it won't work. Given that an RDBMS table is a set and
in theory, sets don't have that prop
> I have been caught out by this - I read what the documentation says but
> just did not carefully understand it. What the above means is this:
> * You do an insert in the sequence as above, you say that I should not
> sort by id ASC because you want it in insertion order
> * You decide then to
Hi Peter,
I have been caught out on this.
On 11/2/2013 8:40 AM, Peter Aronson wrote:
You can add it to the select list as OID, ROWID or _ROWID_ or, if the
table has a column defined INTEGER PRIMARY KEY (but not INTEGER
PRIMARY KEY DESC) it'll also be this value. See:
http://www.sqlite.org/la
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/02/13 14:27, Simon Slavin wrote:
> Any chance of killing it in SQLite 4 ?
Continuing to beat a truly dead horse, it would be nice to help developers
fix their existing codebase via something like an additional "lint mode".
http://www.sqlite.o
You can add it to the select list as OID, ROWID or _ROWID_ or, if the
table has a column defined INTEGER PRIMARY KEY (but not INTEGER PRIMARY
KEY DESC) it'll also be this value. See:
http://www.sqlite.org/lang_createtable.html#rowid
Peter
On 2/10/2013 5:23 PM, roystonja...@comcast.net wrote:
After you do a retrieve from the database, how would to access the RecNo for
each record? I can get to all the fields but I don't know how to access the
record number that sqlite creates when it creates your record. I am not
looking for the last record number created.
I will be populating a L
>Ah, I did not understand this. I ran three tests after enabling this:
>root@raspberrypi:/opt/obdpi/sql# sqlite3 trip.db 'PRAGMA journal_mode=WAL'
>wal
># time sqlite3 trip.db "delete from trip where key<=200"
>real0m0.642s
[edited]
Sqlite4
>time /root/sqlite4/sqlite4 trip.db "delete from
On Sun, Feb 10, 2013 at 5:27 PM, Simon Slavin wrote:
>
> On 10 Feb 2013, at 8:39pm, Richard Hipp wrote:
>
> > The fact that SQLite will treat a double-quoted string as a string
> literal
> > rather than as a quoted identifier is a horrible mis-feature. It was
> added
> > 10 years or so ago in a
On 10 Feb 2013, at 8:39pm, Richard Hipp wrote:
> The fact that SQLite will treat a double-quoted string as a string literal
> rather than as a quoted identifier is a horrible mis-feature. It was added
> 10 years or so ago in an attempt to be more MySQL-compatible. I have come
> to sorely regre
Hi Richard,
Thank you for taking the time to reply. Personally I never use
double-quoted strings as string literals, but this issue was reported by
users of a tool that generates table creation SQL based on user input, and
that encloses in parenthesis any default values entered by the user to
acco
The fact that SQLite will treat a double-quoted string as a string literal
rather than as a quoted identifier is a horrible mis-feature. It was added
10 years or so ago in an attempt to be more MySQL-compatible. I have come
to sorely regret that change. I'd love to get rid of this mis-feature, b
That's great Mike. Thanks very much!
On 10 February 2013 20:26, Mike King wrote:
> Select * from tbl where col1 in ('a', 'b', 'c')
>
>
>
> On Sunday, 10 February 2013, e-mail mgbg25171 wrote:
>
> > Sorry if this is a very basic question but I'm just wondering if there's
> a
> > more elegant way
Select * from tbl where col1 in ('a', 'b', 'c')
On Sunday, 10 February 2013, e-mail mgbg25171 wrote:
> Sorry if this is a very basic question but I'm just wondering if there's a
> more elegant way of doing this
>
> select * from tbl where col1 = 'a' or col1 = 'b' or col1 = 'c'
>
> i.e. selectin
>> Hi all, I'm a new user in this list. Is possible to connect
>> to a SQLITE database from AS400? Any help will be appreciated.
>> Mauro
>
>There appears to be a sqlite3 port to AS400
>embedded in "iSeries Python".
>
>http://www.iseriespython.com/app/ispMain.py/Start?job=Posts&session=&subjob=Vie
Sorry if this is a very basic question but I'm just wondering if there's a
more elegant way of doing this
select * from tbl where col1 = 'a' or col1 = 'b' or col1 = 'c'
i.e. selecting rows if a particular column has one of SEVERAL values.
Any help much appreciated.
__
On 09/02/13 13:49, mukesh kumar mehta wrote:
Is there any option to import csv file into sqlite database with the
help of System.Data.Sqlite.dll. As like shell command ".import
file_name table_name".
SpatiaLite can do this (either as a virtual table, or an import). There
are probably other exten
On Sun, 10 Feb 2013 18:42:08 + (GMT), Mauro Bertoli
wrote:
> Hi all, I'm a new user in this list. Is possible to connect
> to a SQLITE database from AS400? Any help will be appreciated.
> Mauro
There appears to be a sqlite3 port to AS400
embedded in "iSeries Python".
http://www.iseriespyth
Using SQLite 3.7.15.2. The following statements execute with no error:
CREATE TABLE [test1] (
[id] INTEGER,
[name] CHAR DEFAULT 'test');
CREATE TABLE [test2] (
[id] INTEGER,
[name] CHAR DEFAULT ('test'));
CREATE TABLE [test3] (
[id] INTEGER,
[name] CHAR DEFAULT "test");
However, th
Hello,
This letter is a help getting you started to finding your error.
There are many SQLITE_IOERR-errors, for example SQLITE_IOERR_NOMEM which
means out of memory.
I have noticed in my application that I sometimes get out of memory when
calling g_string_new() after modifying the whole table, i
Hi all, I'm a new user in this list. Is possible to connect to a SQLITE
database from AS400? Any help will be appreciated.
Mauro
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Greg Janée wrote:
> Hello, I'm running a web service that uses SQLite that throws a disk I/O
> exception every once in a while, meaning once every few weeks.
...snip...
> Any ideas? Unfortunately, the (standard) Python SQLite wrapper I'm using
> doesn't provide access to any more information (if
On 10 Feb 2013, at 4:28pm, Greg Janée wrote:
> Any ideas? Unfortunately, the (standard) Python SQLite wrapper I'm using
> doesn't provide access to any more information (if there is any to be had).
That would make diagnosis difficult. Please check to see whether you can
enable extended resu
Hello, I'm running a web service that uses SQLite that throws a disk I/
O exception every once in a while, meaning once every few weeks.
Details: SQLite 3.7.0.1, being called from an Apache/Django/Python
multi-threaded application running on Solaris 10. The database file
is on a local files
25 matches
Mail list logo