Do you guys really enforce Foreign Key Constraints in DB?

Question as above.

We still can link controllers together (Nested DataView etc) in COT application.

Regards
Justin
1 person has
this question
+1
Reply
  • The framework does not enforce the foreign keys by default. Your database engine does.

    The default mode of data input is pass-though. Each individual update, insert, and delete are forwarded to the database engine.

    If ODP (offline data processor) is enabled then deleting a record in a form view will check for details in DataView fields.

    Offline Sync will always verify foreign keys against controllers referenced by DataView fields.

    Learn about ODP and Offline Sync at https://www.youtube.com/watch?v=7iOha....
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated