MyDAC Master-Detail relationship bug

swierzbicki · Post by **swierzbicki** » Mon 20 Oct 2008 15:37

Hi,

My customer reported me that Master-Detail relationship are no more working like before. After some investigations it looks like this issue was introduced into the 5.50.x.x branch (did correctly worked with the 5.20.x.x branch).

How to reproduce it ?
Install MyDac 5.20.0.15
Start D2007 , open and run project "MyDacDemo"
Select the "MasterDetail" demo
In master table, insert a new record
In DeptNo enter 10 and choose another field within the same record

Act : the detail table is displaying records (that's good)

Now close Delphi
Uninstall MyDac 5.20.0.15 and install MyDac 5.50.0.39
Start D2007 , open and run project "MyDacDemo"
Select the "MasterDetail" demo
In master table, insert a new record
In DeptNo enter 10 and choose another field within the same record

Act : the detail table is still empty
Expt : it should be filled with records

When using Debug Mode, :DEPTNO parameter stay always to null :
:DEPTNO(Integer,IN)=

Can you provide me a fix for this ?

Thank you in advance

Ps : this bug is also present in 5.70.x.x branch

Challenger · Post by **Challenger** » Wed 22 Oct 2008 06:41

This behavior was changed in 5.50.0.36. Please try to set the DBAccess.RefreshParamsOnInsert variable to True.

swierzbicki · Post by **swierzbicki** » Wed 22 Oct 2008 10:12

It worked ! but why the hell didn't you communicate on this ? It tooks me a lot of time to found this... and this silencly break my application

IMHO You should add this option RefreshParamsOnInsert (true by default) at the TMyConnection level.

swierzbicki · Post by **swierzbicki** » Mon 25 Jul 2011 12:24

Behaviour broken since MyDac Version 6.10.0.9 (20-Jul-2011).
Please re introduce this behaviour.