How do I implement Foreign key Constrain in Sqlite ?

[Milan Mehta]

How do I implement Foreign key in Sqlite ?
xaSqlite do not have facility to define Foreign key.
I tried creating database with Sqlitestudio and defined Foreign key. But Xailer do not respect that Foreign key and allowed a record to be deleted when dependency still exist !
Kindly guide us. Referential integrity is of paramount importance for any database management System.
TIA
Milan.

[ignacio]

Milan Mehta escribió el Mon, 11 November 2013 07:11How do I implement Foreign key in Sqlite ?
xaSqlite do not have facility to define Foreign key.
I tried creating database with Sqlitestudio and defined Foreign key. But Xailer do not respect that Foreign key and allowed a record to be deleted when dependency still exist !
Kindly guide us. Referential integrity is of paramount importance for any database management System.
TIA
Milan.
http://www.sqlite.org/foreignkeys.html
Regards

[Milan Mehta]

Do I have to issue any command to enable Foreign Key constrain in Xailer ?
I observe that xailer do not generate any error when deleting a record for which dependency exist (when Foreign key constrain is defined) !
Kindly guide.
Milan.

[ignacio]

Milan Mehta escribió el lun, 11 noviembre 2013 15:35Do I have to issue any command to enable Foreign Key constrain in Xailer ?
I observe that xailer do not generate any error when deleting a record for which dependency exist (when Foreign key constrain is defined) !
Kindly guide.
Milan.


Attached files

[Milan Mehta]

Great !
I incorporated following command in the application
:Execute("PRAGRAM foreign_keys = ON")
and it started working excellently ! Great relief.
Thanks a lot.
Milan.