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

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 table, I am right? - Original

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?

Re: [sqlite] multiple inserts

begin; insert into table (col1,col2) values (val1,val2); insert into table (col1,col2) values (val3,val4); insert into table (col1,col2) values (val5,val6); end; you might use FOR or WHILE to construct the query another example sqlite_exec($db,"BEGIN;"); for($x = 1; $x<=50; $x++) {

[sqlite] multiple inserts

Hi, Does SQLite accepts multiple insert? insert into table (col1,col2) values (val1,val2), (val3,val4), (val5,val6) If not, how can I speed up large inserts? eg: 1000 rows Regards, Marton ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] quickly locking/unlocking database with password

Hello, I use C# to connect SQLite. connStr = @"Data Source=" + databaseFilePath + ";New=True;Version=3;"; conn = new SQLiteConnection(connStr); I know I can add a Password=something; string to the connection string in order to get a locked/encrypted database. I am wondering if there is a quick

[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,