Hi,

I don't use the DDT and let SF's standard CRUD processing do the heavy lifting. So, when I change a column in a row and save the change every column in the BO is included in the update irrespective of if they have been changed or not. What I would prefer is for the Update command to only include in the Update the column(s) that have changed. I know I can achieve what I want by adding entries in the ExcludeFromUpdate list or using my own stored proc to do the update but I was hoping there may be a 'magic property' somewhere that can turn this facility on.

Cheers, Peter

Also, Edhy, using CRUD is faster than using standard UPDATE commands.  The parger the table, number of columns, and database size, the more significant the performance becomes.  To put it in perspective, we use INSERT and UPDATE sprocs for every single BO in every application that we write (except for the few times that we want to sidestep the standard update logic).  There is really no downside to creating UPDATE and INSERT sprocs...unless you consider performance gains a downside

Thank you guys, much appreciated all the explanations.

Edhy Rijo