Page 1 of 1

MSSQL Cachedupdates and Autoinc

Posted: Mon 27 Dec 2004 00:30
by Perwe
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.

Re: MSSQL Cachedupdates and Autoinc

Posted: Mon 27 Dec 2004 08:22
by Ikar
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).