SYSCOLUMNS: Nullable vs Is_Nullable
The SYSCOLUMNS doc https://www.lianja.com/doc/index.php/SYSCOLUMNS has the following 2 definitions listed:
https://lh3.googleusercontent.com/Om...ztKkCDVklb5NyQ
and
https://lh4.googleusercontent.com/nY...l34FX80T40L0c6
What's the difference?
I can imagine a difference: in VFP there is no such thing as a NULL value of a table field. It can be empty, with a system-supplied default value, but it will never be NULL. So one of these might be that, and the other might be "this field cannot be set to NULL, and the record will not SAVE if it is."
I understand the NULL and NOT NULL SQL Constraints: On and Off flags. I don't understand these two.
Additionally, Nullable is list as N (2). I am puzzled.
thanks,
Hank