I'm starting development of my assignment which is URLyBird 1.2.1. It mentions recNo(record numbers) as a sort of primary key to the data file. Can this value just be generated by a unique sequence of rows of data in the file(other than header rows)? Or is it supposed to represent the actual offset from the beginning of the file to a particular record? I could see both values being calculated at application startup, but which is more valid?
Jeroen T Wenting
posted 11 years ago
It's up to you really. The first option is more in line with what real databases do, and makes the application overall a LOT easier to control as you only need to do the conversion to file location of the record in a single location (rather than all over the place).