On Oct 2, 2011, at 10:29 PM, Igor Tandetnik wrote:
> Sam Carleton wrote:
>> Is there any way to "disable" a trigger in sqlite?
>
> If you have control over the trigger's definition, you could do something
> like this:
>
> create trigger MyTrigger on ...
> when
BareFeetWare wrote:
> On 03/10/2011, at 2:12 PM, 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?
>
> select SQL from SQLite_Master where name = 'trigger name' and Type = 'trigger'
And be careful
Sam Carleton wrote:
> Is there any way to "disable" a trigger in sqlite?
If you have control over the trigger's definition, you could do something like
this:
create trigger MyTrigger on ...
when (select enabled from TriggerControl where name='MyTrigger')
begin
...
On 03/10/2011, at 2:12 PM, 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?
select SQL from SQLite_Master where name = 'trigger name' and Type = 'trigger'
Tom
Tom Brodhurst-Hill
BareFeetWare
--
iPhone/iPad/iPod and Mac
On Oct 2, 2011, at 10:12 PM, 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?
You are looking to temporarily deactivate a TRIGGER, but there is no such
mechanism. You could simply copy the code for the TRIGGER, then DROP it,
Ok, how do I list what a trigger is so that I can add it back once I want to
"reactive" it?
On Sun, Oct 2, 2011 at 9:07 PM, Igor Tandetnik wrote:
> Sam Carleton wrote:
> > Is there any way to "disable" a trigger in sqlite?
>
> DROP TRIGGER
> --
Sam Carleton wrote:
> Is there any way to "disable" a trigger in sqlite?
DROP TRIGGER
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Is there any way to "disable" a trigger in sqlite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
Wamiduku wrote:
>
> Are there any plans to also provide the stable version as a NuGet package?
>
Yes.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
OK, so the version on the download page is the stable version and the
NuGet package is the development version. Are there any plans to also
provide the stable version as a NuGet package?
-John
On Oct 1, 10:33 pm, "Joe Mistachkin" wrote:
> Wamiduku wrote:
>
> > Is this a
On Sun, 02 Oct 2011 21:20:27 +0800, ??
wrote:
> thank you very much for replying me. my application is really
> very slow when insert data, and i have tried translation.
I guess you mean transaction, not translation?
> but it does not increase speed. so what can i do?
Data is stored in pages, and if you have a large blob as the first
column, the other data is being pushed out to other pages (I think
they are called "internal pages" in the docs). So to read the other
data, sqlite has to first read the row's header page, then find & read
the page that the other
thank you very much for replying me. my application is really very slow when
insert data,and i have tried translation. but it does not increase speed. so
what can i do?
___
sqlite-users mailing list
sqlite-users@sqlite.org
_
> Od: "Simon Slavin"
> Datum: 02.10.2011 14:01
>
>
>On 2 Oct 2011, at 12:49pm, Mira Suk wrote:
>
>> CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB,
>> Description TEXT)
>> vs
>> CREATE TABLE [Data2] (Index
On 2 Oct 2011, at 12:49pm, Mira Suk wrote:
> CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB,
> Description TEXT)
> vs
> CREATE TABLE [Data2] (Index INTEGER PRIMARY KEY NOT NULL, Description TEXT,
> Data BLOB)
>
> essentially those tables are same. however accessing the
Hey everyone,
Imagine tables
CREATE TABLE [Data1] (Index INTEGER PRIMARY KEY NOT NULL, Data BLOB,
Description TEXT)
vs
CREATE TABLE [Data2] (Index INTEGER PRIMARY KEY NOT NULL, Description TEXT,
Data BLOB)
essentially those tables are same. however accessing the column "Description"
Hey everyone,
currently I have some temporary table which I populate this way (recursive
triggers on)
CREATE TEMPORARY TABLE IF NOT EXISTS NestedEntriesResult_ID (IDX INTEGER NOT
NULL, DBORDER INTEGER PRIMARY KEY NOT NULL);
CREATE TEMPORARY TRIGGER IF NOT EXISTS NestedEntriesPopulate_ID
18 matches
Mail list logo