Re: [GENERAL] was field updated

2009-07-13 Thread Sim Zacks
> I don't get it, > you mean even if the field contain some data, it would be set to null > if your update statement do not update the field? Exactly. In my example, I have a record that shows current status and can be updated by multiple processes. The only thing that is relevant when I look at i

[GENERAL] was field updated

2009-07-13 Thread Sim Zacks
I need to know if a field was updated in an update statement, even if it was updated to the same value that it already contained. Basically, I want the field to be automatically set to null if the update statement didn't manually set it to something. I could not figure out how to do this with a