Glen Iris wrote:I notice that none of the records in my database file have anything in the validity field.
I was thinking of initially assuming they are all valid and set them all to 1 when I first read them in. I would also write to the db file to mark them as valid records if they are not explicitly marked as invalid
Since 0 is supposed to mean "valid", doesn't that mean that they are all flagged as valid already, and you don't need to assume anything? And so, if that's the case, there's no need to write anything back (unless the records change).
Again, I feel I'm missing something (and I apologise if I am), but you seem to be making a distinction between having "nothing" in the validity field, and having zero. Surely these are the same case?