Select to view content in your preferred language

Deleting a value in a FGDB FC Attribute Table: Why does the value get set to empty, instead of null?

1087
4
Jump to solution
11-30-2022 09:44 AM
Bud
by
Esteemed Contributor

In an FGDB FC, I can delete a value from the Attribute Table.

Before:

Bud_0-1669829779217.png

Double click the cell. Hit the delete key. Press ENTER.

After:
Bud_1-1669829840734.png

I'm surprised that the deleted value resolved to Empty, instead of null.

In comparison, an enterprise geodatabase like Oracle would have resolved to null.

  1. Is setting a FGDB value to Empty really a good design choice?
  2. Is Empty the right terminology? Or is it something else, such as a hidden space?
  3. How would we query for Empty values using SQL?

Thanks.

 

ArcGIS Pro 3.0.3

 

0 Kudos
1 Solution

Accepted Solutions
DanPatterson
MVP Esteemed Contributor

Because it is an empty text string not None.  There is a difference.  There is only one None.

pictures

null0.pngnull1.png


... sort of retired...

View solution in original post

4 Replies
DanPatterson
MVP Esteemed Contributor

Because it is an empty text string not None.  There is a difference.  There is only one None.

pictures

null0.pngnull1.png


... sort of retired...
Bud
by
Esteemed Contributor

OK. 

I guess I'm just more familiar with Oracle EGDBs. In Oracle, there is no concept of None or Empty. Only null. 

0 Kudos
DanPatterson
MVP Esteemed Contributor

Null is None by another name.  An empty string is a different object, it exists as a string just with no characters.

Think of "None/ <null> " as the object that has yet to become what is in the field.

Philosophy has discussions of None-ness  🤔


... sort of retired...
0 Kudos
DanPatterson
MVP Esteemed Contributor

If it answered your question, please mark the response as Accepted


... sort of retired...
0 Kudos