I am trying to use cachedupdates on a Master/Detail table where the relation key come from MSSQL autoinc field. When I applyupdates to master I get the new key value and then also the detail record is lost because different master/detail key.
Is it posible to change key value in a detail querry after recieving the value from MSSQL.
MSSQL Cachedupdates and Autoinc
Re: MSSQL Cachedupdates and Autoinc
Unfortunately Master-Detail quite poor adjusts with CashedUpdates. Probably in your case as a solution you can generate Identity in any way on client side (for example, thru guid).