[FB2.1]Master-Detail and correct usage of Foreign Key
Posted: 02.11.2010, 12:45
Hallo,
I have this scenario:
Master-Detail
Master have CachedUpdates = False
Detail Have CachedUpdate = True
On Master.BeforePost I do Detail.ApplyUpdates and works Ok.
I tried to understand usage of Foreign key and I add a Foreign Key on table Detail that refer on primary key of Master.
But, now when I try:Detail.ApplyUpdates, FB Raise exception because the key on Master is not present!
What is the correct usage of Foreign Key on ZeosLib?
Thanks
I have this scenario:
Master-Detail
Master have CachedUpdates = False
Detail Have CachedUpdate = True
On Master.BeforePost I do Detail.ApplyUpdates and works Ok.
I tried to understand usage of Foreign key and I add a Foreign Key on table Detail that refer on primary key of Master.
But, now when I try:Detail.ApplyUpdates, FB Raise exception because the key on Master is not present!
What is the correct usage of Foreign Key on ZeosLib?
Thanks