Re: [sqlite] is there a pragma to disable triggers?

Kodok Márton wrote: > Hello, > I am working on a syncing project and I do have a lot of triggers to > read/write foreign keys. > And while I do the sync of one table the triggers are causing a strange > effect (as the other table is not yet synced). > Is there a

Re: [sqlite] is there a pragma to disable triggers?

Kodok Márton wrote: > now this raises questions: > > eg: > CREATE TABLE clients ... > CREATE VIEW getclients AS select * from clients. > > now if I update the 'getlist' view that will with a instead of trigger > update the clients table > > that will raise the triggers for the client

Re: [sqlite] is there a pragma to disable triggers?

Message - From: "Kees Nuyt" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Thursday, August 14, 2008 8:59 PM Subject: Re: [sqlite] is there a pragma to disable triggers? > On Mon, 11 Aug 2008 13:16:45 +0300, you

Re: [sqlite] is there a pragma to disable triggers?

>Is there a pragma to disable triggers on the sqlite database? Perhaps you can solve the problem with "INSTEAD OF" triggers on one or more views. Yes, that's possible: a view is `virtually` updatable when you define triggers for all statements that will be used to update the view.

Re: [sqlite] is there a pragma to disable triggers?

Regarding: I can't use command line utility as I do this on a smartphone device. and I am using sqlite by c# the Ado .Net library which is very new to me and I can for now only execute insert,delete,update and basic commandtext queries. -- Well, you might have to resort to a more complex

Re: [sqlite] is there a pragma to disable triggers?

Regarding: Is there a pragma to disable triggers on the sqlite database? Hello Marton, There's no such pragma to my knowledge. See http://www.sqlite.org/pragma.html Perhaps you can use the command line utility "sqlite3" to ".dump" the schema of your database, isolate jus

Re: [sqlite] is there a pragma to disable triggers?

> effect (as the other table is not yet synced). > > Is there a pragma to disable triggers on the sqlite database? > > > > > No, there is no way to disable triggers. > > You could save the SQL used to create the triggers from the > sqlite_master table, drop the

Re: [sqlite] is there a pragma to disable triggers?

Kodok Márton wrote: > > I am working on a syncing project and I do have a lot of triggers to > read/write foreign keys. > And while I do the sync of one table the triggers are causing a strange > effect (as the other table is not yet synced). > Is there a pragma t

Re: [sqlite] is there a pragma to disable triggers?

Hello, I am working on a syncing project and I do have a lot of triggers to read/write foreign keys. And while I do the sync of one table the triggers are causing a strange effect (as the other table is not yet synced). Is there a pragma to disable triggers on the sqlite database

[sqlite] is there a pragma to disable triggers?

Hello, I am working on a syncing project and I do have a lot of triggers to read/write foreign keys. And while I do the sync of one table the triggers are causing a strange effect (as the other table is not yet synced). Is there a pragma to disable triggers on the sqlite database? Regards