>I ultimately found that OLDVAL was returning .NULL. even though the field does NOT allow NULL (none of the fields in the database do).
Since this is a new record (never committed), what would you expect OLDVAL to return? .NULL. seems like as good an answer as any to me.
Erik Moore
Clientelligence