wqpamerica.blogg.se

Lua and Pascal script examples (Professional Edition). Each package contains: SQLite Expert application. Is this still wrong? I can still insert the data into my DB. Download SQLite Expert Personal 5.x SQLite Expert Personal is freeware and does not have an expiration date. SQLiteCommand cmd = new SQLiteCommand("INSERT INTO tblLicenseInfo I now added some code, so it looks like this: SQLiteCommand foo = new SQLiteCommand("PRAGMA foreign_keys = ON ", SqLite) When I try the same sql statement in Expert Personal it shows an error msg, but in Visual studio no exception is thrown - the data is just insert into my table (I can see the entry when I open the DB with Expert Personal). Theres no entry in tblUser with UserID = 2 and no entry with MachineID = 1. (UserID, MachineID, ExpirationDate, DateOfChange, LicenseKey) Heres my c# code: SQLiteCommand cmd = new SQLiteCommand("INSERT INTO tblLicenseInfo When trying to add data to the db using SQLite Expert personal my Foreign Key Constraints are working as expected, but when i try to insert data using c# I can add Data violating a Foreign Key Constraint. Im using a SQLite DB when creating my DB using c# code and Visual studio or SQLite Expert personal everything is working fine.