>>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.

That reasoning is possible, Hilmar. But the record technically does 'exist', being the result of an APPEND BLANK and in this case the fields have 'known' values. At least that makes sense to me.

Regards,
JimN