>Yes, that's why I spent over an hour tearing hair out - I checked every which way to Sunday to verify the values but never confirmed until desperate what OLDVAL was returning .NULL.
Don't really know what to suggest - just a couple of SWAGs:
- is it possible your table is corrupted, or somehow actually contains a .NULL. even though it should not be possible?
- has the table record pointer been at EOF() at any time?
- any sort of database trigger etc. in place?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up