dbfpy - cannot store new record

Laszlo Nagy gandalf at shopzeus.com
Thu May 21 17:53:38 CEST 2009


Here is the next problem. For boolean/logical fields, I can set their 
value to True/False easily. However, setting NULL seems impossible:

rec = tbl.newRecord()
rec["SOMEFIELD1"] = True # Works fine
rec["SOMEFIELD2"] = False # Works fine
rec["SOMEFIELD3"] = None # Will store False
rec["SOMEFIELD3"] = 0 # Will store False
rec["SOMEFIELD3"] = "" # Will store False
rec["SOMEFIELD3"] = chr(32) # Will store False
rec["SOMEFIELD3"] = chr(0) # Will store False
rec.store()

Strange thing: if I do not set the value of a numeric field, it becomes 
NULL. The same thing I cannot do for logical fields: if I do not set the 
value of a logical field, it becomes an invalid value, denoted with a 
question mark.

Any ideas?

Thanks,

   Laszlo




More information about the Python-list mailing list