Little problem with master-detail
Posted: Mon 21 Nov 2005 17:35
Hi, I've been fiddling with myDAC for the past few weeks, almost everything works (except http://crlab.com/forums/viewtopic.php?p=7506).
And once again using myDAC MasterDetail .net sample works fine when displaying the relevant detail data, when I add a record to a detail table, it binds it to the record id=1 not id=currently selected master record.
The code in detailQuery "WHERE Id = :Id" is not "where detail.Id = master.Id", I understand that's because you set that using MasterSource etc properties.
So tell me what am doing wrong that it doesn't INSERT proper Id 9Id always =1)?
And once again using myDAC MasterDetail .net sample works fine when displaying the relevant detail data, when I add a record to a detail table, it binds it to the record id=1 not id=currently selected master record.
The code in detailQuery "WHERE Id = :Id" is not "where detail.Id = master.Id", I understand that's because you set that using MasterSource etc properties.
So tell me what am doing wrong that it doesn't INSERT proper Id 9Id always =1)?