System.Data.SQLite version 1.0.75.0 is now available on the
System.Data.SQLite website:
http://system.data.sqlite.org/
Further information about this release can be seen at
http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
Please post on the SQLite mailing list (sqlite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/03/2011 03:05 PM, Dungan, Kerry wrote:
> the result:
> An empty file.db is created, and I get "sqlite3.OperationalError: disk I/O
> error" on the execute command.
There could be any number of reasons. The message is coming from the SQLite
libr
Hello,
I have a piece of code that works fine on my desktop in cygwin, but fails on
our server. I am creating a simple database using the sqlite3 module in python.
I open a connection
con=sqlite3.connect("./file.db") #works
cur=con.cursor() #works
cur.execute("""create table test(name, age)""")
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
On 10/3/2011 3:21 PM, Pero Mirko wrote:
If I do
BEGIN EXCLUSIVE
. insert / update / delete queries here
COMMIT
does it guarantee it will automatically rollback if the error occurs or do I
have to specify it manually?
http://sqlite.org/lang_conflict.html
What happens if I have 20 que
That does it. Thank you!
Now, I feel a little shame and will pick up a SQL book to read.
On Oct 3, 2011, at 2:53 PM, Jim Morris wrote:
>
> That should be select 'Total', count(*) from hosts
> On 10/3/2011 11:52 AM, Jim Morris wrote:
>> This should do it.
>> select region, count(*) from hosts gr
If I do
BEGIN EXCLUSIVE
insert / update / delete queries here
COMMIT
does it guarantee it will automatically rollback if the error occurs or do I
have to specify it manually?
What happens if I have 20 queries, 10 execute successfully (after COMMIT)
and then it fails - will the database
That should be select 'Total', count(*) from hosts
On 10/3/2011 11:52 AM, Jim Morris wrote:
This should do it.
select region, count(*) from hosts group by region
union all
select 'Total, count(*) from hosts
;
On 10/3/2011 11:49 AM, James Kang wrote:
select region, count(*) from hosts group b
This should do it.
select region, count(*) from hosts group by region
union all
select 'Total, count(*) from hosts
;
On 10/3/2011 11:49 AM, James Kang wrote:
select region, count(*) from hosts group by region
___
sqlite-users mailing list
sqlite-use
I have failed to answer for myself after googling extensively.
Here is my sql statement,
select region, count(*) from hosts group by region;
And it produce,
region count
nyc 34
bos 21
was 20
My question is how to the grand total of count(*) also in one statement
You need to be aware of the DLL search paths...can be quite confusing...
http://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx#related_topics
Process explorer should help ensure you're running what you think you are
http://support.microsoft.com/kb/970920
Michael D
> As can be guessed populating table is quite slow - ~150ms for around 10k rows
> in IndexME.
Why do you think it's slow? 6 rows per second is insanely fast.
Pavel
On Sun, Oct 2, 2011 at 5:49 AM, Mira Suk wrote:
>
> Hey everyone,
>
> currently I have some temporary table which I populate
> I've tried:
> replace("Name", x'f87f', '') but it doesn't seem to match the weird character.
> Any ideas?
I guess x'f87f' will match your character only if your database is in
UTF-16. For UTF-8 you probably should try x'efa1bf'. And maybe
explicit conversion to text is needed.
Pavel
On Mon,
Hi SQLiters,
I am trying to clean up some text in a database that has some weird
non-printable unicode characters.
For instance:
.mode insert
select distinct "Name", length ("Name"), substr("Name",-1,1) from "My Table"
gives:
INSERT INTO table VALUES('Roundup Ready®',15,'')
As you can see,
Simon,
Thank you! I have an odd ball case where the tables have two homes: One is
a 'system' db one is a 'document' db. Depending on the case, the user can
make changes to the document db, which in that case, needs the triggers, but
in the case where the system db is being recloned to the docum
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
On 3 Oct 2011, at 4:12am, Sam Carleton wrote:
> Ok, how do I list what a trigger is so that I can add it back once I want to
> "reactive" it?
To list all triggers:
SELECT * FROM sqlite_master WHERE type='trigger'
To list all triggers for a particular table:
SELECT * FROM sqlite_master WHERE
17 matches
Mail list logo