Xailer & OZ Software

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.

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

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.

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

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