I am working with esp32 and SD card, and I have tried to upload SD card example (https://github.com/siara-cc/esp32_arduino_sqlite3_lib/tree/master/examples/sqlite3_sdspi), which works correctly. Then, I wanted to create a table in one of the two provided databases and insert one row. The answer was always that I was trying to add a table that already exists - which would then close db and return from the setup loop. In fact, when I open db in some of the viewers, I see the table is created and the value is inside, which sounds insane since that part of the code is not even run (return statement).
Second issue I saw is that when I try to insert in the table that exists, it is done two times (I get only one log and two records later in db viewer).
Hi,
I am working with esp32 and SD card, and I have tried to upload SD card example (https://github.com/siara-cc/esp32_arduino_sqlite3_lib/tree/master/examples/sqlite3_sdspi), which works correctly. Then, I wanted to create a table in one of the two provided databases and insert one row. The answer was always that I was trying to add a table that already exists - which would then close db and return from the setup loop. In fact, when I open db in some of the viewers, I see the table is created and the value is inside, which sounds insane since that part of the code is not even run (return statement).
Second issue I saw is that when I try to insert in the table that exists, it is done two times (I get only one log and two records later in db viewer).