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
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
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
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, the
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, Oct
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 mira@centrum.cz wrote:
Hey everyone,
currently I have some temporary table
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
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
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
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
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
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
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
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)) #fails
-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
library
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
16 matches
Mail list logo