Is it possible to have "Disconnected Recordset" kind of in memory table representation in Basic4Android?.
Actually i have some configurartion data in sqlite database.
I would like to load it when application starts and use it throughout app life cycle.
I have some tabular data in sqlite db.Instead of connecting to db every time i need data,i wold like to fetch data once and cache it in some local application store (data is actually static,so no need to worry about updates in database).
In VB,we use recordset in disconnected mode for this.so i am just checking is there anything equivalent of that in B4A..
You can use DBUtils.ExecuteMemoryTable to read the data into a memory table. Note that SQLite is very fast. In most cases there is no need to cache anything in memory.
Thanks Erel.
Actually the data i am reading from table is static in nature,so i thought why to execute query time and again to fetch the data that wont change.