Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLDVAL return .NULL.
Message
From
18/06/2001 09:58:57
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
18/06/2001 09:50:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00520390
Message ID:
00520574
Views:
11
>As I've learned, it surely seems to.
>
>But I wonder why when the table does not have NULL permissable in any of its fields. I would have thought that an APPEND BLANK in that case would surely put theequivalent of EMPTY() into each field.
>
>Regards
>JimN

I pressume the reasoning of the VFP team is something like this: "the previous value for this field is undefined". This makes sense, in a way...

As for programming in actual practice, I found I had to use NVL() in some cases, to avoid certain error messages.

Regards, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform