search

siara-cc / esp32_arduino_sqlite3_lib

Sqlite3 Arduino library for ESP32
Apache License 2.0
350 stars 66 forks source link

How to get searched fields contents? #5

Closed williamesp2015 closed 5 years ago

williamesp2015 commented 5 years ago

sqlite3_initialize(); if (openDb("/sd/DATA1.db", &db1)) { How to make query without using rc = db_exec(db1, "Select * from FIELD? where name = '???'"); to be able to access selected records contents sqlite3_close(db1); }

siara-cc commented 5 years ago

For using select sql statement, db_exec() or db_prepare_v2() has to be used. If you need example for db_prepare_v2(), please see sqlite3_webquery example.