[sqlite] Is there any book (books??) to help us creating a bidirectional Sync tool?

Hi guys, We have been looking for books which cover the DB synchronisation subject. We have started creating a plugin to our socket server but we quickly realised how much of a challenge it would be (We are creating it "from scratch"). The conflict problems, the order to tables (rows) be synchron

[sqlite] Trigger UPDATE OF problems

Hi, We need to use a trigger to update the column sync into a table when any column is changed (except the sync column itself), so by looking in the SQLite website we came across that: CREATE TRIGGER syncTransactions AFTER UPDATE OF transactionId, transactionJourneyId, transactionDeviceId, trans

[sqlite] Reusing SQLiteCommand

Hi, I am new to C# and SQLite and I am having problems using Paramaters.Add... I prepare the "INSERT" statement and inside a loop I set the values for each parameter and call ExecuteNonQuery(); Something similar to that: checkCmd.CommandText = "SELECT userId FROM users WHERE us

[sqlite] SQLite for .NET 1.1?

Hi! Where can we find ADO for .NET 1.1? Thanks in advance -- View this message in context: http://www.nabble.com/SQLite-for-.NET-1.1--tf2796567.html#a7802832 Sent from the SQLite mailing list archive at Nabble.com. -

[sqlite] SELECT FOR UPDATE

Hi, We are newbie to SQLite and we would like to lock a table through a select + update. Something like that: BEGIN TRANSACTION currentValue = select currentValue from sequence_transactions; update sequence_transactions set currentValue = currentVa