Page 1 of 1

MyDAC Master-Detail relationship bug

Posted: Mon 20 Oct 2008 15:37
by swierzbicki
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

Posted: Wed 22 Oct 2008 06:41
by Challenger
This behavior was changed in 5.50.0.36. Please try to set the DBAccess.RefreshParamsOnInsert variable to True.

Posted: Wed 22 Oct 2008 10:12
by swierzbicki
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 :roll:

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

Posted: Mon 25 Jul 2011 12:24
by swierzbicki
Behaviour broken since MyDac Version 6.10.0.9 (20-Jul-2011).
Please re introduce this behaviour.