StrataFrame Forum

Problem saving a record in a replicated table.

http://forum.strataframe.net/Topic17354.aspx

By Aaron Young - 6/25/2008

Hi,

I have a SQL Server 2005 replicated database. Each table has a ROWGUID as required by SQL Server and this is present in the DDT and the business object. I can add and delete records correctly but when I try and edit and save an existing record I get an error saying that the ROWGUID field cannot be updated.  My update is not modifying the ROWGUID but it looks like the BO attempts to update the record with all field values - including the ROWGUID. The ROWGUID cant be updated under replication so I need to find a way of stopping the ROWGUID being updated during the edit and save operation.

Is there anyway to exclude the ROWGUID field when editing and saving?

Thanks in advance,

Aaron

By Greg McGuffey - 6/25/2008

Try setting the FieldsToExcludeFromUpdate property on the BO to exclude the GUID row.
By Aaron Young - 6/25/2008

Thanks Greg. That works perfectly and I should have seen it for myself! Feeling stupid now Smile
By Greg McGuffey - 6/25/2008

Glad that helped...and you see by looking through old posts that I've been in your situation many times!
By Trent L. Taylor - 6/25/2008

Thanks, Greg!  And there is nothing to feel "stupid" about at all...that is why this forum is here!