StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Only update changed field

RE: Only update changed field

Keith Chisarik — Sat, 24 Jul 2010 23:07:27 GMT

nevermind :)

Array.Resize(boInventoryMaster.FieldsToExcludeFromUpdate, 1)

boInventoryMaster.FieldsToExcludeFromUpdate.SetValue("invm_batch", 0)

Only update changed field

Chan — Sat, 24 Jul 2010 23:07:27 GMT

Hi,
I found that, SF BO generate update statement for all fields no matter has been changed or not when editing.

Anyway to configure BO to generate update SQL only for changed field?

Thank you

RE: Only update changed field

Keith Chisarik — Sat, 24 Jul 2010 22:43:21 GMT

Can you provide a code snippet to set the FieldsToExcludeFromUpdate property programatically?

I need to set the property to all fields but a few so the BO's save is more efficient and then clear it again.

RE: Only update changed field

Trent L. Taylor — Wed, 15 Aug 2007 14:33:35 GMT

This is why we added the FieldsToExcludeFromInsert and FieldsToExcludeFromUpdate properties to the BO. This allows to you exclude fields from updating. At present, there is not an automated way or a flag to only update changed fields. There are a number of ways that these properties can be used, and they can be set programmatically at run-time as well. So you have the ability to do this through these properties.