![]() ![]() SQLite Expert Personal includes visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities. The graphical interface supports all SQLite features. ![]() It is a feature rich administration and development tool for SQLite designed to answer the needs of all users from writing simple SQL queries to developing complex databases. Is this still wrong? I can still insert the data into my DB.SQLite Expert Personal is a powerful tool designed to simplify the development of SQLite3 databases. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |