General information
Category:
Coding, syntax & commands
Title:
OLDVAL return .NULL.
Hi all,
I just had a frustrating hour or more.
A form with table buffering for specific table (of a .DBC), MULTILOCKS ON, etc...
An APPEND BLANK, set the PK field, then SETFLDSTATE on PK field so it looks UNCHANGED.
In the Valid() of my subclassed TextBox I was comparing This.Value to the field's OLDVAL. Because it is a subclass the field can be anything so I deconstruct the ControlSource to construct the OLDVAL statement and I include the alias as a parameter.
When the input field remained untouched (just tabbed through them) the compare never returned TRUE.
I ultimately found that OLDVAL was returning .NULL. even though the field does NOT allow NULL (none of the fields in the database do).
Is this normal? Checking OLDVAL in both VFP Help and Hacker's doesn't mention this.
Thanks in advance for comments/ideas
JimN
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only