Error in update: "logic error or missing database"

Topics: Windows Phone , Xamarin
Jan 2, 2015 at 12:06 PM
Edited Jan 2, 2015 at 12:08 PM
I can not get two updates in the same transaction.

The first is performed but the second error.

When making the second update I get the error: "logic error or missing database"


The following example:
string sql = "UPDATE PARAMETROFILIAL SET VALOR = ?, DESCRICAO = ? WHERE IDPARAMETROFILIAL = ?";
            using (SQConnectionDatabase sqCon = new SQConnectionDatabase(MobileContext.Instance.databasePath))
            {
                    sqCon.BeginTransaction();
                    int result = sqCon.Execute(sql, "X1", "X1", 1);
                    result = sqCon.Execute(sql, "X2", "X2", 2);
                    sqCon.Commit();
            }
Can you help?
Jan 2, 2015 at 2:54 PM
Marked as answer by marianosz on 1/2/2015 at 8:08 AM