StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Problem saving a record in a replicated table.

Problem saving a record in a replicated table.

Aaron Young — Wed, 25 Jun 2008 19:23:58 GMT

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

RE: Problem saving a record in a replicated table.

Trent L. Taylor — Wed, 25 Jun 2008 19:23:58 GMT

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

RE: Problem saving a record in a replicated table.

Greg McGuffey — Wed, 25 Jun 2008 18:44:59 GMT

Glad that helped...and you see by looking through old posts that I've been in your situation many times!

RE: Problem saving a record in a replicated table.

Aaron Young — Wed, 25 Jun 2008 18:26:10 GMT

Thanks Greg. That works perfectly and I should have seen it for myself! Feeling stupid now :)

RE: Problem saving a record in a replicated table.

Greg McGuffey — Wed, 25 Jun 2008 18:01:43 GMT

Try setting the FieldsToExcludeFromUpdate property on the BO to exclude the GUID row.