Problem saving a record in a replicated table.

StrataFrame Forum

Back

Problem saving a record in a replicated table.

Author	Message
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 6.9K	Thanks, Greg! And there is nothing to feel "stupid" about at all...that is why this forum is here!
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 16 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Glad that helped...and you see by looking through old posts that I've been in your situation many times!
	Reply Like 0
Aaron Young	Aaron Young posted 16 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 277, Visits: 1.1K	Thanks Greg. That works perfectly and I should have seen it for myself! Feeling stupid now
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 16 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	Try setting the FieldsToExcludeFromUpdate property on the BO to exclude the GUID row.
	Reply Like 0
Aaron Young	Aaron Young posted 16 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 277, Visits: 1.1K	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
	Reply Like 0