[FB2.1]Master-Detail and correct usage of Foreign Key

[louis]

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

[louis]

What is the correct usage of Foreign Key on ZeosLib?

I used correctly but the is a bug on Master/Detail that losts detail on applyUpdates, see http://zeosbugs.firmos.at/view.php?id=185

[delphi2pk]

Dear louis,

Here is a simple solution.

Before applying updateds disablecontrols from both queries and enable it again after comitting.

Give it a try.

[louis]

Before applying updateds disablecontrols from both queries and enable it again after comitting.

Thanks a lot, seems to work correctly.