Read bug in Example EDB_SDCARD_Optimized.ino

[giapoldo]

Running selectAll() function returns the last record inserted for all reads. I tested printing the address that is being read and it's correct. I even modified the struct to hold strings, and the data generation in createRecords() to create it in string form also, to check for the data on my computer. The data is all on the SD, but reading from the table still only returns the last value inserted even for a selectAll().

I'm working on an Sparkfun ESP32 Thing. I tested if SD readings were correct by running the SD lib examples and they work fine.

Any help in how to debug is much appreciated.

[ianwillianb]

For ESP32 use SD.open(path_file, "r+").
If you use SD.open(path_file, FILE_WRITE") it will overwrite the file after reboot.
However r+ means open the file in read and write mode setting the pointer to the beginning of the file.
If you use FILE_APPEND, the seek() method won't work, cause the pointer will always point to the end of the file.