Devart Forums

Code: Select all

Error: Devart.Data.SQLite.SQLiteException: SQLite error
  at Devart.Data.SQLite.a3.a (System.Byte[] A_0, UInt32 A_1, System.Byte[]& A_2) [0x00000] in :0 
  at Devart.Data.SQLite.bs.a (System.Byte[] A_0) [0x00000] in :0 
  at Devart.Data.SQLite.t.b () [0x00000] in :0 
  at Devart.Data.SQLite.SQLiteDataReader.c () [0x00000] in :0 
  at (wrapper remoting-invoke-with-check) Devart.Data.SQLite.SQLiteDataReader:c ()
  at Devart.Data.SQLite.SQLiteCommand.InternalExecute (CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords) [0x00000] in :0 

Code: Select all

Error: Devart.Data.SQLite.SQLiteException: SQLite error
unrecognized token: ""
  at Devart.Data.SQLite.a3.a (System.Byte[] A_0, UInt32 A_1, System.Byte[]& A_2) [0x00000] in :0 
  at Devart.Data.SQLite.bs.a (System.Byte[] A_0) [0x00000] in :0 
  at Devart.Data.SQLite.t.b () [0x00000] in :0 
  at Devart.Data.SQLite.SQLiteDataReader.c () [0x00000] in :0 
  at (wrapper remoting-invoke-with-check) Devart.Data.SQLite.SQLiteDataReader:c ()
  at Devart.Data.SQLite.SQLiteCommand.InternalExecute (CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords) [0x00000] in :0 

Code: Select all

       public Binary newClientDatabase()
        {
            string fileName = Path.GetTempFileName();
            string conStr = string.Format("DateTime Format=ISO8601;Pooling=false;Data Source={0}", fileName);
            SQLiteConnection con = new SQLiteConnection(conStr);
            
            con.Open();
            try
            {
                SQLiteCommand exe = con.CreateCommand();
                exe.CommandText = this.loadClientScript(); <-- UTF8: File.ReadAllText(script, System.Text.Encoding.UTF8);
                exe.CommandType = CommandType.Text;

                exe.ExecuteNonQuery(); <-- HERE ERROR

            }
            finally
            {
                con.Close();
            }

Code: Select all

CREATE TRIGGER Order_bi_fk_Customer
BEFORE INSERT
ON "Order"BEGIN  SELECT CASE
WHEN (SELECT 1 FROM Customer WHERE Customer.id = NEW.IdCustomer) IS NULL
THEN RAISE(ABORT, 'INSERT statement conflicted with COLUMN REFERENCE constraint [Order -> Customer].')
END;
END;